0xasmrCopy of Untitled Query
    Updated 2022-09-23
    WITH burn_raw AS(
    SELECT
    date_trunc('day', block_timestamp) AS date,
    SUM(gas_used*block_header_json['base_fee_per_gas'])/POW(10, 18) AS daily_burn_fee
    FROM ethereum.core.fact_blocks
    WHERE block_timestamp >= '2021-08-05'
    GROUP BY 1
    )
    SELECT
    MAX(daily_burn_fee) AS highest_daily_burn_fee_daily
    FROM burn_raw
    Run a query to Download Data