date_trunc('day', block_timestamp) AS Date,

platform,

COUNT (DISTINCT tx_hash) AS No_of_transaction,

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) >= '2024-01-01'

GROUP BY 1,2

ORDER BY 1,3 DESC

LIMIT 1000