Table Details
| Property | Value |
|---|---|
| Table Name | avalanche.perpetuals.open_interest |
| Table Status | Production-Ready |
| Unique Key | unique_id |
avalanche.perpetuals.open_interest has one row per GMX v2 market per UTC day. funding_rate and premium are null. The latest day includes activity up to the latest refresh.
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| activity_date | DATE | UTC calendar day. The latest day includes activity up to the latest refresh. |
| project | VARCHAR(16777216) | 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 | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| version | VARCHAR(16777216) | Protocol version. |
| chain | VARCHAR(16777216) | 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 | NUMBER(38,0) | Protocol-native numeric identifier of the trading pair. Used by the protocol’s contracts to reference this market. |
| market_symbol | VARCHAR(16777216) | Market symbol (e.g. SOL-USD). |
| from_symbol | VARCHAR(16777216) | Symbol of the base asset being traded (the asset whose price the market tracks). |
| to_symbol | VARCHAR(16777216) | Symbol of the quote asset the market is denominated in. |
| long_open_interest_usd | NUMBER(38,6) | Long open interest in USD. |
| short_open_interest_usd | NUMBER(38,6) | Short open interest in USD. |
| total_open_interest_usd | NUMBER(38,6) | Total open interest in USD (long plus short). NULL when the venue does not report open interest. |
| funding_rate | NUMBER(38,18) | Funding rate for the interval (protocol-native units). |
| premium | NUMBER(38,18) | Premium of the mark price over the index price, expressed in protocol-native units. Drives the funding rate. |
| mark_price_usd | NUMBER(38,6) | Mark price of the market in USD at the end of the activity date. |
| extra_fields | VARIANT | JSON object containing additional protocol-specific fields for this market that are not part of the standard schema. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record. Stable across full refreshes. |
| _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. |
Sample Query
SELECT *
FROM avalanche.perpetuals.open_interest
WHERE activity_date = '2026-10-01'
LIMIT 100;