| activity_date | | Activity date (UTC). |
| 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 | | Protocol contract version (Variational v1; GMX v1 and v2). |
| 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. |
| total_tvl_usd | | Total value locked in USD. |
| total_volume_usd | | Total trading volume in USD on the day (daily sum). NULL when the venue does not report a daily volume. |
| total_volume_24h_usd | | Reported trailing-24h trading volume in USD. |
| cumulative_volume_usd | | Reported cumulative trading volume in USD to date. |
| total_open_interest_usd | | Total open interest in USD (long plus short). NULL when the venue does not report open interest. |
| long_open_interest_usd | | Long open interest in USD. |
| short_open_interest_usd | | Short open interest in USD. |
| total_revenue_usd | | Daily protocol revenue in USD (the protocol’s retained share of fees). |
| cumulative_revenue_usd | | Cumulative protocol revenue to date, in USD. |
| total_fees_usd | | Total protocol fees charged on the day, in USD. |
| cumulative_fees_usd | | Cumulative protocol fees to date, in USD. |
| trade_count | | Number of trades on the day. NULL when the venue does not expose a trade count. |
| liquidations_count | | Number of liquidations on the day. NULL when the venue does not expose a liquidations count. |
| deposit_count | | Number of user deposits on the day. |
| deposit_usd | | Total user deposit value in USD on the day. |
| withdrawal_count | | Number of user withdrawals on the day. |
| withdrawal_usd | | Total user withdrawal USD on the day. |
| active_users | | Distinct active users on the day. |
| extra_fields | | Protocol-specific daily metrics as a JSON object. Keys: tvl_settlement_pools_usd, tvl_olp_vault_usd, tvl_treasury_usd (on-chain TVL by component); settlement_count, distinct_rfqs, batch_count, settlement_cashflow_usdc (V2 settlement activity; cashflow is funding plus realized PnL, not trade volume); pools_created, pools_created_cumulative (settlement pools from the factory). |
| unique_id | | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _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). |
