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. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the funding-rate update. |
| block_slot | INTEGER | Solana block slot of the update. |
| txn_id | VARCHAR | Transaction signature that recorded this funding update. |
| unique_id | VARCHAR | Allium unique identifier for the row. |
| funding_timestamp | TIMESTAMP_NTZ(9) | Venue timestamp of the funding interval this rate applies to. |
| funding_date | DATE | Calendar date (UTC) of the funding interval. |
| market_index | INTEGER | Protocol market index. |
| market_symbol | VARCHAR | Market symbol (e.g. SOL-USD). |
| record_id | INTEGER | Protocol-assigned record identifier for this funding observation. |
| funding_rate | FLOAT | Funding rate for the interval (protocol-native units). |
| funding_rate_long | FLOAT | Funding rate paid or received by longs. |
| funding_rate_short | FLOAT | Funding rate paid or received by shorts. |
| oracle_price_twap_usd | FLOAT | Time-weighted average oracle price in USD used for the funding calculation. |
| mark_price_twap_usd | FLOAT | Time-weighted average mark price in USD used for the funding calculation. |
| extra_fields | VARIANT | Protocol-specific fields not promoted to first-class columns. |