connorhUniswap Volumes
    Updated 2021-07-02
    WITH outflows AS (

    SELECT from_address_name AS pool_address, DATE_TRUNC('day',block_timestamp) AS date, symbol, SUM(AMOUNT) AS amount, SUM(AMOUNT_USD) AS amount_usd
    FROM gold.ethereum_events
    WHERE from_address = '0xbb2b8038a1640196fbe3e38816f3e67cba72d940'
    AND block_timestamp >= CURRENT_DATE - INTERVAL '1 week'
    AND symbol IN ('WETH','WBTC')
    AND to_address <> '0x0000000000000000000000000000000000000000'
    GROUP BY 1,2,3

    ), inflows AS (

    SELECT to_address_name AS pool_address, DATE_TRUNC('day',block_timestamp) AS date, symbol, SUM(AMOUNT) AS amount, SUM(AMOUNT_USD) AS amount_usd
    FROM gold.ethereum_events
    WHERE to_address = '0xbb2b8038a1640196fbe3e38816f3e67cba72d940'
    AND block_timestamp >= CURRENT_DATE - INTERVAL '1 week'
    AND symbol IN ('WETH','WBTC')
    AND from_address <> '0x0000000000000000000000000000000000000000'
    GROUP BY 1,2,3

    )

    SELECT inflows.pool_address,
    inflows.date,
    SUM(CASE WHEN inflows.symbol = 'WETH' THEN inflows.amount + outflows.amount ELSE NULL END) AS weth_vol24hr,
    SUM(CASE WHEN inflows.symbol = 'WBTC' THEN inflows.amount + outflows.amount ELSE NULL END) AS wbtc_vol24hr,
    SUM(inflows.amount_usd + outflows.amount_usd) AS usd_vol24hr
    FROM inflows FULL OUTER JOIN outflows
    ON inflows.symbol = outflows.symbol AND inflows.date = outflows.date
    GROUP BY 1,2
    ORDER BY 1,2 DESC
    Run a query to Download Data