| activity_date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this daily record aggregates. |
| project | VARCHAR(16777216) | Project or application associated with this record. |
| project_name | VARCHAR(16777216) | Human-readable name of the project. |
| protocol | VARCHAR(16777216) | Protocol (and version, if applicable) associated with this record. |
| vertical | VARCHAR(16777216) | Vertical classification of the protocol (e.g. dex). |
| token_price_usd | FLOAT | USD price of the protocol’s token on this date, when applicable. |
| market_cap_usd | FLOAT | USD market capitalization of the protocol’s token, when applicable. |
| total_volume_usd | FLOAT | Total USD swap volume for the day. |
| avg_usd_amount | FLOAT | Average USD value per swap for the day. |
| active_users | NUMBER(38,0) | Distinct addresses that swapped on this date. |
| total_transactions | NUMBER(38,0) | Total number of swap transactions on this date. |
| tvl_usd | FLOAT | Total value locked in the protocol’s pools in USD on this date. |
| active_liquidity_pools | NUMBER(38,0) | Distinct liquidity pools with activity on this date. |
| distinct_tokens_sold | NUMBER(38,0) | Distinct tokens sold on this date. |
| distinct_tokens_bought | NUMBER(38,0) | Distinct tokens bought on this date. |
| total_stablecoin_volume_usd | FLOAT | USD volume of swaps involving a stablecoin on either side. |
| total_stablecoin_to_stablecoin_volume_usd | FLOAT | USD volume of stablecoin-to-stablecoin swaps. |
| total_stablecoin_sold_volume_usd | FLOAT | USD volume where a stablecoin was the token sold. |
| total_stablecoin_bought_volume_usd | FLOAT | USD volume where a stablecoin was the token bought. |
| total_native_volume_usd | FLOAT | USD volume of swaps involving the native token on either side. |
| total_native_sold_volume_usd | FLOAT | USD volume where the native token was sold. |
| total_native_bought_volume_usd | FLOAT | USD volume where the native token was bought. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
