-- forked from BASE-TOTAL TXNS @ https://flipsidecrypto.xyz/edit/queries/3e172521-eb33-4887-9dde-ce3601214643
SELECT
date_trunc('day' , block_timestamp) as date,
COUNT(tx_hash) AS total_transactions,
FROM base.defi.ez_dex_swaps
WHERE date(block_timestamp) >= '2024-04-01'
GROUP BY 1
ORDER BY 1 DESC