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