amirrzNumber of staker addresses
Updated 2022-09-17
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
›
⌄
select block_timestamp::date as block_date,
sum(amount) as sum_eth,
sum(amount_usd) as sum_usd,
count(distinct eth_from_address) as n_staker_addresses,
case
when eth_to_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') then 'Lido'
when eth_to_address = lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58') then 'Rocket Pool'
when eth_to_address = lower('0xC874b064f465bdD6411D45734b56fac750Cda29A') then 'StakeWise'
when eth_to_address = lower('0xDFe66B14D37C77F4E9b180cEb433d1b164f0281D') then 'StakeHound'
when eth_to_address = lower('0x84db6ee82b7cf3b47e8f19270abde5718b936670') then 'Ankr'
when eth_to_address = lower('0x18691f528659D0Abd08f79498dCc7B6fBdc1e91d') then 'SharedStake'
when eth_to_address = lower('0xB9599ecb958623614F94BcD9b03f9Ab161Eb05D0') then 'pStake'
end as provider
from
ethereum.core.ez_eth_transfers
where
block_timestamp::date >= current_date - 31
and eth_to_address in (
lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'), -- Lido (stETH)
lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58'), -- Rocket Pool Mainnet Deposit
-- lower('0x178e141a0e3b34152f73ff610437a7bf9b83267a'), -- Rocket Pool (rETH)
lower('0xC874b064f465bdD6411D45734b56fac750Cda29A'), -- StakeWise (Deployer)
-- lower('0xFe2e637202056d30016725477c5da089Ab0A043A'), -- StakeWise (sETH2)
lower('0xDFe66B14D37C77F4E9b180cEb433d1b164f0281D'), -- StakeHound (stakedETH)
lower('0x84db6ee82b7cf3b47e8f19270abde5718b936670'), -- Ankr (Deployer)
-- lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb'), -- Ankr (aETHc)
lower('0x18691f528659D0Abd08f79498dCc7B6fBdc1e91d'), -- SharedStake (Deployer)
-- lower('0x898BAD2774EB97cF6b94605677F43b41871410B1'), -- SharedStake (vETH2)
lower('0xB9599ecb958623614F94BcD9b03f9Ab161Eb05D0') -- pStake (stkETH) issuer contract
) group by block_date, provider
Run a query to Download Data