MotilolaEIP 1559 base fee burnt
Updated 2024-11-03
999
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
›
⌄
WITH prices AS (
SELECT
hour :: date AS date,
AVG(price) AS eth_usd_price
FROM
ethereum.price.ez_prices_hourly
WHERE
hour :: date >= CURRENT_DATE - INTERVAL '2 months'
AND is_native = 'TRUE'
GROUP BY
date
ORDER BY
date DESC
LIMIT 1
),
gas_burnt_raw AS (
SELECT
block_timestamp :: date AS date,
block_number,
block_header_json,
block_header_json:baseFeePerGas :: int / POW(10, 18) AS base_gas_price,
gas_used,
base_gas_price * gas_used AS base_fee
FROM
ethereum.core.fact_blocks
WHERE
block_timestamp :: date >= CURRENT_DATE - INTERVAL '2 months'
),
agg_gas_burnt AS (
SELECT
date,
SUM(base_fee) AS total_base_fee_burnt_eth
FROM
QueryRunArchived: QueryRun has been archived