Deposits - Allium Documentation Hub

The iota.staking.deposits model tracks all staking deposits made to validators on the IOTA network. It only inclues data post-IOTA migration to the Move ecosystem.

Table Details

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

Staking Process

User selects a validator to stake with
User delegates IOTA to the validator’s staking pool
User receives pool tokens representing their stake
Rewards automatically accumulate through an increasing exchange rate

Table Columns

Column Name	Data Type	Description
checkpoint_timestamp	TIMESTAMP_NTZ(9)	Timestamp of when the checkpoint was created
epoch	NUMBER(38,0)	The epoch number
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
amount_str	VARCHAR(16777216)	Amount of IOTA deposited (string format for precision)
amount	FLOAT	Amount of IOTA deposited (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 deposit
_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 Deposits

Overview Overview

⌘I