mucryptoDaily ETH rewards by Flashbots
Updated 2023-04-27
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
›
⌄
with flash_blocks as (select block_number
from ethereum.core.fact_blocks
where block_timestamp >= '2022-09-01'
and block_number >= '15537940'
and miner in ('0xb64a30399f7f6b0c154c2e7af0a3ec7b0a5b131a', --old address
'0xdafea492d9c6733ae3d56b7ed1adb60692c98bc5' --new address
)),
flash_transactions as (select
block_number,
sum(tx_fee) as block_tx_fees
from ethereum.core.fact_transactions
where block_timestamp >= '2022-09-01'
and block_number >= '15537940'
and block_number in (select block_number from flash_blocks)
group by 1
),
fee_burnt as (select
block_number,
block_header_json:base_fee_per_gas * gas_used / 1e18 as block_fee_burn
from ethereum.core.fact_blocks
where block_timestamp >= '2022-09-01'
and block_number >= '15537940'
and block_number in (select block_number from flash_blocks)
),
net_fees as (select
t.block_number,
block_tx_fees,
block_fee_burn,
block_tx_fees - block_fee_burn as net_fees,
sum(net_fees) over (order by t.block_number asc) as cm_fees
from flash_transactions t
inner join fee_burnt b on t.block_number = b.block_number
)
Run a query to Download Data