TVL Daily - Allium Documentation Hub

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 Details

Property	Value
Table Name	`plasma.dex.tvl_daily`
Table Status	Production-Ready
Unique Key	`date`, `liquidity_pool_address`, `token_address`

Table Columns

_str columns are numeric fields cast to varchar to retain precision.

Column Name	Data Type	Description
date	TIMESTAMP_NTZ(9)	Date of the balance entry.
project	VARCHAR(16777216)	Name of the project e.g. uniswap, balancer, curve, sushiswap, pancakeswap, fraxswap, etc.
protocol	VARCHAR(16777216)	Version of the protocol used e.g. uniswap_v2, uniswap_v3, balancer_v3, curve, fluid, etc.
pool_name	VARCHAR(16777216)	Name of the liquidity pool.
liquidity_pool_address	VARCHAR(16777216)	Contract address of the liquidity pool holding the asset. For some projects, it might be the vault address.
token_address	VARCHAR(16777216)	Contract address of the token.
token_name	VARCHAR(16777216)	Name of the token.
token_symbol	VARCHAR(16777216)	Symbol of the token.
token_decimals	NUMBER(38,0)	Decimals of the token.
raw_balance_str	VARCHAR(16777216)	Raw balance of the token in string.
raw_balance	FLOAT	Raw balance of the token, normalized.
balance_str	VARCHAR(16777216)	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	NUMBER(38,0)	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.

EVM DEX TVL Daily