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

### 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.                                                                                                                                                                                                                                                                                                                                                                       |
| ticker                     |           | Market ticker (for example, BTC or XAU).                                                                                                                                                                                                                                                                                                                                                                          |
| name                       |           | Market display name.                                                                                                                                                                                                                                                                                                                                                                                              |
| mark\_price                |           | Mark price at snapshot time.                                                                                                                                                                                                                                                                                                                                                                                      |
| volume\_24h\_usd           |           | Trailing-24h volume in USD for this market.                                                                                                                                                                                                                                                                                                                                                                       |
| long\_open\_interest\_usd  |           | Long open interest in USD.                                                                                                                                                                                                                                                                                                                                                                                        |
| short\_open\_interest\_usd |           | Short open interest in USD.                                                                                                                                                                                                                                                                                                                                                                                       |
| total\_open\_interest\_usd |           | Total open interest in USD (long plus short). NULL when the venue does not report open interest.                                                                                                                                                                                                                                                                                                                  |
| funding\_rate              |           | Funding rate at snapshot time.                                                                                                                                                                                                                                                                                                                                                                                    |
| extra\_fields              |           | Protocol-specific per-market fields as a JSON object. Keys: funding\_interval\_s (funding interval in seconds); base\_spread\_bps (base spread in basis points); quote\_updated\_at (UTC time quotes were last updated); quote\_base\_bid, quote\_base\_ask (best bid/ask); quote\_size\_1k\_bid/ask, quote\_size\_100k\_bid/ask, quote\_size\_1m\_bid/ask (bid/ask prices for 1k, 100k, and 1m-notional quotes). |
| 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).                                                                                                                                                                                                                                                        |