sui.staking.validator_state_latest model provides a current view of the current amount of Sui staked with each validator(s) for each staker.
Table Details
| Property | Value |
|---|---|
| Table Name | sui.staking.validator_stake_latest |
| Table Status | Production-Ready |
| Unique Key | staker_address, validator_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| staker_address | VARCHAR(16777216) | Address of the staker |
| validator_address | VARCHAR(16777216) | Address of the validator |
| current_stake | FLOAT | Current stake of the staker in the validator’s pool |
| all_time_staked | FLOAT | Total amount staked over all time |
| all_time_stake_count | NUMBER(13,0) | Total number of stake transactions |
| all_time_unstaked | FLOAT | Total amount unstaked over all time |
| all_time_unstake_count | NUMBER(13,0) | Total number of unstake transactions |
| rewards_collected | FLOAT | Total rewards collected by the staker |
| first_stake_epoch | NUMBER(38,0) | Epoch of the first stake of the staker in the validator’s pool |
| last_stake_epoch | NUMBER(38,0) | Epoch of the last stake of the staker in the validator’s pool |
| first_stake_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the first stake |
| last_stake_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the most recent stake |
| first_unstake_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the first unstake |
| last_unstake_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the most recent unstake |
| first_unstake_epoch | NUMBER(38,0) | Epoch of the first unstake of the staker in the validator’s pool |
| last_unstake_epoch | NUMBER(38,0) | Epoch of the last unstake of the staker in the validator’s pool |