dex_swaps table provides indexed views of all DEX swaps transacted for a specified chain.
|block_number||The block number at which the DEX swap occurred.||
|log_index||The log index at which the DEX swap occurred.||
|transaction_hash||The transaction hash at which the DEX swap occurred.||
|timestamp||The timestamp of the DEX swap (in ISO-8601 format).||
|exchange_name||The name of the exchange that hosted the DEX swap.||
|contract_version||The version of the exchange contract that hosted the DEX swap (e.g.
|contract_address||The contract address of the pool that performed the DEX swap.||
|from_token_address||The address of the token that was swapped in.||
|quantity_in||The amount of the token that was swapped in.||
|to_token_address||The address of the token that was swapped out.||
|quantity_out||The amount of the token that was swapped out.||
|effective_price||The price of the to-token denominated by the from-token (i.e.
|sender_address||The address that performed the swap.||
|origin_address||The address that submitted the transaction that contained the swap.||
|__confirmed||Flag indicating whether the transfer has been confirmed.||
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.