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

What

A comprehensive convenience table holding blockchain and platform specific decentralized exchange swaps.

Columns

Column NameData TypeDescription
BLOCKCHAINTEXTBlockchain, Network, or Platform the token price is recorded on.
PLATFORMTEXTThe name of the dex or swap platform, typically a concatenation of the protocol and version.
PROTOCOLTEXTThe name of the protocol.
PROTOCOL_VERSIONTEXTThe version of the protocol.
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 identifier that is generated when a transaction is executed.
CONTRACT_ADDRESSTEXTThe contract address interacted with for the swap, typically the liquidity pool or router address, where applicable. Value may be NULL for certain chains, such as Osmosis and Near, where records occur at a different granularity such as one row per transaction rather than one row per event.
TRADERTEXTThe address that initiated the swap.
TOKEN_INTEXTThe address of the token sent for swap.
SYMBOL_INTEXTThe symbol of the token sent for swap.
TOKEN_IN_IS_VERIFIEDBOOLEANTOKEN_IN_IS_VERIFIED column
AMOUNT_IN_RAWFLOATThe unadjusted amount of tokens put into the swap.
AMOUNT_INFLOATThe decimal adjusted 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.
TOKEN_OUTTEXTThe address of the token being swapped to.
TOKEN_OUT_IS_VERIFIEDBOOLEANTOKEN_OUT_IS_VERIFIED column
SYMBOL_OUTTEXTThe symbol of the token being swapped to.
AMOUNT_OUT_RAWFLOATThe unadjusted amount of tokens taken out of or received from the swap.
AMOUNT_OUTFLOATThe decimal adjusted 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.
_LOG_IDTEXT_LOG_ID column
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.
EZ_DEX_SWAPS_IDTEXTThe unique identifier for each row in the table.