Withdrawals

The iota.staking.withdrawals model tracks all staking withdrawals made from validators on the IOTA network.

Table Details

Property	Value
Table Name	`iota.staking.withdrawals`
Table Status	Production-Ready
Unique Key	`checkpoint_timestamp`, `unique_id`
Clustering Key(s)	`checkpoint_timestamp::date`
Search Optimization	`validator_address`

Understanding Unstaking

When users unstake their IOTA, they return their pool tokens and receive both their original principal and accumulated rewards. The unstaking process in IOTA has a waiting period before funds are released.

Unstaking Process

User initiates an unstaking request

The request is processed at the end of the current epoch
The user receives their principal amount plus rewards
The rewards are calculated based on the pool token exchange rate at the time of unstaking

Principal vs. Rewards

The withdrawal data separates the original staked amount (principal) from the earned rewards, allowing for clear tracking of staking returns.

Table Columns

Column Name	Data Type	Description
checkpoint_timestamp	TIMESTAMP_NTZ(9)	Timestamp of when the checkpoint was created
stake_activation_epoch	NUMBER(38,0)	The epoch number when the stake was originally activated
unstaking_epoch	NUMBER(38,0)	The epoch number where the IOTA unstake request will be released
sender	VARCHAR(16777216)	Address of the sender
staker_address	VARCHAR(16777216)	Address of the staker
validator_address	VARCHAR(16777216)	Address of the validator
pool_id	VARCHAR(16777216)	ID of the staking pool
principal_amount_str	VARCHAR(16777216)	Amount of IOTA unstaked (string format for precision)
principal_amount	FLOAT	Amount of IOTA unstaked (float format)
reward_amount_str	VARCHAR(16777216)	Amount of rewards received (string format for precision)
reward_amount	FLOAT	Amount of rewards received (float format)
checkpoint_sequence	NUMBER(38,0)	Sequence number of the checkpoint
checkpoint_digest	VARCHAR(16777216)	Digest of the checkpoint
transaction_block_digest	VARCHAR(16777216)	Digest of the transaction block
transaction_module	VARCHAR(16777216)	Module of the transaction
event_seq	NUMBER(38,0)	Sequence number of the event
package_id	VARCHAR(16777216)	ID of the package
unique_id	VARCHAR(16777216)	Unique ID of the withdrawal
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated

Sui Staking Withdrawals

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Understanding Unstaking

Unstaking Process

Principal vs. Rewards

Table Columns

​Table Details

​Understanding Unstaking

​Unstaking Process

​Principal vs. Rewards

​Table Columns

​Related Docs

Table Details

Understanding Unstaking

Unstaking Process

Principal vs. Rewards

Table Columns

Related Docs