Pools

Coming Soon

We're actively working on expanding our DEX pools coverage to other chains like Ink. If you'd like to request support for ink, please reach out to our team.

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

Protocols indexed by Allium:

• velodrome_protocol, 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