with eth_burn as

select

block_number,

block_timestamp,

(gas_used) as total_gas,

block_header_json:"baseFeePerGas" AS fees,

(total_gas*fees/1e18) as total_fees_burnt

from ethereum.core.fact_blocks

where block_number>=15537394

),

eth_burnt_daily as

select

block_timestamp::date as date,

sum(total_fees_burnt) as eth_burnt

from eth_burn

group by date

),

issue as

select slot_number, sum(effective_balance) as staked, sqrt(staked) as sqt, 32*64/sqt as issuance from ethereum.beacon_chain.fact_validators

where 1=1

and slot_number>=4700013

and validator_status='active_ongoing'

group by slot_number

order by slot_number desc

),

daily_eth_issue as