Query editor
-- h/t https://dune.com/blockworks_research-- Migrated to Dune SQLWITH supply AS (SELECTtime,SUM(initial_supply + estimated_block_reward) OVER (ORDER BY time) AS estimated_total_supply,SUM(initial_supply + true_block_reward) OVER (ORDER BY time) AS true_total_supplyFROM (SELECTtime,CASEWHEN time = date '2022-09-15' THEN 120521141 -- supply at time of mergeELSE 0END AS initial_supply,1672.5 AS estimated_block_reward, -- estimated, need beacon chain data in dune0 AS true_block_reward -- block rewards cannot be withdrawn until shanghai upgrade, thus 0. !!EXCLUDES UNCLES!!FROM (SELECT timeFROM UNNEST(SEQUENCE(TIMESTAMP '2022-09-15',TIMESTAMP '2030-12-31',INTERVAL '1' DAY)) AS t(time)) gen_series) sub),burn AS (SELECTdate_trunc('day', time) as time,SUM(gas_used * base_fee_per_gas / 1e18) AS eth_burnFROM ethereum.blocksWHERE number >= 12965000GROUP BY 1ORDER BY 1 DESC),current_supply AS (SELECT*,emissions_ma * 365 / estimated_circulating_supply AS inflation_rate,emissions_ma * 365 / estimated_circulating_supply * 100 AS inflation_rate_pFROM (SELECT*,AVG(emissions) OVER (ORDER BY time ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS emissions_maFROM (SELECT*,estimated_circulating_supply - LAG(estimated_circulating_supply, 1) OVER (ORDER BY time) AS emissionsFROM (SELECTtime,estimated_total_supply - eth_burn AS estimated_circulating_supplyFROM (SELECTb.time,estimated_total_supply,true_total_supply,