sui.staking.validator_state_latest model provides a current view of the current amount of Sui staked with each validator(s) for each staker.
Schema
Unique Key:staker_address, validator_address
| Column | Description |
|---|---|
| staker_address | Address of the staker |
| validator_address | Address of the validator |
| pool_id | ID of the staking pool |
| current_stake | Current stake of the staker in the validator’s pool |
| all_time_staked | Total amount staked over all time |
| all_time_stake_count | Total number of stake transactions |
| all_time_unstaked | Total amount unstaked over all time |
| all_time_unstake_count | Total number of unstake transactions |
| rewards_collected | Total rewards collected by the staker |
| first_stake_timestamp | Timestamp of the first stake |
| last_stake_timestamp | Timestamp of the most recent stake |
| first_unstake_timestamp | Timestamp of the first unstake |
| last_unstake_timestamp | Timestamp of the most recent unstake |