Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| activity_date | The date for which metrics are being calculated. Only includes completed days. | |
| 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 version. | |
| 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. | |
| pair_index | Protocol-native numeric identifier of the trading pair. Used by the protocol’s contracts to reference this market. | |
| market_symbol | Market symbol (e.g. SOL-USD). | |
| from_symbol | Symbol of the base asset being traded (the asset whose price the market tracks). | |
| to_symbol | Symbol of the quote asset the market is denominated in. | |
| 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 for the interval (protocol-native units). | |
| premium | Premium of the mark price over the index price, expressed in protocol-native units. Drives the funding rate. | |
| mark_price_usd | Mark price of the market in USD at the end of the activity date. | |
| extra_fields | JSON object containing additional protocol-specific fields for this market that are not part of the standard schema. | |
| unique_id | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record. Stable across full refreshes. |