adambalaDaily Gas Fees on Uniswap and SushiSwap
    Updated 2022-05-28
    WITH sushi AS (SELECT DATE(block_timestamp) as date, avg(tx_fee) as avg_gas_fee_in_eth_sushi
    FROM ethereum.transactions
    WHERE to_label ='sushiswap' AND DATE(block_timestamp) BETWEEN '2021-12-01' AND '2022-01-31'
    GROUP BY date
    ORDER BY date),

    uni AS (SELECT DATE(block_timestamp) as date, avg(tx_fee) as avg_gas_fee_in_eth_uni
    FROM ethereum.transactions
    WHERE to_label ='uniswap' AND DATE(block_timestamp) BETWEEN '2021-12-01' AND '2022-01-31'
    GROUP BY date
    ORDER BY date)

    SELECT sushi.date as date, avg_gas_fee_in_eth_sushi, avg_gas_fee_in_eth_uni
    FROM sushi JOIN uni ON sushi.date = uni.date
    ORDER BY date
    Run a query to Download Data