zero-ndoLtSnew miners
Updated 2022-09-17Copy Reference Fork
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
›
⌄
with before_merge as
(
select
miner,
count(distinct block_number) as blocks_mined
from ethereum.core.fact_blocks
where block_number < 15537352
group by 1
),
after_merge as
(
select
miner,
count(distinct block_number) as blocks_mined
from ethereum.core.fact_blocks
where block_timestamp > CURRENT_DATE - interval ' 2 weeks'
and block_number >= 15537352
group by 1
)
select am.* from after_merge am where miner not in
(
select distinct miner from before_merge
)
order by 2 desc limit 10
Run a query to Download Data