Table Details
| Property | Value |
|---|---|
| Table Name | solana.perpetuals.positions_daily |
| Table Status | Production-Ready |
| Clustering Key(s) | activity_date, market_index |
| Search Optimization | trader |
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) of the snapshot. |
| trader | VARCHAR(44) | Address of the trader. |
| market_index | NUMBER(38,0) | Protocol market index. |
| market_symbol | VARCHAR(16777216) | Market symbol (e.g. SOL-USD). |
| side | VARCHAR(16777216) | Position side (long or short). |
| size_base | NUMBER(38,9) | Position size in base-asset units. |
| price_usd | NUMBER(38,6) | Mark or oracle price in USD used to value the position. |
| position_value_usd | NUMBER(38,6) | Notional USD value of the position. |
| entry_px | NUMBER(38,6) | Average entry price in USD. |
| liquidation_price | NUMBER(38,6) | Estimated liquidation price in USD. |
| margin_used | NUMBER(38,6) | Margin allocated to this position, 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. |