cybergenlab[Supply Overview] Ethereum Annualised Inflation
Updated 2024-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from [Supply Overview] Ethereum netflow @ https://flipsidecrypto.xyz/studio/queries/27db64ac-b0ad-42dc-a03e-b80a0483d655
-- forked from [Supply Overview] Historical Circulating Supply @ https://flipsidecrypto.xyz/studio/queries/5f1fc64d-73b2-4e6a-bd53-fee33fbbaa7d
-- forked from [Supply Overview] Circulating Supply @ https://flipsidecrypto.xyz/studio/queries/6ecd7026-4910-4f7a-8ff8-802f425b02cc
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 -- block right after the merge
),
eth_burnt_daily as (
select
block_timestamp::date as date,
sum(total_fees_burnt) as eth_burnt
from eth_burn
group by date
)
, validators as (
select
slot_number,
sum(effective_balance)/32 as nb_validators
from ethereum.beacon_chain.fact_validators
where validator_status='active_ongoing'
group by 1
)
, daily_eth_issue as
QueryRunArchived: QueryRun has been archived