date_trunc ('day', block_timestamp) AS date,

origin_from_address,

amount_in_usd,

platform,

symbol_in,

COUNT (DISTINCT tx_hash) No_of_trx,

event_name

FROM ethereum.defi.ez_dex_swaps

WHERE event_name ='swap' AND amount_in_usd IS NOT NULL

AND platform = 'sushiswap'

AND DATE(block_timestamp) >='2023-01-01'

GROUP BY 1,2,3,4,5,7

ORDER BY 1 DESC