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 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


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.