> ## 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.

# Market Overview

### 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).                                                                                           |