jackguyOptimism DEXs (redux)
    Updated 2022-10-25
    SELECT
    date_trunc('day', block_timestamp) as day,
    COUNT(DISTINCT tx_hash) as events,
    sum(amount_in_usd) as volume,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as users
    FROM optimism.velodrome.ez_swaps
    WHERE block_timestamp > CURRENT_DATE - 30
    GROUP BY 1
    Run a query to Download Data