mcfemi6TRANSACTION VOLUME ON UNISWAP VS FOR 1 YEAR
    Updated 2022-11-17
    SELECT date_trunc('month', block_timestamp) AS month,
    SUM(ABS(amount_in_usd) + ABS(amount_out_usd))/2 AS Transaction_Volume
    FROM ethereum.core.ez_dex_swaps
    WHERE event_name = 'Swap'
    AND platform = 'uniswap-v3'
    AND block_timestamp >= CURRENT_DATE - INTERVAL '365 Days'
    GROUP BY 1
    ORDER BY 1, 2 DESC
    Run a query to Download Data