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. | |
| total_volume_24h_usd | Reported trailing-24h trading volume in USD. | |
| cumulative_volume_usd | Reported cumulative trading volume in USD to date. | |
| total_tvl_usd | Total value locked in USD. | |
| total_open_interest_usd | Total open interest in USD (long plus short). NULL when the venue does not report open interest. | |
| num_markets | Number of markets listed on the platform at snapshot time. | |
| extra_fields | Protocol-specific platform fields as a JSON object. Keys: loss_refund_pool_size_usd (reported loss-refund pool size in USD; the program wound down on 2026-04-19), loss_refund_refunded_24h_usd (reported trailing-24h loss refunds in USD). | |
| 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). |