date_trunc('day', block_timestamp) AS Date,

platform,

COUNT(DISTINCT origin_from_address) AS Active_Users

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