Staking
Staking Balances Latest
Staking
Staking 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 the solana.staking.balances table.
Table columns
| Column Name | Description | Type | Example |
|---|---|---|---|
| stake_account | The address of the stake account | varchar | 7xLk17EQQ5KLDLDe44wCmupJKJjTGd8hs3eSVVhCx932 |
| delegated_stake | Amount of SOL delegated minus rent reserve. Includes both active and deactivating stakes | float | 100.5 |
| active_stake | Amount of SOL currently earning rewards | float | 95.5 |
| inactive_stake | Difference between delegated and active stake (represents deactivating/activating amounts) | float | 5.0 |
| total_rewards | Cumulative rewards earned by the stake account | float | 2.45 |
| delegated_vote_account | Validator vote account address that the stake is delegated to | varchar | 26pV97Ce83ZQ6Kz9XT4td8tdoUFPTng8Fb8gPyc53dJx |
| last_activation_epoch | The most recent epoch when the stake was activated | bigint | 280 |
| last_deactivation_epoch | The most recent epoch when the stake was deactivated (null if currently active) | bigint | 275 |
| activation_status | Current status of the stake account | varchar | active, deactivating, inactive |
| epoch | The epoch when the last action occurred | bigint | 282 |
| block_slot | Slot number where the last transaction occurred | bigint | 150000000 |
| block_timestamp | Timestamp of the last block | timestamp | 2024-03-20 10:00:00 |
| txn_id | Transaction signature/hash of the last update | varchar | 2Rinn7xHXweFbuxuJKyeKdYznatLatNRSq9gF8oteEYPBp6yHpUanBNBmKJoPHZV3EdqvDzeRedTt3NpsqmiLWDn |
| unique_id | Unique identifier for the record | varchar | stake_account-8yKiYWWBVWMj5NzEnhAPbtKDZFEMwWzENT3v9oHbnRy4_block_slot-205156998_txn_id-2Rinn7xHXweFbuxuJKyeKdYznatLatNRSq9gF8oteEYPBp6yHpUanBNBmKJoPHZV3EdqvDzeRedTt3NpsqmiLWDn_i_index-0_ii_index-null |