Staking Balances

The solana.staking.balances table contains the historical staking numbers for each stake_account. The data is reconstructed by indexing instructions to the stake program, specifically initialize, delegate, withdraw, deactivate, split, merge and deactivateDelinquent. In addition, rewards disbursed at each epoch are also included in this table as it affects the delegated stake amount.

This table is in beta - As the staking state has to be cumulatively calculated from stake-related actions, we are still working through all the edge cases that affect delegated, active, inactive balances. Our sampling indicates that some balances could be a few percent off at times.

Search by stake_account, not delegated_vote_account. This table is keyed on stake_account: each row is one stake action on one stake account, so a validator’s delegated_vote_account appears across many stake accounts and many rows over time. Filtering by delegated_vote_account returns those individual stake accounts’ actions, not a validator-level total. For a validator’s current total, use solana.staking.balances_latest and aggregate across stake accounts (SUM(active_stake) ... GROUP BY delegated_vote_account).

Stake Actions

Each row in this table reflects an action taken on a stake_account, and the resultant state of the account after said action. These are the types of stake actions tracked:

Action	Description
initialize	Creates a new stake account. This is the first action required before any staking operations can occur. Sets up the initial parameters including staker and withdrawer authorities.
delegate	Stakes tokens to a validator’s vote account.
deactivate	Initiates the deactivation of an active stake account.
delinquent_vote_account_deactivate	A special deactivation triggered by another account when a validator becomes delinquent. This forces deactivation of stakes delegated to problematic validators.
withdraw	Removes unstaked tokens from a stake account.
merge_source	Represents the source stake account in a merge operation. This account will be emptied and closed after merging into the destination.
merge_destination	Represents the destination stake account in a merge operation. This account receives the delegated stake from the merge source account.
split_source	The original stake account that is being split. Its delegated amount is reduced by the split amount.
split_destination	A newly created stake account that receives a portion of the split_source’s stake. Inherits the same validator delegation as the source.
rewards	Represents staking rewards being distributed to the stake account. Increases the delegated amount by the reward amount.

Table columns

Column Name	Description	Type	Example
stake_account	The address of the stake account	varchar	3jAwbKWs18jRHJ7tnNjz2tw2iU5K2ukQXhCwjzbNg76C
action	The staking action performed (e.g. delegate, deactivate, split, merge, etc)	varchar	delegate
delegated_stake	Amount of SOL delegated minus rent reserve	float	499999.99771712
active_stake	Amount of SOL currently earning rewards	float	0
inactive_stake	Difference between delegated and active stake	float	499999.99771712
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	7UKUPLwLrV7iLqL5ndTzYDav73mpoMxKjyM7EjMExTaw
last_activation_epoch	The most recent epoch when the stake was activated	number	90
last_deactivation_epoch	The most recent epoch when the stake was deactivated	number
activation_status	Current status of the stake account	varchar	activating
epoch	The epoch when this record was created	number	90
action_info	Additional info about the action (JSON/variant)	variant	`{"vote_account": "7UKUPLwLrV7iLqL5ndTzYDav73mpoMxKjyM7EjMExTaw"}`
block_slot	Block slot of the action	number	38883476
block_height	Block height of the action	number
block_timestamp	Block timestamp of the action	timestamp_ntz	2020-10-03 16:02:39.000
block_hash	Block hash of the action	varchar	6MNp2RRKbbqsFBAVE3RmCPJXYPmH4xrzKAEBv8juZJS
txn_id	Transaction ID of the action	varchar	3BkjfR1YNNTzRwEXAsNhtAUMECVGoRKTeQVqFk1GsmgiVRVyrDaSUtAyxqkRjqYLPWa76XVUjZEaKpkX3TBbmiaD
txn_index	Transaction index within the block	number	147
instruction_index	Instruction index within the transaction	number	0
inner_instruction_index	Inner instruction index within the instruction	number
pseudo_global_order	Global ordering number for the record	number	38883476000147000001000000
pre_tx_amount	Stake account balance before the transaction (string)	varchar	500000
post_tx_amount	Stake account balance after the transaction (string)	varchar	500000
unique_id	Unique identifier for the record	varchar	stake_account-3jAwbKWs18jRHJ7tnNjz2tw2iU5K2ukQXhCwjzbNg76C_block_slot-38883476_txn_id-3BkjfR1YNNTzRwEXAsNhtAUMECVGoRKTeQVqFk1GsmgiVRVyrDaSUtAyxqkRjqYLPWa76XVUjZEaKpkX3TBbmiaD_i_index-0_ii_index-null

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Stake Actions

Table columns

​Stake Actions

​Table columns

Stake Actions

Table columns