date(block_timestamp) as "Date",

tx_hash as "Transaction Hash",

coalesce(AMOUNT_OUT_USD , AMOUNT_IN_USD) as "USD Volume",

SYMBOL_IN as "From Token",

AMOUNT_IN as "From Token Volume",

AMOUNT_IN_USD as "From Token USD Volume",

SYMBOL_OUT as "To Token",

AMOUNT_OUT as "To Token Volume",

AMOUNT_OUT_USD as "To Token USD Volume",

platform as "DEX"

from base.defi.ez_dex_swaps

where block_timestamp >= '{{Start_Date}}'

and block_timestamp <= '{{End_Date}}'

and AMOUNT_IN_USD is not null

and AMOUNT_OUT_USD is not null

order by 3 desc

limit 100