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 |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| stake_account | VARCHAR(16777216) | The address of the stake account |
| action | VARCHAR(16777216) | The staking action performed (e.g. delegate, deactivate, split, merge, etc) |
| delegated_stake | FLOAT | Amount of SOL delegated minus rent reserve |
| active_stake | FLOAT | Amount of SOL currently earning rewards |
| inactive_stake | FLOAT | Difference between delegated and active stake |
| total_rewards | FLOAT | Cumulative rewards earned by the stake account |
| delegated_vote_account | VARCHAR(16777216) | Validator vote account address that the stake is delegated to |
| last_activation_epoch | NUMBER(38,0) | The most recent epoch when the stake was activated |
| last_deactivation_epoch | NUMBER(38,0) | The most recent epoch when the stake was deactivated |
| activation_status | VARCHAR(16777216) | Current status of the stake account |
| epoch | NUMBER(38,0) | The epoch when this record was created |
| action_info | VARIANT | Additional info about the action (JSON/variant) |
| block_slot | NUMBER(38,0) | Block slot of the action |
| block_height | NUMBER(38,0) | Block height of the action |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the action |
| block_hash | VARCHAR(44) | Block hash of the action |
| txn_id | VARCHAR(88) | Transaction ID of the action |
| txn_index | NUMBER(38,0) | Transaction index within the block |
| instruction_index | NUMBER(38,0) | Instruction index within the transaction |
| inner_instruction_index | NUMBER(38,0) | Inner instruction index within the instruction |
| pseudo_global_order | NUMBER(38,0) | Global ordering number for the record |
| pre_tx_amount | VARCHAR(16777216) | Stake account balance before the transaction (string) |
| post_tx_amount | VARCHAR(16777216) | Stake account balance after the transaction (string) |
| unique_id | VARCHAR(16777216) | Unique identifier for the record |