Skip to content

Dex Swaps

The ethereum.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 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
03-swap-v1 03-swap-v10 03-swap-v11 03-swap-v12
03-swap-v13 03-swap-v14 03-swap-v15 03-swap-v16
03-swap-v17 03-swap-v18 03-swap-v19 03-swap-v2
03-swap-v20 03-swap-v3 03-swap-v4 03-swap-v5
03-swap-v6 03-swap-v7 03-swap-v8 03-swap-v9
0x-v1 0x-v2 0x-v3 1inch-v1
1inch-v10 1inch-v11 1inch-v12 1inch-v2
1inch-v3 1inch-v4 1inch-v5 1inch-v6
1inch-v7 1inch-v8 1inch-v9 afro-dex-v1
airswap-legacy airswap-v1 airswap-v2 airswap-v3
ambient-v1 apeswap-v2 atomic-blue-v1 atomic-blue-v2
az-exchange-v1 balancer-v1 balancer-v1-forks balancer-v2
bananagun-v1 bancor-carbon bancor-v1 bancor-v2
bean-dex-v1 bebop-v1 bitcratic-v1 bitcratic-v2
bitox-io-v1 bzx-v1 cityswap-v1 clipper-v1
coin-change-ex-v1 coinbase-v1 collection-v1 collection-v2
cowswap-v1 cowswap-v2 cowswap-v3 cryptlo-v2
curve-lending curve-metapool curve-tricrypto curve-v1
curve-v2 ddex-hybrid ddex-hydro decentrex-v1
decentrex-v2 decentrex-v3 defi-swap-v1 dex-ag-v1
dex-ag-v2 dex-ag-v3 dex-ag-v4 dex-blue-v1
dfx-v1 dfx-v2 dodo-v1 dodo-v2
dodoswap-private dodoswap-stable dodoswap-v1 dodoswap-v2
dutchx-v1 e-dex-v1 elasticswap-v1 enclaves-v1
ether-next-v1 etherdelta-1-forks etherdelta-v1 etherdelta-v2
etherdelta-v3 etherdelta-v4 etherdelta-v5 ethmall-v1
ex-toke-v1 firebird-v1 fraxswap-v1 fraxswap-v2
genieswap-v1 genieswap-v2 genieswap-v3 hashflow-v1
hashflow-v2 hashflow-v3 kyber-elastic kyber-v1
kyber-v2 kyber-v3 makerdao-psm market-place-v1
maverick-v1 miniswap-v1 mistx-v1 mstable-v1
n-dex-market-v1 oasis-v1 odos-v1 open-ocean-v1
open-ocean-v2 pancakeswap-mm pancakeswap-v2 pancakeswap-v3
paraswap-v1 paraswap-v2 paraswap-v3 paraswap-v4
paraswap-v5 paraswap-v6 paraswap-v7 pendle-v2
polaris-dex-v1 saddle-finance-metapool saddle-finance-stableswap sakeswap-v1
sashimiswap-v1 seed_dex-v1 seed_dex-v2 shibaswap-v2
singular-x-v1 smardex-v1 smoothyswap-v1 solidly-v1
solidly-v1-forks sudoswap-v1 sudoswap-v2 sushiswap-v1
sushiswap-v2 sushiswap-v3 swaap-v1 synapse-v1
synthetix-v1 tokenlon-v1 tokenlon-v2 tokenlon-v3
tokenlon-v4 tokenlon-v5 tokenstore-v1 tokenstore-v1-forks
traderjoe-v2 tradex-one-v1 unibot-v1 unicly-v1
uniswap-v1 uniswap-v2 uniswap-v2-forks uniswap-v3
uniswap-v3-forks uniswap-x unitrade-v1 unsheth-v2
vanilla-v1 xy-finance-v1 zeedex-v1 zeedex-v2
zerion-v1 zerion-v2 zkswap-v1 zkswap-v2

Indexes

Index
exchange_name, timestamp, log_index
exchange_name, from_token_address, timestamp, log_index
__indexer_id, __block_number
__indexer_id WHERE __confirmed = false
exchange_name, contract_version, timestamp, log_index
__last_modified
contract_address, timestamp, log_index
aggregator_name, timestamp, log_index
transaction_hash, log_index
to_token_address, timestamp, log_index
timestamp, log_index
sender_address, timestamp, log_index
origin_address, timestamp, log_index
from_token_address, to_token_address, timestamp, log_index
from_token_address, timestamp, log_index
exchange_name, to_token_address, timestamp, log_index
block_number, 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.