flipside

    Show transaction gas price over time.
    SocioCryptoShow transaction gas price over time.
    Updated 2022-06-26
    -- Show transaction gas price over time.

    SELECT date_trunc('hour', block_timestamp) as hours,
    avg(gas_price) as avg_gas_price
    FROM avalanche.core.fact_transactions
    WHERE block_timestamp::date >= '2022-06-20'
    GROUP by hours
    Run a query to Download Data