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. |
| market_index | INTEGER | Protocol market index. |
| market_symbol | VARCHAR | Market symbol (e.g. SOL-USD). |
| base_asset_symbol | VARCHAR | Symbol of the market’s base asset. |
| is_prediction_market | BOOLEAN | Whether this market is a prediction market rather than a classic perp. |
| market_status | VARCHAR | Current status of the market (e.g. active, paused, settled). |
| is_settled | BOOLEAN | Whether the market has been settled. |
| initialized_at | TIMESTAMP_NTZ(9) | Timestamp when the market was initialized. |
| settled_at | TIMESTAMP_NTZ(9) | Timestamp when the market was settled, if applicable. |
| last_state_at | DATE | Date of the most recent market-state observation. |
| extra_fields | VARIANT | Protocol-specific fields not promoted to first-class columns. |