Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR | The perpetuals project. |
| protocol | VARCHAR | The specific protocol within the project. |
| version | VARCHAR | Protocol version. |
| chain | VARCHAR | Blockchain network. |
| activity_date | DATE | Calendar date (UTC) this daily record aggregates. |
| market_index | INTEGER | Protocol market index. |
| market_symbol | VARCHAR | Market symbol (e.g. SOL-USD). |
| market_status | VARCHAR | Market status as of this date. |
| price_usd | FLOAT | USD mark or oracle price used to value open interest on this date. |
| open_interest_usd | FLOAT | Open interest in USD (may match total or a protocol-reported figure). |
| long_open_interest_usd | FLOAT | Notional USD value of open long positions. |
| short_open_interest_usd | FLOAT | Notional USD value of open short positions. |
| total_open_interest_usd | FLOAT | Combined long and short open interest in USD. |
| extra_fields | VARIANT | Protocol-specific fields not promoted to first-class columns. |