The 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

ColumnDescription
staker_addressAddress of the staker
validator_addressAddress of the validator
pool_idID of the staking pool
current_stakeCurrent stake of the staker in the validator’s pool
all_time_stakedTotal amount staked over all time
all_time_stake_countTotal number of stake transactions
all_time_unstakedTotal amount unstaked over all time
all_time_unstake_countTotal number of unstake transactions
rewards_collectedTotal rewards collected by the staker
first_stake_timestampTimestamp of the first stake
last_stake_timestampTimestamp of the most recent stake
first_unstake_timestampTimestamp of the first unstake
last_unstake_timestamp

Timestamp of the most recent unstake