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

ProjectProtocol
meteorameteora-dlmm
orcaorca-whirlpool
phoenixphoenix

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

Table Columns

Column NameDescriptionTypeExamples
projectThe dex projectvarcharphoenix
protocolThe protocol used by the dex projectvarcharphoenix
poolThe liquidity pool addressvarcharFicF181nDsEcasznMTPp9aLa5Rbpdtd11GtSEa1UUWzx
pool_token_0Token0’s mint addressvarcharDezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263
pool_token_1Token1’s mint addressvarcharSo11111111111111111111111111111111111111112
mintMint address of the tvl statistic in this record. this is either token0_address or token1_addressvarcharDezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263
symbolMint symbol of the tvl statistic in this recordvarcharBonk
decimalsMint decimals of the tvl statistic in this recordnumber5
raw_amountraw_amount Raw amount of <mint> tokens in the poolvarchar1336404100000000
amountNormalized amount of <mint> tokens in the poolfloat13364041000.0
usd_amountUSD amount of the <mint> tokens in the poolfloat4305.641747889275
usd_exchange_rateUSD exchange rate per tokenfloat3.2218112382226585e-07
block_slotBlock slot of the txnnumber211671832
block_heightBlock height of the txnnumber194094461
block_timestampBlock timestamp of the txntimestamp_ntz2023-08-15 23:46:04+00:00
block_hashBlock hash of the txnvarcharAH4Jqy4rNZSFh1kMcE1A2Rm3YusQsELtmQTS2AxrkE6C
txn_idTxn id of the txnvarchar5wEwd4siUAADLJh7gNHQn3FENAq9buscXQDUaMsc52vdBoRnY8JQ8JHgMraQsFTcM7BbBQyiE6u2jVMngJye6D3L
txn_indexTxn index of the txnnumber2698