Table Details
| Property | Value |
|---|---|
| Table Name | solana.perpetuals.open_interest_daily |
| Table Status | Production-Ready |
| Clustering Key(s) | activity_date, market_index |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | The perpetuals project. |
| protocol | VARCHAR(16777216) | The specific protocol within the project. |
| version | VARCHAR(16777216) | Protocol version. |
| chain | VARCHAR(16777216) | Blockchain network. |
| activity_date | DATE | Calendar date (UTC) this daily record aggregates. |
| market_index | NUMBER(38,0) | Protocol market index. |
| market_symbol | VARCHAR(16777216) | Market symbol (e.g. SOL-USD). |
| market_status | VARCHAR(16777216) | Market status as of this date. |
| price_usd | NUMBER(38,6) | USD mark or oracle price used to value open interest on this date. |
| open_interest_usd | NUMBER(38,6) | Open interest in USD (may match total or a protocol-reported figure). |
| long_open_interest_usd | NUMBER(38,6) | Notional USD value of open long positions. |
| short_open_interest_usd | NUMBER(38,6) | Notional USD value of open short positions. |
| total_open_interest_usd | NUMBER(38,6) | Combined long and short open interest in USD. |
| extra_fields | VARIANT | Protocol-specific fields not promoted to first-class columns. |
| _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. |