The Pool Balance Changes Daily table contains one row per (liquidity pool, token, day) capturing the pool’s closing token reserve and its USD value. Use this table to track TVL trends, reserve imbalances, and pool composition over time.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.
Table Columns
Unique Key:block_date, liquidity_pool_address, token_address
| Column Name | Data Type | Description |
|---|---|---|
| block_date | TIMESTAMP_NTZ(9) | The UTC date this daily pool balance snapshot covers |
| project | VARCHAR | Name of the project (e.g. uniswap) |
| protocol | VARCHAR | Protocol name (e.g. uniswap_v2, uniswap_v3) |
| pool_name | VARCHAR | Human-readable pool name (typically token0/token1) |
| liquidity_pool_address | VARCHAR | Contract address of the liquidity pool |
| token_address | VARCHAR | Contract address of the token held in the pool |
| raw_balance_str | VARCHAR | Pool’s token reserve, unnormalized, as string for precision |
| raw_balance | FLOAT | Pool’s token reserve, unnormalized |
| balance_str | VARCHAR | Pool’s token reserve, normalized, as string for precision |
| balance | FLOAT | Pool’s token reserve, normalized by token decimals |
| usd_balance | FLOAT | USD value of the pool’s reserve of this token |
| usd_exchange_rate | FLOAT | Exchange rate used for USD conversion |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp at which the balance was captured |
| block_number | INTEGER | Block number at which the balance was captured |