Table Details
| Property | Value |
|---|---|
| Table Name | solana.perpetuals.position_changes |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, txn_id, unique_id |
| Clustering Key(s) | block_timestamp::date, market_symbol |
| Search Optimization | txn_id, 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. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the event. |
| block_date | DATE | Calendar date of the event (UTC). |
| block_slot | NUMBER(38,0) | Solana block slot of the event. |
| txn_id | VARCHAR(16777216) | Transaction signature. |
| unique_id | VARCHAR(16777216) | Allium unique identifier for the row. |
| leg_id | VARCHAR(16777216) | Identifier for this position leg within the transaction. |
| trader | VARCHAR(44) | Address of the trader whose position changed. |
| market_symbol | VARCHAR(16777216) | Market symbol (e.g. SOL-USD). |
| side | VARCHAR(16777216) | Position side (long or short). |
| action | VARCHAR(16777216) | Type of change: increase, decrease, or liquidation. |
| size_base | NUMBER(38,9) | Absolute base-asset size of the change. |
| signed_base_delta | NUMBER(38,9) | Signed change in base-asset position (positive opens/increases a long). |
| prev_base_amount | NUMBER(38,9) | Base-asset position size before this change. |
| new_base_amount | NUMBER(38,9) | Base-asset position size after this change. |
| size_usd | NUMBER(38,6) | Notional USD size of the change. |
| price_usd | NUMBER(38,6) | Execution price in USD. |
| fee_usd | NUMBER(38,6) | Total fee paid for this change, 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. |