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.
|created_block_number||The block number at which the DEX pool was created.||
|created_timestamp||The timestamp at which the DEX pool was created.||
|exchange_name||The name of the exchange that the DEX pool belongs to.||
|contract_version||The version of the exchange contract that the DEX pool belongs to (e.g.
|contract_address||The contract address of the DEX pool.||
|token_addresses||A list of token addresses that the pool contains (can include NFT contract addresses for SudoSwap pools).||
|creator_address||The address that initiated the pool creation transaction.||
|factory_address||The address of the factory that created the pool.||
|metadata||Additional protocol-specific metadata for the pool.||
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.