connorhUniswap V2 Swap Volume
    Updated 2022-01-07
    SELECT pool_address, SUM(amount_usd)/2 AS volume_usd -- don't double count, swaps amounts going to and from the pool
    FROM ethereum.dex_swaps
    WHERE platform = 'uniswap-v2' AND DATE(block_timestamp) >= CURRENT_DATE - 10
    -- AND pool_address = '0xb4e16d0168e52d35cacd2c6185b44281ec28c9dc'
    GROUP BY 1
    HAVING volume_usd IS NOT NULL
    ORDER BY 2 DESC
    Run a query to Download Data