Table Details
| Property | Value |
|---|---|
| Table Name | solana.perpetuals.markets |
| Table Status | Production-Ready |
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. |
| market_index | NUMBER(38,0) | Protocol market index. |
| market_symbol | VARCHAR(16777216) | Market symbol (e.g. SOL-USD). |
| base_asset_symbol | VARCHAR(16777216) | 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(16777216) | 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. |
| _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. |