YellowCumulative & Average gas of UNI & SUSHI
    Updated 2022-04-05
    WITH uniswap AS (
    SELECT SUM(gas_price) AS sum, AVG(gas_price) AS avg FROM ethereum.transactions
    WHERE
    DATEDIFF(DAY, block_timestamp, CURRENT_TIMESTAMP) <= 60
    AND (
    LOWER(to_address) = LOWER('0xE592427A0AEce92De3Edee1F18E0157C05861564')
    OR LOWER(to_address) = LOWER('0x7a250d5630B4cF539739dF2C5dAcb4c659F2488D')
    OR LOWER(to_address) = LOWER('0x68b3465833fb72A70ecDF485E0e4C7bD8665Fc45')
    )
    ),
    sushiswap AS (
    SELECT SUM(gas_price) AS sum, AVG(gas_price) AS avg FROM ethereum.transactions
    WHERE DATEDIFF(DAY, block_timestamp, CURRENT_TIMESTAMP) <= 60 AND
    LOWER(to_address) = LOWER('0xd9e1cE17f2641f24aE83637ab66a2cca9C378B9F')
    )

    SELECT uniswap.sum AS "uniswap cumulative gas", sushiswap.sum AS "sushiswap cumulative gas",
    uniswap.avg AS "uniswap average gas", sushiswap.avg AS "sushiswap average gas"
    FROM uniswap, sushiswap;
    Run a query to Download Data