Skip to content

Aggregate 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 chains: ethereum, polygon.

Supported DEX

At the time of writing, we support:

Ethereum DEX
0x 1inch afro-dex airswap atomic-blue
az-exchange balancer bancor bean-dex bebop
bitcratic bitox-io cityswap coin-change-ex cowswap
cryptlo curve ddex decentrex defi-swap
dex-blue dodoswap e-dex elasticswap enclaves
etherdelta etherdelta-fork ether-next ethmall ex-toke
fraxswap kyber market-place miniswap n-dex-market
oasis polaris-dex saddle-finance sakeswap sashimiswap
seed_dex shibaswap singular-x smoothyswap sushiswap
synapse tokenstore tokenstore_fork tradex-one unicly
uniswap unitrade Zeedex
Polygon DEX
acy apeswap balancer bebop boltr
cafewap cometh curve dfyn dodoswap
elkswap fraxswap gravis gravity honeyswap
idex jetswap kakidex kryptodex kyber
magician meshswap mm-finance oboswap pearzap
polycat quickswap radioshack stableworld sushiswap
tetuswap unifi uniswap vulcanswap wault-finance

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.