Withdrawals - Allium Documentation Hub

The ethereum.liquid_staking.withdrawals table captures when users initiate withdrawals from Lido, Rocketpool, or Binance liquid staking. Each row represents a single withdrawal event with token metadata, normalized amounts, and USD prices.

Table Columns

Unique Key: transaction_hash, log_index

Column Name	Data Type	Description
project	VARCHAR	Name of the liquid staking protocol (lido, rocketpool, binance)
action_type	VARCHAR	Type of action (always ‘user_withdrawal’ for this table)
contract_type	VARCHAR	Type of staking token being withdrawn (stETH, rETH, wBETH)
withdrawer	VARCHAR	Address of the user initiating the withdrawal
native_token_address	VARCHAR	Address of the native token to be received (ETH - 0x0000000000000000000000000000000000000000)
native_token_name	VARCHAR	Name of the native token (Ether)
native_token_symbol	VARCHAR	Symbol of the native token (ETH)
native_token_decimals	INTEGER	Number of decimals for the native token (18)
native_token_amount_raw	VARCHAR	Amount of native ETH to be withdrawn (raw wei amount)
native_token_amount	FLOAT	Amount of native ETH to be withdrawn (normalized)
native_token_amount_usd	FLOAT	USD value of native ETH to be withdrawn (amount × price)
native_token_price_usd	FLOAT	Price of native token in USD at block timestamp (hourly granularity)
staking_token_address	VARCHAR	Contract address of the liquid staking token being burned/redeemed
staking_token_name	VARCHAR	Name of the liquid staking token
staking_token_symbol	VARCHAR	Symbol of the liquid staking token (stETH, rETH, wBETH)
staking_token_decimals	INTEGER	Number of decimals for the staking token
staking_token_amount_raw	VARCHAR	Amount of liquid staking tokens being burned/redeemed (raw wei amount)
staking_token_amount	FLOAT	Amount of liquid staking tokens being burned/redeemed (normalized)
staking_token_amount_usd	FLOAT	USD value of staking tokens being burned/redeemed (amount × price)
staking_token_price_usd	FLOAT	Price of staking token in USD at block timestamp (hourly granularity)
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the block when the withdrawal was initiated
block_number	INTEGER	Block number when the withdrawal was initiated
transaction_hash	VARCHAR	Hash of the transaction containing the withdrawal
log_index	INTEGER	Index of the log within the transaction
contract_address	VARCHAR	Address of the contract that processed the withdrawal
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was first created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated

Sample Query

Last 7 days withdrawals:

SELECT *
FROM ethereum.liquid_staking.withdrawals
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
ORDER BY block_timestamp DESC

​Table Columns

​Sample Query

Table Columns

Sample Query