date_trunc('day', block_timestamp) date,

platform,

COUNT(DISTINCT tx_hash) AS no_of_transaction

FROM arbitrum.defi.ez_dex_swaps

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

AND block_timestamp::date BETWEEN '2023-01-01' AND '2023-12-31'

AND amount_in_usd IS NOT NULL

GROUP BY 1, 2

ORDER BY 3 DESC

LIMIT 1000