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 | solidly-v3 | 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.