Skip to main content
Schema: monad.defi Table: ez_dex_swaps Type: View

What

This table provides a comprehensive view of token swap events across major decentralized exchanges (DEXs) on EVM blockchains. It standardizes swap data from different DEX protocols into a unified format, enabling cross-DEX analysis and DeFi trading insights.

Key Use Cases

  • Analyzing D

Columns

Column NameData TypeDescription
AMOUNT_INFLOATThe decimal-adjusted quantity of tokens provided by the t…
AMOUNT_IN_UNADJFLOATThe raw, non-decimal adjusted amount of tokens provided i…
AMOUNT_IN_USDFLOATUSD value of tokens provided in the swap at time of trans…
AMOUNT_OUTFLOATThe decimal-adjusted quantity of tokens received by the t…
AMOUNT_OUT_UNADJFLOATThe raw, non-decimal adjusted amount of tokens received f…
AMOUNT_OUT_USDFLOATUSD value of tokens received from the swap at time of tra…
BLOCK_NUMBERNUMBERSequential counter representing the position of a block i…
BLOCK_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the block was produced by validators/m…
CONTRACT_ADDRESSTEXTThe contract address of the swap. This is the address of …
EVENT_INDEXNUMBERZero-based sequential position of the event within a tran…
EVENT_NAMETEXTThe event name as defined in the contract’s ABI.
**Forma… | | EZ_DEX_SWAPS_ID | TEXT | Primary key - unique identifier for each row ensuring dat… | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flip… | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. … | | ORIGIN_FROM_ADDRESS | TEXT | The externally-owned account (EOA) or contract address th… | | ORIGIN_FUNCTION_SIGNATURE | TEXT | Function signature (first 4 bytes) of the called method. … | | ORIGIN_TO_ADDRESS | TEXT | The destination address for the transaction - either an E… | | PLATFORM | TEXT | The DEX protocol where the swap occurred. Example: ‘unis… | | PROTOCOL | TEXT | The protocol used for the swap. This is the clean name of… | | PROTOCOL_VERSION | TEXT | The version of the protocol used for the swap. Example: … | | SENDER | TEXT | The address that initiated the swap transaction. Example… | | SYMBOL_IN | TEXT | The ticker symbol of the token being sold/swapped from. … | | SYMBOL_OUT | TEXT | The ticker symbol of the token being bought/received. Ex… | | TOKEN_IN | TEXT | The contract address of the token being sold in the swap… | | TOKEN_IN_IS_VERIFIED | TEXT | Whether the token in the swap is verified. Example: true | | TOKEN_OUT | TEXT | The contract address of the token being received from the… | | TOKEN_OUT_IS_VERIFIED | TEXT | Whether the token out of the swap is verified. Example: … | | TX_HASH | TEXT | Unique 66-character identifier for the transaction. **Fo… | | TX_TO | TEXT | The recipient address of the swapped tokens. Example: ‘0… |