solana.staking.balances_latest table contains the current, latest staking statistics of each stake_account. It is derived from getting the latest record per stake_account from the solana.staking.balances table.
Search by
stake_account, not delegated_vote_account. This table is keyed on stake_account and holds exactly one row per stake account — it is effectively a stake-account balances-latest table, not a per-validator one. A validator’s delegated_vote_account is repeated across every stake account delegated to it, so filtering WHERE delegated_vote_account = '<vote_account>' returns the many individual delegating stake accounts, not the validator’s aggregate stake. To get a validator-level total, aggregate across stake accounts:SELECT delegated_vote_account, SUM(active_stake) AS total_active_stake
FROM solana.staking.balances_latest
GROUP BY delegated_vote_account
Table columns
| Column Name | Description | Type | Example |
|---|---|---|---|
| stake_account | The address of the stake account | varchar | 3jAwbKWs18jRHJ7tnNjz2tw2iU5K2ukQXhCwjzbNg76C |
| delegated_stake | Amount of SOL delegated minus rent reserve | float | 0 |
| active_stake | Amount of SOL currently earning rewards | float | 0 |
| inactive_stake | Difference between delegated and active stake | float | 0 |
| total_rewards | Cumulative rewards earned by the stake account | float | 0 |
| delegated_vote_account | Validator vote account address that the stake is delegated to | varchar | |
| last_activation_epoch | The most recent epoch when the stake was activated | number | 119 |
| last_deactivation_epoch | The most recent epoch when the stake was deactivated | number | 120 |
| activation_status | Current status of the stake account | varchar | inactive |
| last_activity_action | The most recent staking action performed | varchar | merge_source |
| last_activity_epoch | The epoch when the last activity occurred | number | 145 |
| last_activity_action_info | Additional info about the last activity (JSON/variant) | variant | {"destination": "GK2zqSsXLA2rwVZk347RYhh6jJpRsCA69FjLW93ZGi3B"} |
| last_activity_block_slot | Block slot of the last activity | number | 63037156 |
| last_activity_block_height | Block height of the last activity | number | |
| last_activity_block_timestamp | Block timestamp of the last activity | timestamp_ntz | 2021-01-29 23:41:42.000 |
| last_activity_block_hash | Block hash of the last activity | varchar | 3pNcJskVGjn7YSWgBjEVHhT91BL4DBZgs2PTrXdWFfMY |
| last_activity_txn_id | Transaction ID of the last activity | varchar | 4UjY9AtUxQnkof57zL9rQLuZbmAfhq9ydAZh1QQStU89jiJNh83PQc9S58EaSWajSyixqbvzcpbe8sfwXJyyfsQZ |
| last_activity_txn_index | Transaction index within the block for the last activity | number | 845 |
| last_activity_instruction_index | Instruction index within the transaction for the last activity | number | 0 |
| last_activity_inner_instruction_index | Inner instruction index within the instruction for the last activity | number | |
| last_activity_pseudo_global_order | Global ordering number for the last activity | number | 63037156000845000001000000 |
| last_activity_pre_tx_amount | Stake account balance before the last activity (string) | varchar | 200000 |
| last_activity_post_tx_amount | Stake account balance after the last activity (string) | varchar | 0 |
| last_activity_unique_id | Unique identifier for the last activity record | varchar | stake_account-3jAwbKWs18jRHJ7tnNjz2tw2iU5K2ukQXhCwjzbNg76C_block_slot-63037156_txn_id-4UjY9AtUxQnkof57zL9rQLuZbmAfhq9ydAZh1QQStU89jiJNh83PQc9S58EaSWajSyixqbvzcpbe8sfwXJyyfsQZ_i_index-0_ii_index-null |