Pools

This table contains information for various dex pools.

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

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

Table Columns

Column Name	Description	Type	Example
project	The dex project	varchar	meteora
protocol	The protocol used by the dex project	varchar	meteora-dlmm
liquidity_pool_address	The liquidity pool address	varchar	3WHNf55iBawfL7U1cC4Htj11KKmC8hvrrbdM31yPUr4C
token0_address	Token0's mint address	varchar	So11111111111111111111111111111111111111112
token0_symbol	Token0's symbol, if available	varchar	SOL
token0_decimals	Token0's decimal, if available	number	9
token0_vault	Token account that holds token0	varchar	Dp7VdsZ2N6sxsrezjt1EMHkELBfaAYSVJXVR753zdYJV
token1_address	Token1's mint address	varchar	EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v
token1_symbol	Token1's symbol, if available	varchar	USDC
token1_decimals	Token1's decimal, if available	number	6
token1_vault	Token account that holds token1	varchar	CZULKXqq1fPYs8xwQGMamZm1pHH5nVnRZzmm5RLnQ33r
tvl	Latest tvl in USD of this pool, calculated from solana.dex.tvl	float	2068.9457757486857
block_slot	Block slot of the txn	number	228499898
block_height	Block height of the txn	number	210416091
block_timestamp	Block timestamp of the txn	timestamp_ntz	2023-11-07 05:11:45+00:00
block_hash	Block hash of the txn	varchar	BNCv6p7EYHwGUNop1kACfTgA9Km6mc8LbSHJq5B9HEA2
txn_id	Txn id of the txn	varchar	4GCpQa7BVefNiwhrB9QhSha4ZLMmQBdYgWTVXwspreBQhx7zdm1a1cTsgW6zjGdqdJH64fxXEiBZY1j5jD5aGgjb
txn_index	Txn index of the txn	number	51
instruction_index	Instruction index of the instruction	number	0
inner_instruction_index	Inner instruction index of the instruction, within its parent instruction	number	0
_tvl_updated_at	Last updated time of the tvl column	timestamp_ntz	2024-02-09 07:31:49+00:00