Skip to content

Dex Pools

The ethereum.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.

Columns

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 date at which the account was last active (in ISO-8601 format).
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 The block number at which the event took place in.
__confirmed boolean Flag indicating whether the transfer has been confirmed.
__last_modified timestamp The date at which this row was last updated (in ISO-8601 format).

Supported Protocols

Protocol
1inch-v2 apeswap-v2 balancer-v1 balancer-v1-forks
balancer-v2 bancor-v1 bancor-v2 cityswap-v1
collection-v1 collection-v2 curve-metapool curve-plain
curve-tricrypto curve-v1 curve-v2 defi-swap-v1
dfx-v1 dfx-v2 dodoswap-private dodoswap-stable
dodoswap-v1 dodoswap-v2 elasticswap-v1 fraxswap-v1
fraxswap-v2 kyber-elastic kyber-v2 kyber-v3
maverick-v1 miniswap-v1 pancakeswap-v2 pancakeswap-v3
pendle-v2 saddle-finance-metapool saddle-finance-stableswap sakeswap-v1
sashimiswap-v1 shibaswap-v2 smardex-v1 solidly-v1
solidly-v1-forks sudoswap-v1 sudoswap-v2 sushiswap-v1
sushiswap-v2 sushiswap-v3 synapse-v1 traderjoe-v2
unicly-v1 uniswap-v1 uniswap-v2 uniswap-v2-forks
uniswap-v3 uniswap-v3-forks unsheth-v2 zkswap-v1
zkswap-v2

Indexes

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

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.