Skip to content

📊 Assets & Pricing

Global financial instruments and their pricing sources. Assets are shared across all users — only the transactions referencing them are user-specific.

📐 ER Diagram

erDiagram
    ASSET ||--o{ TRANSACTION : "referenced in"
    ASSET ||--o{ PRICE_HISTORY : "has history"
    ASSET ||--|| ASSET_PROVIDER_ASSIGNMENT : "priced by"

    ASSET {
        int id PK
        string display_name
        string identifier_isin
        string identifier_ticker
        enum asset_type "STOCK, ETF, BOND..."
        string currency
        json classification_params
    }

    PRICE_HISTORY {
        int asset_id FK
        date date
        decimal close_price
        decimal open_price
        decimal high_price
        decimal low_price
        int volume
    }

    ASSET_PROVIDER_ASSIGNMENT {
        int asset_id FK
        string provider_code
        string identifier
        json provider_params
    }

📋 Tables

📦 ASSET

Global definition of a financial instrument. Each asset has a unique combination of identifiers (ISIN, ticker) and belongs to an Asset Type.

  • 📋 classification_params (JSON): Stores flexible metadata like Sector, Geography, and Industry without requiring schema changes.
  • 💰 currency: The asset's native currency (e.g., USD for Apple, EUR for ASML).

📈 PRICE_HISTORY

Daily OHLCV (Open, High, Low, Close, Volume) price data for each asset. Populated by asset pricing providers.

🔌 ASSET_PROVIDER_ASSIGNMENT

Decouples the asset from its data source. This table configures which provider to use for fetching prices and metadata.

  • 📋 Example: "Use Yahoo Finance (yfinance) for Apple (AAPL)"
  • ⚙️ provider_params (JSON): Provider-specific configuration (e.g., exchange suffix, custom identifier).

The provider system uses the Registry Pattern for extensibility.