iota.staking.validator_stake_latest model provides a current view of the current amount of IOTA staked with each validator(s) for each staker. It only inclues data post-IOTA migration to the Move ecosystem.
This table is computed from the total deposits and withdrawals per validator, giving you a real-time snapshot of staking positions.
Schema
Unique Key:staker_address, validator_address
| Column | Description |
|---|---|
| staker_address | Address of the staker |
| validator_address | Address of the validator |
| current_stake | Current stake of the staker in the validator’s pool |
| all_time_staked | Total stake of the staker in the validator’s pool |
| all_time_stake_count | Total number of stakes by the staker |
| all_time_unstaked | Total unstaked amount by the staker |
| all_time_unstake_count | Total number of unstakes by the staker |
| rewards_collected | Total rewards collected by the staker |
| first_stake_epoch | Epoch of the first stake of the staker |
| last_stake_epoch | Epoch of the last stake of the staker |
| first_stake_timestamp | Timestamp of the first stake of the staker |
| last_stake_timestamp | Timestamp of the last stake of the staker |
| first_unstake_timestamp | Timestamp of the first unstake of the staker |
| last_unstake_timestamp | Timestamp of the last unstake of the staker |
| first_unstake_epoch | Epoch of the first unstake of the staker |
| last_unstake_epoch | Epoch of the last unstake of the staker |