Validator Stake Latest

The 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.

Table Details

Property	Value
Table Name	`iota.staking.validator_stake_latest`
Table Status	Production-Ready

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 stake of the staker in the validator’s pool
all_time_stake_count	NUMBER(13,0)	Total number of stakes by the staker
all_time_unstaked	FLOAT	Total unstaked amount by the staker
all_time_unstake_count	NUMBER(13,0)	Total number of unstakes by the staker
rewards_collected	FLOAT	Total rewards collected by the staker
first_stake_epoch	NUMBER(38,0)	Epoch of the first stake of the staker
last_stake_epoch	NUMBER(38,0)	Epoch of the last stake of the staker
first_stake_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the first stake of the staker
last_stake_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the last stake of the staker
first_unstake_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the first unstake of the staker
last_unstake_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the last unstake of the staker
first_unstake_epoch	NUMBER(38,0)	Epoch of the first unstake of the staker
last_unstake_epoch	NUMBER(38,0)	Epoch of the last unstake of the staker

Sui Staking Validator Stake Latest

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Table Columns

​Table Details

​Table Columns

​Related Docs

Table Details

Table Columns

Related Docs