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

ColumnDescription
projectThe project or platform name
protocolThe specific protocol or version used
liquidity_pool_addressThe address of the liquidity pool
token0_addressThe address of the first token in the pair
token0_nameThe name of the first token
token0_symbolThe symbol of the first token
token0_decimalsThe number of decimal places for the first token
token1_addressThe address of the second token in the pair
token1_nameThe name of the second token
token1_symbolThe symbol of the second token
token1_decimalsThe number of decimal places for the second token
tokens_arrayAn array containing the addresses of all tokens for pools with more than two tokens
feeThe fee associated with the pool
tick_spacingThe spacing between ticks in the pool
factory_addressThe address of the factory contract that created the pool
extra_fieldsAdditional fields emitted in pool creation in JSON format
transaction_hashThe hash of the transaction (*null for seed pools)
transaction_indexThe index of the transaction within the block (*null for seed pools)
log_indexThe index of the log entry within the transaction (*null for seed pools)
trace_idThe ID of the trace (if applicable)
block_timestampThe timestamp of the block
block_numberThe number of the block
block_hashThe hash of the block
_created_atTimestamp when the record was created
_updated_atTimestamp when the record was last updated