| activity_date | DATE | Activity date (UTC). |
| project | VARCHAR(16777216) | 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 | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| version | VARCHAR(16777216) | Protocol contract version (Variational v1; GMX v1 and v2). |
| chain | VARCHAR(16777216) | 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 | FLOAT | Total value locked in USD. |
| total_volume_usd | NUMBER(38,6) | Total trading volume in USD on the day (daily sum). NULL when the venue does not report a daily volume. |
| total_volume_24h_usd | NUMBER(38,6) | Reported trailing-24h trading volume in USD. |
| cumulative_volume_usd | NUMBER(38,6) | Reported cumulative trading volume in USD to date. |
| total_open_interest_usd | NUMBER(38,6) | Total open interest in USD (long plus short). NULL when the venue does not report open interest. |
| long_open_interest_usd | NUMBER(38,6) | Long open interest in USD. |
| short_open_interest_usd | NUMBER(38,6) | Short open interest in USD. |
| total_revenue_usd | FLOAT | Daily protocol revenue in USD (the protocol’s retained share of fees). |
| cumulative_revenue_usd | FLOAT | Cumulative protocol revenue to date, in USD. |
| total_fees_usd | NUMBER(38,6) | Total protocol fees charged on the day, in USD. |
| cumulative_fees_usd | NUMBER(38,6) | Cumulative protocol fees to date, in USD. |
| trade_count | NUMBER(38,0) | Number of trades on the day. NULL when the venue does not expose a trade count. |
| liquidations_count | NUMBER(38,0) | Number of liquidations on the day. NULL when the venue does not expose a liquidations count. |
| deposit_count | NUMBER(38,0) | Number of user deposits on the day. |
| deposit_usd | NUMBER(38,6) | Total user deposit value in USD on the day. |
| withdrawal_count | NUMBER(38,0) | Number of user withdrawals on the day. |
| withdrawal_usd | NUMBER(38,6) | Total user withdrawal USD on the day. |
| active_users | NUMBER(38,0) | Distinct active users on the day. |
| extra_fields | VARIANT | 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 | VARCHAR(16777216) | 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_NTZ(9) | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | TIMESTAMP_NTZ(9) | 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). |
