optimism.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 timestamp of when the pool was last active.|
||Additional protocol-specific metadata for the pool.|
||A list of token addresses that the pool contains (can include NFT contract addresses for SudoSwap pools).|
||An internal identifier for the indexer that updates this row. Use block_number instead when querying.|
||Flag indicating whether the transfer has been confirmed.|
||The date at which this row was last updated (in ISO-8601 format).|
|exchange_name, contract_version, created_block_number, contract_address|
|exchange_name, contract_version, created_timestamp, contract_address|
|exchange_name, created_block_number, contract_address|
|exchange_name, created_timestamp, contract_address|
|creator_address, created_timestamp, contract_address|
|factory_address, created_timestamp, contract_address|
|__indexer_id WHERE __confirmed = false|
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.