DATE | DAILY_ETH_BURNED | CUMULATIVE_ETH_BURNED | |
|---|---|---|---|
1 | 2021-08-05 00:00:00.000 | 3053.770586857 | 3053.770586857 |
2 | 2021-08-06 00:00:00.000 | 4106.955954246 | 7160.726541104 |
3 | 2021-08-07 00:00:00.000 | 4218.147366921 | 11378.873908024 |
4 | 2021-08-08 00:00:00.000 | 4191.26648676 | 15570.140394784 |
5 | 2021-08-09 00:00:00.000 | 4247.410703615 | 19817.551098399 |
6 | 2021-08-10 00:00:00.000 | 5313.68392613 | 25131.235024529 |
7 | 2021-08-11 00:00:00.000 | 5226.856007563 | 30358.091032092 |
8 | 2021-08-12 00:00:00.000 | 4953.001402223 | 35311.092434316 |
9 | 2021-08-13 00:00:00.000 | 4750.44292601 | 40061.535360325 |
10 | 2021-08-14 00:00:00.000 | 4220.700392279 | 44282.235752604 |
11 | 2021-08-15 00:00:00.000 | 5277.156905755 | 49559.392658359 |
12 | 2021-08-16 00:00:00.000 | 4769.676971739 | 54329.069630099 |
13 | 2021-08-17 00:00:00.000 | 4334.178477634 | 58663.248107733 |
14 | 2021-08-18 00:00:00.000 | 3869.736285817 | 62532.98439355 |
15 | 2021-08-19 00:00:00.000 | 3561.436954662 | 66094.421348212 |
16 | 2021-08-20 00:00:00.000 | 3483.168712782 | 69577.590060994 |
17 | 2021-08-21 00:00:00.000 | 3063.237506783 | 72640.827567776 |
18 | 2021-08-22 00:00:00.000 | 3097.329178783 | 75738.156746559 |
19 | 2021-08-23 00:00:00.000 | 5387.566425945 | 81125.723172504 |
20 | 2021-08-24 00:00:00.000 | 7191.723264099 | 88317.446436603 |
blocmates researchCumulative amount of Ethereum burned under EIP-1559
Updated 3 days ago
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
›
⌄
WITH block_data AS (
SELECT
BLOCK_NUMBER,
BLOCK_TIMESTAMP,
GAS_USED,
(block_header_json:baseFeePerGas :: int) / POW(10, 18) AS base_gas_price,
base_gas_price * GAS_USED as eth_burned_per_block
FROM
ethereum.core.fact_blocks
WHERE
BLOCK_NUMBER >= 12965000 -- EIP-1559 implementation block
),
daily_ETH_burn AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
SUM(eth_burned_per_block) AS daily_eth_burned
FROM
block_data
GROUP BY
date
)
SELECT
date,
daily_eth_burned,
SUM(daily_eth_burned) OVER (
ORDER BY
date
) AS cumulative_eth_burned
FROM
daily_ETH_burn
ORDER BY
date
Last run: 3 days ago
...
1316
77KB
4s