flipside

    Avalanche Block and Transaction Performance - Gas
    rmasAvalanche Block and Transaction Performance - Gas
    Updated 2022-06-27
    SELECT
    date_trunc('hour', block_timestamp) AS hour_
    , count(*) AS transactions
    , avg(gas_price) AS avg_gas_price
    FROM avalanche.core.fact_transactions
    WHERE block_timestamp >= '2022-06-20 00:00:00'
    GROUP BY 1
    ORDER BY 1 DESC

    Run a query to Download Data