DEX Pools

The dex_pools table provides indexed views of all DEX pools created for a specified chain.

Supported DEXs

Base
leetswap v2	rocketswap v2	damaswap v2	uniswap v2 forks	solidly forks

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.