Table Details
| Property | Value |
|---|---|
| Table Name | solana.perpetuals.funding_rates |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, txn_id, unique_id |
| Clustering Key(s) | block_timestamp::date, market_index |
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 funding-rate update. |
| block_slot | NUMBER(38,0) | Solana block slot of the update. |
| txn_id | VARCHAR(16777216) | Transaction signature that recorded this funding update. |
| unique_id | VARCHAR(16777216) | 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 | NUMBER(38,0) | Protocol market index. |
| market_symbol | VARCHAR(16777216) | Market symbol (e.g. SOL-USD). |
| record_id | NUMBER(38,0) | Protocol-assigned record identifier for this funding observation. |
| funding_rate | NUMBER(38,12) | Funding rate for the interval (protocol-native units). |
| funding_rate_long | NUMBER(38,12) | Funding rate paid or received by longs. |
| funding_rate_short | NUMBER(38,12) | Funding rate paid or received by shorts. |
| oracle_price_twap_usd | NUMBER(38,6) | Time-weighted average oracle price in USD used for the funding calculation. |
| mark_price_twap_usd | NUMBER(38,6) | Time-weighted average mark price in USD used for the funding calculation. |
| 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. |