avalanche.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.
||The contract address of the DEX pool.|
||The version of the exchange contract that the DEX pool belongs to (e.g.
||The block number at which the DEX pool was created.|
||The timestamp at which the DEX pool was created.|
||The address that initiated the pool creation transaction.|
||The name of the exchange that the DEX pool belongs to.|
||The address of the factory that created the pool.|
||Whether the pool is active or not.|
||The date at which the account was last active (in ISO-8601 format).|
||Additional protocol-specific metadata for the pool.|
||A list of token addresses that the pool contains (can include NFT contract addresses for SudoSwap pools).|
||The block number at which the event took place in.|
||Flag indicating whether the transfer has been confirmed.|
|factory_address, created_timestamp, contract_address|
|exchange_name, contract_version, created_timestamp, contract_address|
|exchange_name, contract_version, created_block_number, contract_address|
|__indexer_id WHERE __confirmed = false|
|exchange_name, created_timestamp, contract_address|
|exchange_name, created_block_number, contract_address|
|creator_address, created_timestamp, 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.