TVL Daily - Allium Documentation Hub

The ethereum.liquid_staking.total_value_locked_daily table provides daily TVL snapshots from Lido (stETH), Rocketpool (rETH), and Binance (wBETH), with token metadata, normalized amounts, and USD prices. Each row represents one protocol’s TVL on a given day, including both the liquid staking token supply and the underlying ETH locked.

Table Columns

Unique Key: date, project, staking_token_address

Column Name	Data Type	Description
date	DATE	Date of the TVL snapshot
project	VARCHAR	Name of the liquid staking protocol (lido, rocketpool, binance)
staking_token_address	VARCHAR	Contract address of the liquid staking token
staking_token_symbol	VARCHAR	Symbol of the liquid staking token (stETH, rETH, wBETH)
staking_token_name	VARCHAR	Name of the liquid staking token
staking_token_decimals	INTEGER	Number of decimals for the staking token
total_staking_token_amount_raw	VARCHAR	Total supply of liquid staking tokens (raw wei amount)
total_staking_token_amount	FLOAT	Total supply of liquid staking tokens (normalized)
total_staking_token_amount_usd	FLOAT	USD value of staking tokens (amount × end-of-day price)
staking_token_price_usd	FLOAT	End-of-day price of staking token in USD
native_token_address	VARCHAR	Address of the native token (ETH - 0x0000000000000000000000000000000000000000)
native_token_symbol	VARCHAR	Symbol of the native token (ETH)
native_token_name	VARCHAR	Name of the native token (Ether)
native_token_decimals	INTEGER	Number of decimals for the native token (18)
total_native_token_amount_raw	VARCHAR	Total amount of native ETH locked (raw wei amount)
total_native_token_amount	FLOAT	Total amount of native ETH locked (normalized)
total_native_token_amount_usd	FLOAT	USD value of native ETH locked (amount × end-of-day price)
native_token_price_usd	FLOAT	End-of-day price of native token in USD
_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

Compare TVL by protocol:

SELECT 
  date,
  project,
  staking_token_symbol,
  total_staking_token_amount,
  total_staking_token_amount_usd
FROM ethereum.liquid_staking.total_value_locked_daily
WHERE date = CURRENT_DATE - 1
ORDER BY total_staking_token_amount_usd DESC

​Table Columns

​Sample Query

Table Columns

Sample Query