DEX TVL Daily

The dex.tvl_daily table contains daily total value locked (TVL) for DEX protocols indexed by Allium. Each entry corresponds to an asset in a liquidity pool address for each day.

Table Columns

_str columns are numeric fields cast to varchar to retain precision. Unique Key: date, project, protocol, liquidity_pool_address, token_address

Column	Data Type	Description
date	DATE	Date of the balance entry.
project	VARCHAR	Name of the project e.g. uniswap, balancer, curve, sushiswap, pancakeswap, fraxswap, etc.
protocol	VARCHAR	Version of the protocol used e.g. uniswap_v2, uniswap_v3, balancer_v3, curve, fluid, etc.
pool_name	VARCHAR	Name of the liquidity pool.
liquidity_pool_address	VARCHAR	Contract address of the liquidity pool holding the asset. For some projects, it might be the vault address.
token_address	VARCHAR	Contract address of the token.
token_name	VARCHAR	Name of the token.
token_symbol	VARCHAR	Symbol of the token.
token_decimals	BIGINT	Decimals of the token.
raw_balance_str	VARCHAR	Raw balance of the token in string.
raw_balance	FLOAT	Raw balance of the token, normalized.
balance_str	VARCHAR	Balance of the token in string.
balance	FLOAT	Balance of the token, normalized.
usd_balance	FLOAT	USD balance of the token at the date of the balance entry.
usd_exchange_rate	FLOAT	USD exchange rate of the token at the date of the balance entry.
last_block_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the last block where the balance of the pool was updated.
last_block_number	BIGINT	Number of the last block where the balance of the pool was updated.
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was created.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns