-- forked from optimism-total-volume @ https://flipsidecrypto.xyz/edit/queries/8971dbc7-a37d-41bf-84a1-91647d285e65
SELECT
date_trunc('day', block_timestamp) as date,
SUM(amount_in_usd) as trading_volume
FROM optimism.defi.ez_dex_swaps
WHERE date(block_timestamp) >= '2024-01-01'
GROUP BY 1
ORDER BY 1 DESC