Eman-Raz2- Total Number of Unique ETH Stakers
Updated 2023-05-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with tab1 as (select eth_from_address as staker, case
when eth_to_address='0xc874b064f465bdd6411d45734b56fac750cda29a' then 'Stakewise'
when eth_to_address='0x84db6ee82b7cf3b47e8f19270abde5718b936670' then 'Ankr'
when eth_to_address='0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' then 'Rocket pool'
when eth_to_address='0xae7ab96520de3a18e5e111b5eaab095312d7fe84' then 'Lido'
when eth_to_address='0x39dc6a99209b5e6b81dc8540c86ff10981ebda29' then 'Staked.us'
when eth_to_address='0x0194512e77d798e4871973d9cb9d7ddfc0ffd801' then 'stake.fish'
end as platform
from ethereum.core.ez_eth_transfers
where eth_to_address='0xc874b064f465bdd6411d45734b56fac750cda29a' -- Stakewise
or eth_to_address='0x84db6ee82b7cf3b47e8f19270abde5718b936670' -- Ankr
-- or eth_to_address='0x00000000219ab540356cbb839cbe05303d7705fa' -- Direct staking
or eth_to_address='0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' -- Rocket pool
or eth_to_address='0xae7ab96520de3a18e5e111b5eaab095312d7fe84' -- Lido
or eth_to_address='0x39dc6a99209b5e6b81dc8540c86ff10981ebda29' --staked.us
or eth_to_address='0x0194512e77d798e4871973d9cb9d7ddfc0ffd801' --stakefish
order by 1)
select platform, count(distinct staker) as "Stakers Count"
from tab1
group by 1
Run a query to Download Data