platform,

COUNT(DISTINCT tx_hash) AS no_of_trx

FROM ethereum.defi.ez_dex_swaps

WHERE event_name = 'Swap'

AND amount_in_usd IS NOT NULL

AND platform IN ('uniswap-v3','sushiswap','balancer','curve')

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

GROUP BY 1

ORDER BY 1 DESC

LIMIT 1500