Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| project | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. | |
| protocol | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. | |
| version | Schema version discriminator. | |
| chain | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. | |
| snapshot_ts | Hour-truncated snapshot timestamp (UTC) from the metadata API. | |
| partition_date | Snapshot date (UTC), used for partitioning. | |
| ticker | Market ticker (for example, BTC or XAU). | |
| name | Market display name. | |
| mark_price | Mark price at snapshot time. | |
| volume_24h_usd | Trailing-24h volume in USD for this market. | |
| long_open_interest_usd | Long open interest in USD. | |
| short_open_interest_usd | Short open interest in USD. | |
| total_open_interest_usd | Total open interest in USD (long plus short). NULL when the venue does not report open interest. | |
| funding_rate | Funding rate at snapshot time. | |
| extra_fields | Protocol-specific per-market fields as a JSON object. Keys: funding_interval_s (funding interval in seconds); base_spread_bps (base spread in basis points); quote_updated_at (UTC time quotes were last updated); quote_base_bid, quote_base_ask (best bid/ask); quote_size_1k_bid/ask, quote_size_100k_bid/ask, quote_size_1m_bid/ask (bid/ask prices for 1k, 100k, and 1m-notional quotes). | |
| unique_key | Unique record key. | |
| ingested_at | Data ingestion timestamp. | |
| _created_at | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. | |
| _updated_at | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |