Table of contents

The eth_mainnet.dex_swaps table provides indexed views of all blocks.

Columns

Name	Type	Description
block_number	integer	The block number at which the DEX swap occurred.
log_index	integer	The log index at which the DEX swap occurred.
transaction_hash	varchar	The transaction hash at which the DEX swap occurred.
timestamp	integer	The timestamp at which the DEX swap occurred.
exchange_name	varchar	The name of the exchange that facilitated the DEX swap.
contract_version	varchar	The version of the exchange contract (e.g. v1 or v2).
aggregator_name	varchar	The name of the DEX aggregator that facilitated the DEX swap (null if not found).
contract_address	varchar	The contract address of the pool that facilitated the DEX swap.
from_token_address	varchar	The address of the token that was swapped in.
to_token_address	varchar	The address of the token that was swapped out.
quantity_in	bigint	The amount of the token that was swapped in.
quantity_out	bigint	The amount of the token that was swapped out.
effective_price	varchar	The price of the to-token denominated by the from-token (i.e. quantity_out / quantity_in).
sender_address	varchar	The address that sent the tokens to the pool in the swap.
origin_address	varchar	The address that submitted the transaction that contained the swap.
block_time	date	N/A
ym	varchar	N/A