Kruys-CollinsTotal Gas Used by Uniswap Txn (Last 6 months) copy
    Updated 2024-06-11
    -- forked from Total Gas Used by Uniswap Txn (Last 6 months) @ https://flipsidecrypto.xyz/edit/queries/ba042bf0-3d8b-45b6-9723-16722f6b1337

    SELECT
    --Date_trunc(day, block_timestamp) AS Week
    EXTRACT(HOUR FROM BLOCK_TIMESTAMP) AS Hour_Of_Day
    ,SUM(gas_price)/1e9 as "Gas Price"
    FROM
    ethereum.core.fact_transactions
    WHERE
    TX_HASH IN ( SELECT
    DISTINCT TX_HASH
    FROM
    ethereum.defi.ez_dex_swaps
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '6 MONTHS'
    AND PLATFORM LIKE '%uniswap%'
    )
    GROUP BY
    1


    QueryRunArchived: QueryRun has been archived