Pool Balance Changes Daily

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.

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

Token Prices Hourly Token Prices 5Min

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns