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_latest |
| Table Status | Beta 🌱 |
| Unique Key | token_address, address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| stake_account | VARCHAR(16777216) | The address of the stake account |
| 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 |
| last_activity_action | VARCHAR(16777216) | The most recent staking action performed |
| last_activity_epoch | NUMBER(38,0) | The epoch when the last activity occurred |
| last_activity_action_info | VARIANT | Additional info about the last activity (JSON/variant) |
| last_activity_block_slot | NUMBER(38,0) | Block slot of the last activity |
| last_activity_block_height | NUMBER(38,0) | Block height of the last activity |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the last activity |
| last_activity_block_hash | VARCHAR(44) | Block hash of the last activity |
| last_activity_txn_id | VARCHAR(88) | Transaction ID of the last activity |
| last_activity_txn_index | NUMBER(38,0) | Transaction index within the block for the last activity |
| last_activity_instruction_index | NUMBER(38,0) | Instruction index within the transaction for the last activity |
| last_activity_inner_instruction_index | NUMBER(38,0) | Inner instruction index within the instruction for the last activity |
| last_activity_pseudo_global_order | NUMBER(38,0) | Global ordering number for the last activity |
| last_activity_pre_tx_amount | VARCHAR(16777216) | Stake account balance before the last activity (string) |
| last_activity_post_tx_amount | VARCHAR(16777216) | Stake account balance after the last activity (string) |
| last_activity_unique_id | VARCHAR(16777216) | Unique identifier for the last activity record |