DEX Swaps

The dex_swaps table provides indexed views of all DEX swaps transacted for a specified chain.

Columns

Name	Description	Type
block_number	The block number at which the DEX swap occurred.	integer
log_index	The log index at which the DEX swap occurred.	integer
transaction_hash	The transaction hash at which the DEX swap occurred.	text
timestamp	The timestamp of the DEX swap (in ISO-8601 format).	timestamp
exchange_name	The name of the exchange that hosted the DEX swap.	text
contract_version	The version of the exchange contract that hosted the DEX swap (e.g. v1 or v2 for Balancer).	text
contract_address	The contract address of the pool that performed the DEX swap.	text
from_token_address	The address of the token that was swapped in.	text
quantity_in	The amount of the token that was swapped in.	numeric
to_token_address	The address of the token that was swapped out.	text
quantity_out	The amount of the token that was swapped out.	numeric
effective_price	The price of the to-token denominated by the from-token (i.e. quantity_out / quantity_in).	numeric
sender_address	The address that performed the swap.	text
origin_address	The address that submitted the transaction that contained the swap.	text
__confirmed	Flag indicating whether the transfer has been confirmed.	boolean

Indexes

The following indexes are available for this table:

(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)
(transaction_hash, log_index)
(contract_address, 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.