Crazy_KidSwap Sizes of Top 10 Liquidity Pools 2
    Updated 2022-02-09
    WITH one AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as ILV_WETH_SLP_avg_swap_amount
    FROM ethereum.dex_swaps
    WHERE pool_name ='ILV-WETH SLP' and date >= '2022-01-01'
    GROUP BY date
    ORDER BY date DESC),

    two AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as USDC_WETH_SLP_avg_swap_amount
    FROM ethereum.dex_swaps
    WHERE pool_name ='USDC-WETH SLP' and date >= '2022-01-01'
    GROUP BY date
    ORDER BY date DESC),

    three AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as BIT_WETH_SLP_avg_swap_amount
    FROM ethereum.dex_swaps
    WHERE pool_name ='BIT-WETH SLP' and date >= '2022-01-01'
    GROUP BY date
    ORDER BY date DESC),

    four AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as TOKE_WETH_SLP_avg_swap_amount
    FROM ethereum.dex_swaps
    WHERE pool_name ='TOKE-WETH SLP' and date >= '2022-01-01'
    GROUP BY date
    ORDER BY date DESC),

    five AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as WBTC_WETH_SLP_avg_swap_amount
    FROM ethereum.dex_swaps
    WHERE pool_name ='WBTC-WETH SLP' and date >= '2022-01-01'
    GROUP BY date
    ORDER BY date DESC),

    six AS (SELECT DATE(block_timestamp) as date, avg(amount_usd) as OHM_DAI_LP_avg_swap_amount
    FROM ethereum.dex_swaps
    WHERE pool_name ='OHM-DAI LP' and date >= '2022-01-01'
    GROUP BY date
    ORDER BY date DESC),

    Run a query to Download Data