Skip to content

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.


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

1inch-v1 1inch-v2 acy-v1 apeswap-v1
apeswap-v2 apeswap-v3 balancer-v2 bebop-v1
bitkeep-v1 bitkeep-v2 bitkeep-v3 boltr-v1
cafeswap-v1 cometh-v1 cometh-v2 curve-lending
curve-metapool curve-v1 curve-v2 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 kakidex-v1 kryptodex-v1
kyber-v1 kyber-v3 magician-v1 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
synapse-v1 tetuswap-v1 unifi-v1 uniswap-v2-forks
uniswap-v3 uniswap-v3-forks vulcanswap-v1 wault-finance-v1


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.