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.
||The name of the DEX aggregator that facilitated the DEX swap (null if not found).|
||The block number at which the DEX swap occurred.|
||The contract address of the pool that facilitated the DEX swap.|
||The version of the exchange contract (e.g.
||The price of the to-token denominated by the from-token (i.e.
||The name of the exchange that facilitated the DEX swap.|
||The address of the token that was swapped in.|
||The log index at which the DEX swap occurred.|
||The address that submitted the transaction that contained the swap.|
||The amount of the token that was swapped in.|
||The amount of the token that was swapped out.|
||The address that sent the tokens to the pool in the swap.|
||The timestamp at which the DEX swap occurred.|
||The address of the token that was swapped out.|
||The transaction hash at which the DEX swap occurred.|
||The last block number in the batch that the data was updated in.|
||Flag indicating whether the transfer has been confirmed.|
||The date at which this row was last updated (in ISO-8601 format).|
|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|
|__indexer_id WHERE __confirmed = false|
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.