date_trunc('day', block_timestamp) date,

platform,

COUNT(DISTINCT tx_hash) AS no_of_transaction

FROM polygon.defi.ez_dex_swaps

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

AND block_timestamp::date >= '2024-01-01'

AND amount_in_usd IS NOT NULL

GROUP BY 1, 2

ORDER BY 3 DESC

LIMIT 1000