Skip to content

DEX Pools

The dex_pools table provides indexed views of all DEX pools created for a specified chain. All DEX pools tables follows the same database schema presented below.

Supported DEXs

Ethereum
1inch balancer bancor curve dodoswap
fraxswap kyber saddle shibaswap sushiswap
synapse uniswap
Polygon
apeswap balancer curve dfyn dodoswap
fraxswap kyber meshswap mmfinance quickswap
sushiswap uniswap

Columns

Name Description Type
created_block_number The block number at which the DEX pool was created. integer
created_timestamp The timestamp at which the DEX pool was created. integer
exchange_name The name of the exchange that the DEX pool belongs to. text
contract_version The version of the exchange contract that the DEX pool belongs to (e.g. v1 or v2 for Balancer). text
contract_address The contract address of the DEX pool. text
token_addresses A list of token addresses that the pool contains (can include NFT contract addresses for SudoSwap pools). text[]
creator_address The address that initiated the pool creation transaction. text
factory_address The address of the factory that created the pool. text
metadata Additional protocol-specific metadata for the pool. json

Indexes

The following indexes are available for this table:

(created_timestamp, contract_address)
(factory_address, created_timestamp, contract_address)
(creator_address, created_timestamp, contract_address)
(exchange_name, contract_version, created_timestamp, contract_address)
(exchange_name, created_timestamp, contract_address)
GIN (token_addresses)
(exchange_name, contract_version, created_block_number)

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.