Pools

The dex.pools table contains liquidity pools of DEX protocols indexed by Allium, consolidated into a single table.

For seed pools such as Curve, the pool creation transaction information is unavailable, so the block, transactions and log details are null.

Protocols indexed by Allium:

• algebra_protocol, balancer_v1, balancer_v2, curve, dodo_v2, maverick_v1, maverick_v2, native_v1, solidly_protocol, pancakeswap_v3, traderjoe_v2_1, uniswap_v3_protocol, uniswap_v2_protocol,

Table Columns

Unique Key: liquidity_pool_address

Column	Data Type	Description
project	VARCHAR	The project or platform name
protocol	VARCHAR	The specific protocol or version used
liquidity_pool_address	VARCHAR	The address of the liquidity pool
token0_address	VARCHAR	The address of the first token in the pair
token0_name	VARCHAR	The name of the first token
token0_symbol	VARCHAR	The symbol of the first token
token0_decimals	BIGINT	The number of decimal places for the first token
token1_address	VARCHAR	The address of the second token in the pair
token1_name	VARCHAR	The name of the second token
token1_symbol	VARCHAR	The symbol of the second token
token1_decimals	BIGINT	The number of decimal places for the second token
tokens_array	ARRAY	An array containing the addresses of all tokens for pools with more than two tokens
fee	BIGINT	The fee associated with the pool
tick_spacing	VARCHAR	The spacing between ticks in the pool
factory_address	VARCHAR	The address of the factory contract that created the pool
extra_fields	VARIANT	Additional fields emitted in pool creation in JSON format
transaction_hash	VARCHAR	The hash of the transaction (*null for seed pools)
transaction_index	BIGINT	The index of the transaction within the block (*null for seed pools)
log_index	BIGINT	The index of the log entry within the transaction (*null for seed pools)
trace_id	VARCHAR	The ID of the trace (if applicable)
block_timestamp	TIMESTAMP_NTZ(9)	The timestamp of the block
block_number	BIGINT	The number of the block
block_hash	VARCHAR	The hash of the block
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated