Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | solana_devnet.staking.balances_daily |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| day | TIMESTAMP_NTZ(9) | The calendar day for the daily staking balance snapshot. |
| epoch | NUMBER(38,0) | The Solana epoch for the staking balance snapshot. |
| stake_account | VARCHAR(16777216) | The stake account address. |
| action | VARCHAR(16777216) | The staking action represented by the row. |
| delegated_stake | FLOAT | The stake amount delegated by the stake account. |
| active_stake | FLOAT | The delegated stake amount currently active. |
| inactive_stake | FLOAT | The delegated stake amount currently inactive. |
| total_rewards | FLOAT | The cumulative staking rewards associated with the stake account. |
| delegated_vote_account | VARCHAR(16777216) | The vote account to which the stake account is delegated. |
| last_activation_epoch | NUMBER(38,0) | The most recent epoch when the stake account began activation. |
| last_deactivation_epoch | NUMBER(38,0) | The most recent epoch when the stake account began deactivation. |
| activation_status | VARCHAR(16777216) | The current activation state of the stake account. |
| action_info | VARIANT | Additional structured details about the staking action. |
| block_slot | NUMBER(38,0) | The Solana slot containing the block for this record. |
| block_height | NUMBER(38,0) | The block height for this record. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block containing this record. |
| block_hash | VARCHAR(44) | The hash of the block containing this record. |
| txn_id | VARCHAR(88) | The transaction signature, which uniquely identifies the transaction. |
| txn_index | NUMBER(38,0) | The zero-based position of the transaction within the block. |
| instruction_index | NUMBER(38,0) | The zero-based position of the instruction within the transaction. |
| inner_instruction_index | NUMBER(38,0) | The zero-based position of the inner instruction within its parent instruction. |
| pseudo_global_order | NUMBER(38,0) | A deterministic ordering value used to sequence staking actions within a transaction. |
| pre_tx_amount | VARCHAR(16777216) | The stake account amount before the transaction. |
| post_tx_amount | VARCHAR(16777216) | The stake account amount after the transaction. |
| unique_id | VARCHAR(16777216) | A deterministic unique identifier for this row. |