Skip to main content
Schema: blast.defi Table: ez_dex_swaps Type: View This table currently contains swap events from the fact_event_logs table for AMBIENT, BLADESWAP, BLASTERSWAP, FENIX, RING, SUSHI, and THRUSTER. along with other helpful columns including an amount USD where possible. Other dexes coming soon! Note: A rule has been put in place to null out the amount_USD if that number is too divergent between amount_in_USD and amount_out_usd. This can happen for swaps of less liquid tokens during very high fluctuation of price.

​
Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed. This field will not be unique in this table, as a given transaction can include multiple events.
ORIGIN_FUNCTION_SIGNATURETEXTThe function signature of the contract call.
ORIGIN_FROM_ADDRESSTEXTThe from address of this transaction.
ORIGIN_TO_ADDRESSTEXTThe to address of this transaction.
CONTRACT_ADDRESSTEXTThe address interacted with for a given event.
POOL_NAMETEXT
EVENT_NAMETEXTThe decoded event name for a given event.
AMOUNT_IN_UNADJFLOATThe non-decimal adjusted amount of tokens put into the swap.
AMOUNT_INFLOATThe amount of tokens put into the swap.
AMOUNT_IN_USDFLOATThe amount of tokens put into the swap converted to USD using the price of the token.
AMOUNT_OUT_UNADJFLOATThe non-decimal adjusted amount of tokens taken out of or received from the swap.
AMOUNT_OUTFLOATThe amount of tokens taken out of or received from the swap.
AMOUNT_OUT_USDFLOATThe amount of tokens taken out of or received from the swap converted to USD using the price of the token.
SENDERTEXTThe Router is the Sender in the swap function.
TX_TOTEXTThe tx_to is the address who receives the swapped token. This corresponds to the “to” field in the swap function.
EVENT_INDEXNUMBEREvent number within a transaction.
PLATFORMTEXTThe protocol or platform that the liquidity pool belongs to or swap occurred on.
TOKEN_INTEXTThe address of the token sent for swap.
TOKEN_OUTTEXTThe address of the token being swapped to.
SYMBOL_INTEXTThe symbol of the token sent for swap.
SYMBOL_OUTTEXTThe symbol of the token being swapped to.
EZ_DEX_SWAPS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.
_LOG_IDTEXTThis column is being removed for standardization purposes. Please remove or update your queries with CONCAT(tx_hash, '_', event_index) to reconstruct _log_id by March 10, 2025.