> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Overview

### Table Columns

| Column Name                | Data Type | Description                                                                                                                                                                                                                                                                                                                                                                                               |
| -------------------------- | --------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 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).                                                                                                                                                                                                                                                |