Deposits - Allium Documentation Hub

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 Name	Data Type	Description
project	VARCHAR	Name of the liquid staking protocol (lido, rocketpool, binance)
action_type	VARCHAR	Type of action (always ‘user_deposit’ for this table)
contract_type	VARCHAR	Type of staking token received (stETH, rETH, wBETH)
depositor	VARCHAR	Address of the user who made the deposit. Note: may be a contract address rather than the transaction signer
native_token_address	VARCHAR	Address of the native token deposited (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 deposited (raw wei amount)
native_token_amount	FLOAT	Amount of native ETH deposited (normalized)
native_token_amount_usd	FLOAT	USD value of native ETH deposited (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 received
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 received (raw wei amount)
staking_token_amount	FLOAT	Amount of liquid staking tokens received (normalized)
staking_token_amount_usd	FLOAT	USD value of staking tokens received (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 deposit occurred
block_number	INTEGER	Block number when the deposit occurred
transaction_hash	VARCHAR	Hash of the transaction containing the deposit
log_index	INTEGER	Index of the log within the transaction
contract_address	VARCHAR	Address of the contract that processed the deposit
_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 deposits:

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

​Table Columns

​Sample Query

Table Columns

Sample Query