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

---origin_from_address,

---amount_in_usd,

platform,

---symbol_in,

COUNT(DISTINCT tx_hash) AS no_of_trx

---event_name

FROM ethereum.defi.ez_dex_swaps

WHERE event_name = 'Swap'

AND amount_in_usd IS NOT NULL

AND platform ='uniswap-v3'

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

GROUP BY 1 --2

ORDER BY 1 DESC

LIMIT 1000