Table Details
| Property | Value |
|---|---|
| Table Name | megaeth.perpetuals.open_interest |
| Table Status | Beta 🌱 |
| Unique Key | unique_id |
| Clustering Key(s) | activity_date, market_symbol |
megaeth.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. |
| project | VARCHAR(16777216) | The perpetuals project. gmx on this table. |
| protocol | VARCHAR(16777216) | The protocol within the project. |
| version | VARCHAR(16777216) | Protocol contract version. |
| chain | VARCHAR(16777216) | Blockchain network. |
| pair_index | NUMBER(38,0) | Venue pair index. Null for GMX. |
| market_symbol | VARCHAR(16777216) | Index symbol for the market. Not unique across GMX markets. |
| from_symbol | VARCHAR(16777216) | Base symbol when the venue uses a from-to pair. Null for GMX. |
| to_symbol | VARCHAR(16777216) | Quote symbol when the venue uses a from-to pair. Null for GMX. |
| 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) | Long plus short open interest in USD. |
| funding_rate | NUMBER(38,18) | Last funding rate of the day. Null for GMX. |
| premium | NUMBER(38,18) | Last premium of the day. Null for GMX. |
| mark_price_usd | NUMBER(38,6) | Last mark of the day in USD. |
| extra_fields | VARIANT | Protocol-specific values for this market and day. |
| unique_id | VARCHAR(16777216) | Unique identifier for the row. |
| _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 megaeth.perpetuals.open_interest
WHERE activity_date = '2026-10-01'
LIMIT 100;