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 |