Skip to main content
The ethereum.liquid_staking.user_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 NameData TypeDescription
projectVARCHARName of the liquid staking protocol (lido, rocketpool, binance)
action_typeVARCHARType of action (always ‘user_withdrawal’ for this table)
contract_typeVARCHARType of staking token being withdrawn (stETH, rETH, wBETH)
withdrawerVARCHARAddress of the user initiating the withdrawal
native_token_addressVARCHARAddress of the native token to be received (ETH - 0x0000000000000000000000000000000000000000)
native_token_nameVARCHARName of the native token (Ether)
native_token_symbolVARCHARSymbol of the native token (ETH)
native_token_decimalsINTEGERNumber of decimals for the native token (18)
native_token_amount_rawVARCHARAmount of native ETH to be withdrawn (raw wei amount)
native_token_amountFLOATAmount of native ETH to be withdrawn (normalized)
native_token_amount_usdFLOATUSD value of native ETH to be withdrawn (amount × price)
native_token_price_usdFLOATPrice of native token in USD at block timestamp (hourly granularity)
staking_token_addressVARCHARContract address of the liquid staking token being burned/redeemed
staking_token_nameVARCHARName of the liquid staking token
staking_token_symbolVARCHARSymbol of the liquid staking token (stETH, rETH, wBETH)
staking_token_decimalsINTEGERNumber of decimals for the staking token
staking_token_amount_rawVARCHARAmount of liquid staking tokens being burned/redeemed (raw wei amount)
staking_token_amountFLOATAmount of liquid staking tokens being burned/redeemed (normalized)
staking_token_amount_usdFLOATUSD value of staking tokens being burned/redeemed (amount × price)
staking_token_price_usdFLOATPrice of staking token in USD at block timestamp (hourly granularity)
block_timestampTIMESTAMP_NTZ(9)Timestamp of the block when the withdrawal was initiated
block_numberINTEGERBlock number when the withdrawal was initiated
transaction_hashVARCHARHash of the transaction containing the withdrawal
log_indexINTEGERIndex of the log within the transaction
contract_addressVARCHARAddress of the contract that processed the withdrawal
_created_atTIMESTAMP_NTZ(9)Timestamp when the record was first created
_updated_atTIMESTAMP_NTZ(9)Timestamp when the record was last updated

Sample Query

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