DATE_TRUNC(day, block_timestamp) AS date,

COUNT(DISTINCT tx_hash)

FROM arbitrum.defi.ez_dex_swaps

WHERE amount_in_usd IS NOT NULL

AND date(block_timestamp) >= '2023-02-22'

GROUP BY 1

ORDER BY 1 ASC

LIMIT 1000