TVL (Total Value Locked)

This table contains TVL information for various dex pools.

solana.dex.tvl currently includes the following dex/protocols

Project	Protocol
meteora	meteora-dlmm
orca	orca-whirlpool
phoenix	phoenix

The data tracks changes to a pool's TVL at the transaction level, not instruction level

Table Columns

Column Name	Description	Type	Examples
project	The dex project	varchar	phoenix
protocol	The protocol used by the dex project	varchar	phoenix
pool	The liquidity pool address	varchar	FicF181nDsEcasznMTPp9aLa5Rbpdtd11GtSEa1UUWzx
pool_token_0	Token0's mint address	varchar	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263
pool_token_1	Token1's mint address	varchar	So11111111111111111111111111111111111111112
mint	Mint address of the tvl statistic in this record. this is either token0_address or token1_address	varchar	DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263
symbol	Mint symbol of the tvl statistic in this record	varchar	Bonk
decimals	Mint decimals of the tvl statistic in this record	number	5
raw_amount	raw_amount Raw amount of <mint> tokens in the pool	varchar	1336404100000000
amount	Normalized amount of <mint> tokens in the pool	float	13364041000.0
usd_amount	USD amount of the <mint> tokens in the pool	float	4305.641747889275
usd_exchange_rate	USD exchange rate per token	float	3.2218112382226585e-07
block_slot	Block slot of the txn	number	211671832
block_height	Block height of the txn	number	194094461
block_timestamp	Block timestamp of the txn	timestamp_ntz	2023-08-15 23:46:04+00:00
block_hash	Block hash of the txn	varchar	AH4Jqy4rNZSFh1kMcE1A2Rm3YusQsELtmQTS2AxrkE6C
txn_id	Txn id of the txn	varchar	5wEwd4siUAADLJh7gNHQn3FENAq9buscXQDUaMsc52vdBoRnY8JQ8JHgMraQsFTcM7BbBQyiE6u2jVMngJye6D3L
txn_index	Txn index of the txn	number	2698