--DATE_TRUNC(month,block_timestamp) date,

--origin_to_address,

platform,

COUNT(DISTINCT tx_hash) No_of_transaction

--symbol_in,

--amount_in_usd

FROM optimism.defi.ez_dex_swaps

WHERE

event_name = 'Swap'

--AND platform = 'uniswap-v3'

AND amount_in_usd IS NOT NULL

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

GROUP BY 1

ORDER BY 1 DESC

LIMIT 1000