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

Table Columns

Unique Key: liquidity_pool_address

ColumnData TypeDescription
projectVARCHARThe project or platform name
protocolVARCHARThe specific protocol or version used
liquidity_pool_addressVARCHARThe address of the liquidity pool
token0_addressVARCHARThe address of the first token in the pair
token0_nameVARCHARThe name of the first token
token0_symbolVARCHARThe symbol of the first token
token0_decimalsBIGINTThe number of decimal places for the first token
token1_addressVARCHARThe address of the second token in the pair
token1_nameVARCHARThe name of the second token
token1_symbolVARCHARThe symbol of the second token
token1_decimalsBIGINTThe number of decimal places for the second token
tokens_arrayARRAYAn array containing the addresses of all tokens for pools with more than two tokens
feeBIGINTThe fee associated with the pool
tick_spacingVARCHARThe spacing between ticks in the pool
factory_addressVARCHARThe address of the factory contract that created the pool
extra_fieldsVARIANTAdditional fields emitted in pool creation in JSON format
transaction_hashVARCHARThe hash of the transaction (*null for seed pools)
transaction_indexBIGINTThe index of the transaction within the block (*null for seed pools)
log_indexBIGINTThe index of the log entry within the transaction (*null for seed pools)
trace_idVARCHARThe ID of the trace (if applicable)
block_timestampTIMESTAMP_NTZ(9)The timestamp of the block
block_numberBIGINTThe number of the block
block_hashVARCHARThe hash of the block
_created_atTIMESTAMP_NTZ(9)Timestamp when the record was created
_updated_atTIMESTAMP_NTZ(9)Timestamp when the record was last updated