Skip to content

Dex Swaps

The optimism.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 last block number in the batch that the data was updated 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
0x-v1 1inch-v1 1inch-v2 1inch-v3
archly-v1 balancer-v2 bitkeep-v1 clipper-v1
curve-metapool curve-v1 dodo-v1 dodoswap-private
dodoswap-stable dodoswap-v2 elkswap-v1 firebird-v1
kyber-elastic kyber-v1 kyber-v2 metamask-v1
okx-v1 open-ocean-v1 openxswap-v1 paraswap-v1
solidly-v1-forks sushiswap-v3 synapse-v1 uniswap-v2-forks
uniswap-v3 velodrome-v1 velodrome-v2 whaleswap-v1
zipswap-v1

Indexes

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