Balances Latest

The 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 staking balances.

Table Columns

Column Name	Description	Sample Data
stake_account	The address of the stake account	7xLk17EQQ5KLDLDe44wCmupJKJjTGd8hs3eSVVhCx932
delegated_stake	Total amount of SOL delegated (including both active and inactive), minus rent reserve	100.5
active_stake	Amount of SOL currently earning rewards (fully activated stake)	95.5
inactive_stake	Amount of SOL in activating or deactivating state (delegated_stake - active_stake)	5.0
total_rewards	Cumulative staking rewards earned by this account	2.45
delegated_vote_account	Validator vote account address that the stake is delegated to	Vote4Life1234...26pV97Ce83ZQ6Kz9XT4td8tdoUFPTng8Fb8gPyc53dJx
last_activation_epoch	Most recent epoch when the stake was activated	280
last_deactivation_epoch	Most recent epoch when the stake was deactivated (null if currently active)	275
activation_status	Current status of the stake account	active, inactive, activating, deactivating
last_activity_action	Type of the most recent action performed on the stake account	delegate, withdraw, rewards
last_activity_epoch	Epoch when the last activity occurred	282
last_activity_action_info	Additional JSON details about the last action	{ "lamports": "14809626366", "origin_stake_account": "rsrxDvYUXjH1RQj2Ke36LNZEVqGztATxFkqNukERqFT" }
last_activity_block_slot	Slot number of the last activity	150000000
last_activity_block_height	Block height of the last activity	12345678
last_activity_block_timestamp	Timestamp of the last activity	2024-03-20 10:00:00
last_activity_block_hash	Block hash of the last activity	GMBd7VU5FBzeUoAn9eukux7s7LBGbYjGqT9hBPaQTrHg
last_activity_txn_id	Transaction signature/hash of the last activity	27s7aQYwT4MAtrfEoDPfhUPxLqpy5aCEThdWpVAym6jEsveuaRgxo5KF3gcBTuM2TnyM9LBEEx1NJSuThmT9n9AF
last_activity_txn_index	Transaction index of the last activity	0
last_activity_instruction_index	Instruction index within the last transaction	1
last_activity_inner_instruction_index	Inner instruction index of the last activity (if applicable)	0
last_activity_pseudo_global_order	Global ordering number of the last activity	205195913000008000001000003
last_activity_pre_tx_amount	Account balance before the last transaction	100.5
last_activity_post_tx_amount	Account balance after the last transaction	105.5
last_activity_unique_id	Unique identifier of the last activity record	stake_account-BXhAdm8CF8B5hYf3EaqtS9YfV9XbH5BP2Z28XTAbSaRp_block_slot-205202980_txn_id-3LscuMaLVuUtPcds5KuyJoEM1vJx9EAer6LLqbW8biKpE4qS3y1VvxWaYTdC9saDECk8JDZqsoh7hWebkFQLdEb_i_index-0_ii_index-null