Skip to content

Dex Pools

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


Name Type Description
contract_address text The contract address of the DEX pool.
contract_version text The version of the exchange contract that the DEX pool belongs to (e.g. v1 or v2).
created_block_number integer The block number at which the DEX pool was created.
created_timestamp timestamp without time zone The timestamp at which the DEX pool was created.
creator_address text The address that initiated the pool creation transaction.
exchange_name text The name of the exchange that the DEX pool belongs to.
factory_address text The address of the factory that created the pool.
is_active boolean Whether the pool is active or not.
last_active_timestamp timestamp The timestamp at which the pool was last active.
metadata json Additional protocol-specific metadata for the pool.
token_addresses ARRAY A list of token addresses that the pool contains (can include NFT contract addresses for SudoSwap pools).
__block_number integer An internal identifier for the indexer that updates this row.
__confirmed boolean Flag indicating whether the transfer has been confirmed.

Supported Protocols

acy-v1 apeswap-v2 apeswap-v3 balancer-v2
boltr-v1 cafeswap-v1 cometh-v1 cometh-v2
curve-lending curve-metapool curve-v1 curve-v2
dfyn-v1 dfyn-v2 dodoswap-private dodoswap-stable
dodoswap-v1 dodoswap-v2 elkswap-v1 elkswap-v2
fraxswap-v1 fraxswap-v2 gravis-v1 gravity-v1
gravity-v2 honeyswap-v1 honeyswap-v2 idex-v1
jetswap-v1 kakidex-v1 kryptodex-v1 kyber-v3
magician-v1 meshswap-v1 mmfinance-v1 mmfinance-v2
oboswap-v1 pearzap-v1 polycat-v1 polycat-v2
quickswap-v1 quickswap-v2 quickswap-v3 radioshack-v1
solidly-v1-forks stableworld-v1 sushiswap-v1 sushiswap-v2
synapse-v1 tetuswap-v1 unifi-v1 uniswap-v2-forks
uniswap-v3 uniswap-v3-forks vulcanswap-v1 wault-finance-v1


__indexer_id, __block_number
__indexer_id WHERE __confirmed = false
created_timestamp, contract_address
factory_address, created_timestamp, contract_address
creator_address, created_timestamp, contract_address
exchange_name, created_timestamp, contract_address
exchange_name, created_block_number, contract_address
exchange_name, contract_version, created_block_number
exchange_name, contract_version, created_timestamp

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.