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

date >= '2023-01-01'

GROUP BY

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

ORDER BY 1 DESC

LIMIT 1000