Dex Swaps
The polygon.dex_swaps table provides indexed views of all DEX swaps transacted for the chain. All DEX swaps tables follows the same database schema presented below.
Columns
| Name | Type | Description |
|---|---|---|
| aggregator_name | text |
The name of the DEX aggregator that facilitated the DEX swap (null if not found). |
| block_number | integer |
The block number at which the DEX swap occurred. |
| contract_address | text |
The contract address of the pool that facilitated the DEX swap. |
| contract_version | text |
The version of the exchange contract (e.g. v1 or v2). |
| effective_price | numeric |
The price of the to-token denominated by the from-token (i.e. quantity_out / quantity_in). |
| exchange_name | text |
The name of the exchange that facilitated the DEX swap. |
| from_token_address | text |
The address of the token that was swapped in. |
| log_index | integer |
The log index at which the DEX swap occurred. |
| origin_address | text |
The address that submitted the transaction that contained the swap. |
| quantity_in | numeric |
The amount of the token that was swapped in. |
| quantity_out | numeric |
The amount of the token that was swapped out. |
| sender_address | text |
The address that sent the tokens to the pool in the swap. |
| timestamp | timestamp without time zone |
The timestamp at which the DEX swap occurred. |
| to_token_address | text |
The address of the token that was swapped out. |
| transaction_hash | text |
The transaction hash at which the DEX swap occurred. |
| __block_number | integer |
An internal identifier for the indexer that updates this row. Use block_number instead when querying. |
| __confirmed | boolean |
Flag indicating whether the transfer has been confirmed. |
Supported Protocols
| Protocol | |||
|---|---|---|---|
| 1inch-v1 | 1inch-v2 | acy-v1 | apeswap-v1 |
| apeswap-v2 | apeswap-v3 | balancer-v2 | balancer-v2-forks |
| bebop-v1 | bitkeep-v1 | bitkeep-v2 | bitkeep-v3 |
| boltr-v1 | cafeswap-v1 | chimpyswap-v1 | cometh-v1 |
| cometh-v2 | curve-lending | curve-metapool | curve-v1 |
| curve-v2 | darkpools-v1 | dfyn-v1 | dfyn-v2 |
| dodo-v1 | dodoswap-private | dodoswap-stable | dodoswap-v1 |
| dodoswap-v2 | elkswap-v1 | elkswap-v2 | firebird-v1 |
| fraxswap-v1 | fraxswap-v2 | gravis-v1 | gravity-v1 |
| gravity-v2 | honeyswap-v1 | honeyswap-v2 | idex-v1 |
| jetswap-v1 | jetswap-v2 | kakidex-v1 | kryptodex-v1 |
| kyber-elastic | kyber-v1 | kyber-v2 | kyber-v3 |
| magician-v1 | magician-v2 | meshswap-v1 | metamask-v1 |
| mmfinance-v1 | mmfinance-v2 | oboswap-v1 | open-ocean-v1 |
| open-ocean-v2 | paraswap-v1 | paraswap-v2 | pearzap-v1 |
| polycat-v1 | polycat-v2 | quickswap-v1 | quickswap-v2 |
| quickswap-v3 | radioshack-v1 | slingshot-v1 | solidly-v1-forks |
| stableworld-v1 | sushiswap-v1 | sushiswap-v2 | sushiswap-v3 |
| swaap-v1 | synapse-v1 | tetuswap-v1 | unifi-v1 |
| uniswap-v2-forks | uniswap-v3 | uniswap-v3-forks | vulcanswap-v1 |
| wault-finance-v1 | xy_finance-v1 |
Indexes
| Index |
|---|
| block_number, log_index |
| __indexer_id, __block_number |
| __indexer_id WHERE __confirmed = false |
| transaction_hash, log_index |
| timestamp, log_index |
| from_token_address, timestamp, log_index |
| to_token_address, timestamp, log_index |
| from_token_address, to_token_address, timestamp, log_index |
| origin_address, timestamp, log_index |
| sender_address, timestamp, log_index |
| contract_address, timestamp, log_index |
| exchange_name, timestamp, log_index |
| exchange_name, from_token_address, timestamp, log_index |
| exchange_name, to_token_address, timestamp, log_index |
| exchange_name, contract_version, timestamp, log_index |
| aggregator_name, timestamp, log_index |
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.