dayvidjoshHighest Daily Burn Eth
    Updated 2024-01-22
    With Burn as(select
    Sum(gas_used * (block_header_json: BaseFeePerGas) /1e18) as BurnEth,
    date_trunc('day', BLOCK_TIMESTAMP) as DATE2
    From ethereum.core.fact_blocks
    Where Block_NUMBER>12965000
    group by DATE2
    Order By DATE2 DESC)

    Select MAX(BurnEth) as "Highest Daily Burn"
    From Burn


    QueryRunArchived: QueryRun has been archived