> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# TVL Daily

> Daily Total Value Locked snapshots for Ethereum liquid staking protocols

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:

```sql theme={null}
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
```