cypherLido top stakers
Updated 2022-04-26
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
›
⌄
with add as (select
to_address,
sum(raw_amount/1e18) as steth_received
from ethereum_core.fact_token_transfers
where contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
group by to_address
),
withdraw as (select
from_address,
sum(raw_amount/1e18) as steth_removed
from ethereum_core.fact_token_transfers
where contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
group by from_address
),
net_steth_balance as (select
a.to_address as address,
a.steth_received - w.steth_removed as net_balance
from add a, withdraw w
where a.to_address = w.from_address
)
select
address,
case address
when '0x1982b2f5814301d4e9a8b0201555376e62f82428' then 'Aave interest bearing STETH'
when '0xdc24316b9ae028f1497c275eb9192a3ea0f67022' then 'Lido: Curve Liquidity Farming Pool Contract'
when '0xa2f987a546d4cd1c607ee8141276876c26b72bdf' then 'Anchor Protocol: AnchorVault'
when '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' then 'Lido: wstETH Token'
when '0x0967afe627c732d152e3dfcadd6f9dbfecde18c3' then 'StrategystETHAccumulator'
else null end as label,
net_balance
from net_steth_balance
order by net_balance desc
limit 10
Run a query to Download Data