SELECT

date_trunc('day', block_timestamp) as date,

COUNT(tx_hash) as total_transactions

FROM optimism.defi.ez_dex_swaps

WHERE date(block_timestamp) >= '2024-01-01'

GROUP BY 1

ORDER BY 1 DESC