--date_trunc('day', block_timestamp) date,

--origin_from_address,

platform,

--symbol_in,

--amount_in,

--amount_in_usd,

COUNT(DISTINCT tx_hash) No_of_Transactions

--event_name

FROM

ethereum.defi.ez_dex_swaps

WHERE

event_name = 'Swap'

AND

amount_in_usd IS NOT NULL

--AND

--platform LIKE 'uniswap-v3'

AND

block_timestamp >= '2023-01-01'

GROUP BY

1--, 2, 3, 4, 5, 6, 8

ORDER BY 2 DESC

LIMIT 1000