DDATE | EARNS | BURNS | PRIORITY_FEE_REWARDS | |
|---|---|---|---|---|
1 | 2025-03-17 00:00:00.000 | 931.278732 | 47.994125 | 784.00718094 |
2 | 2025-03-18 00:00:00.000 | 3573.220799 | 56.027649 | 1181.868249417 |
SandeshRON eip1559 burns
Updated 2025-03-18
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 TheLaughingMan / RON eip1559 burns @ https://flipsidecrypto.xyz/TheLaughingMan/q/Wkj9ftfXtuoJ/ron-eip1559-burns
with pf_burns as (
with block_level as (
----block level for testing/accuracy
SELECT
b.block_number
, b.block_timestamp
, sum(b.base_fee_per_gas * b.gas_used) / 1e18 as earned
, SUM(t.tx_fee) as total_txn_fees
, MAX(b.gas_used * b.base_fee_per_gas/1e18) as burn --london fork, formula of burn from alchemy (August 5th, 2021)
-- , SUM(t.gas_used * (t.gas_price-b.BLOCK_HEADER_JSON:"baseFeePerGas")/1e18) as pf_reward -- TOO COMPLICATED SHIT
, GREATEST(total_txn_fees-burn, 0) as pf_reward -- far simpler calc as per etherscan if you already have the burn part// First 0 is block_rewards which are 0 since merge
from ronin.core.fact_transactions t
LEFT JOIN ronin.core.fact_blocks b on b.block_number = t.block_number
WHERE 1=1
AND t.block_number>=43447600
AND t.block_timestamp>= '2025-03-17 07:00'
--AND b.block_number = 20764985
-- reward: 0.03376067686372955 ETH (0 + 0.08309174915568116 - 0.04933107229195161)
GROUP BY 1, 2
)
SELECT
date_trunc('day', block_timestamp) as ddate
, sum(earned) as earns
, SUM(burn) as burns
, SUM(pf_reward) as priority_fee_rewards
from block_level
GROUP BY 1
)
SELECT * from pf_burns
ORDER BY ddate ASC
Last run: 23 days ago
2
128B
2s