Skip to main content
The bsc.liquid_staking.withdrawals table captures when users initiate withdrawals from Binance liquid staking on BSC. 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 (binance)
action_typeVARCHARType of action (always ‘user_withdrawal’ for this table)
contract_typeVARCHARType of staking token being withdrawn (wBETH)
withdrawerVARCHARAddress of the user initiating the withdrawal
native_token_addressVARCHARAddress representing the asset to be received (ETH)
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 ETH to be withdrawn (raw wei amount)
native_token_amountFLOATAmount of ETH to be withdrawn (normalized)
native_token_amount_usdFLOATUSD value of 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 (wBETH)
staking_token_nameVARCHARName of the liquid staking token
staking_token_symbolVARCHARSymbol of the liquid staking token (wBETH)
staking_token_decimalsINTEGERNumber of decimals for the staking token
staking_token_amount_rawVARCHARAmount of liquid staking tokens being burned (raw wei amount)
staking_token_amountFLOATAmount of liquid staking tokens being burned (normalized)
staking_token_amount_usdFLOATUSD value of staking tokens being burned (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 bsc.liquid_staking.withdrawals
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
ORDER BY block_timestamp DESC