Skip to main content
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 NameData TypeDescription
dateDATEDate of the TVL snapshot
projectVARCHARName of the liquid staking protocol (lido, rocketpool, binance)
staking_token_addressVARCHARContract address of the liquid staking token
staking_token_symbolVARCHARSymbol of the liquid staking token (stETH, rETH, wBETH)
staking_token_nameVARCHARName of the liquid staking token
staking_token_decimalsINTEGERNumber of decimals for the staking token
total_staking_token_amount_rawVARCHARTotal supply of liquid staking tokens (raw wei amount)
total_staking_token_amountFLOATTotal supply of liquid staking tokens (normalized)
total_staking_token_amount_usdFLOATUSD value of staking tokens (amount × end-of-day price)
staking_token_price_usdFLOATEnd-of-day price of staking token in USD
native_token_addressVARCHARAddress of the native token (ETH - 0x0000000000000000000000000000000000000000)
native_token_symbolVARCHARSymbol of the native token (ETH)
native_token_nameVARCHARName of the native token (Ether)
native_token_decimalsINTEGERNumber of decimals for the native token (18)
total_native_token_amount_rawVARCHARTotal amount of native ETH locked (raw wei amount)
total_native_token_amountFLOATTotal amount of native ETH locked (normalized)
total_native_token_amount_usdFLOATUSD value of native ETH locked (amount × end-of-day price)
native_token_price_usdFLOATEnd-of-day price of native token in USD
_created_atTIMESTAMP_NTZ(9)Timestamp when the record was first created
_updated_atTIMESTAMP_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