Skip to main content
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
ColumnData TypeDescription
dateDATEDate of the balance entry.
projectVARCHARName of the project e.g. uniswap, balancer, curve, sushiswap, pancakeswap, fraxswap, etc.
protocolVARCHARVersion of the protocol used e.g. uniswap_v2, uniswap_v3, balancer_v3, curve, fluid, etc.
pool_nameVARCHARName of the liquidity pool.
liquidity_pool_addressVARCHARContract address of the liquidity pool holding the asset. For some projects, it might be the vault address.
token_addressVARCHARContract address of the token.
token_nameVARCHARName of the token.
token_symbolVARCHARSymbol of the token.
token_decimalsBIGINTDecimals of the token.
raw_balance_strVARCHARRaw balance of the token in string.
raw_balanceFLOATRaw balance of the token, normalized.
balance_strVARCHARBalance of the token in string.
balanceFLOATBalance of the token, normalized.
usd_balanceFLOATUSD balance of the token at the date of the balance entry.
usd_exchange_rateFLOATUSD exchange rate of the token at the date of the balance entry.
last_block_timestampTIMESTAMP_NTZ(9)Timestamp of the last block where the balance of the pool was updated.
last_block_numberBIGINTNumber of the last block where the balance of the pool was updated.
_created_atTIMESTAMP_NTZ(9)Timestamp when the record was created.
_updated_atTIMESTAMP_NTZ(9)Timestamp when the record was last updated.