amdonatusprinceMev Fees
Updated 2022-11-03
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 block_number
),
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,
Run a query to Download Data