Pools
The DEX pools table contains liquidity pool deployed by protocol indexed by Allium, consolidated into a single table.
Table Columns
Unique Key: liquidity_pool_address
project
The project or platform name
protocol
The specific protocol or version used
liquidity_pool_address
The address of the liquidity pool
token0_address
The address of the first token in the pair
token0_name
The name of the first token
token0_symbol
The symbol of the first token
token0_decimals
The number of decimal places for the first token
token1_address
The address of the second token in the pair
token1_name
The name of the second token
token1_symbol
The symbol of the second token
token1_decimals
The number of decimal places for the second token
tokens_array
An array containing the addresses of all tokens for pools with more than two tokens
fee
The fee associated with the pool
tick_spacing
The spacing between ticks in the pool
factory_address
The address of the factory contract that created the pool
extra_fields
Additional fields emitted in pool creation in JSON format
transaction_hash
The hash of the transaction (*null for seed pools)
transaction_index
The index of the transaction within the block (*null for seed pools)
log_index
The index of the log entry within the transaction (*null for seed pools)
trace_id
The ID of the trace (if applicable)
block_timestamp
The timestamp of the block
block_number
The number of the block
block_hash
The hash of the block
_created_at
Timestamp when the record was created
_updated_at
Timestamp when the record was last updated
Last updated