Skip to main content
The ethereum.liquid_staking.deposits table captures when users deposit ETH into Lido, Rocketpool, or Binance liquid staking and receive liquid staking tokens (stETH, rETH, wBETH) in return. Each row represents a single deposit 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_deposit’ for this table)
contract_typeVARCHARType of staking token received (stETH, rETH, wBETH)
depositorVARCHARAddress of the user who made the deposit. Note: may be a contract address rather than the transaction signer
native_token_addressVARCHARAddress of the native token deposited (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 deposited (raw wei amount)
native_token_amountFLOATAmount of native ETH deposited (normalized)
native_token_amount_usdFLOATUSD value of native ETH deposited (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 received
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 received (raw wei amount)
staking_token_amountFLOATAmount of liquid staking tokens received (normalized)
staking_token_amount_usdFLOATUSD value of staking tokens received (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 deposit occurred
block_numberINTEGERBlock number when the deposit occurred
transaction_hashVARCHARHash of the transaction containing the deposit
log_indexINTEGERIndex of the log within the transaction
contract_addressVARCHARAddress of the contract that processed the deposit
_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 deposits:
SELECT *
FROM ethereum.liquid_staking.deposits
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
ORDER BY block_timestamp DESC