-- forked from BASE-TOTAL-VOLUME @ https://flipsidecrypto.xyz/edit/queries/4ac36876-6ff4-417e-8552-bb40d06086b1
SELECT
date_trunc('day' , block_timestamp) as date,
SUM(amount_in_usd) as trading_volume
FROM base.defi.ez_dex_swaps
WHERE date(block_timestamp) >= '2024-04-01'
GROUP BY 1
ORDER BY 1 DESC