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

platform,

COUNT(DISTINCT origin_from_address) AS active_users

---amount_in_usd,

---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

ORDER BY 1 DESC

LIMIT 1000