SELECT
date_trunc('day', block_timestamp) AS Date,
--origin_from_address,
--amount_in_usd,
platform,
--symbol_in,
COUNT(DISTINCT tx_hash) AS No_Of_Transaction
--event_name
FROM optimism.defi.ez_dex_swaps
WHERE amount_in_usd IS NOT NULL
AND DATE(block_timestamp) >= '2023-01-01'
GROUP BY 1, 2
ORDER BY No_Of_Transaction DESC