Withdrawals - Allium Documentation Hub

Table Details

Property	Value
Table Name	`beacon.raw.withdrawals`
Table Status	Production-Ready
Unique Key	`slot_timestamp`, `withdrawal_index`
Clustering Key(s)	`slot_timestamp::date`
Search Optimization	`validator_index`, `withdrawal_address`

Staking withdrawals refer to transfers of ETH from a validator account on Ethereum’s consensus layer (the Beacon Chain), to the execution layer where it can be transacted with. Reward payments of excess balance over 32 ETH (or over 2,048 ETH for validators with compounding 0x02 withdrawal credentials, introduced in Pectra) will automatically and regularly be sent to a withdrawal address linked to each validator, once provided by the user. Users can also exit staking entirely, unlocking their full validator balance. https://ethereum.org/en/staking/withdrawals/

Table Columns

Column Name	Data Type	Description
slot_number	NUMBER(38,0)	Slot number of the state where the pending deposits to beacon chain is fetched.
slot_timestamp	TIMESTAMP_NTZ(9)	Slot timestamp of the state where the pending deposits to beacon chain is fetched.
withdrawal_index	NUMBER(38,0)	4,111,065
validator_index	NUMBER(38,0)	916,865
withdrawal_amount	VARCHAR(16777216)	0.012449812
withdrawal_amount_raw	NUMBER(38,0)	Raw amount of ETH withdrawn.
withdrawal_address	VARCHAR(42)	0xe839a3e9efb32c6a56ab7128e51056585275506c
eth1_block_hash	VARCHAR(16777216)	0xc0efee09619b108b8c184d7c4981b96bcef8fe63e6887f3ee20728d5ca6d6e67
eth1_block_number	NUMBER(38,0)	17,030,996
eth1_block_timestamp	TIMESTAMP_NTZ(9)	2023-04-12 09:19:47
_created_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was created in the database.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of when the entry was last updated in the database.
_changed_since_full_refresh	BOOLEAN	Indicates if the record has changed since the last full data refresh.

EVM

​Table Details

​Table Columns

Table Details

Table Columns