cypherLido Whales - stETH vs wstETH
Updated 2022-06-02
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
›
⌄
with top200_ldo_address as (select user_address, balance from flipside_prod_db.ethereum.erc20_balances
where balance_date = current_date()
and contract_address = lower('0x5A98FcBEA516Cf06857215779Fd812CA3beF1B32')
and label is null
order by balance desc
limit 200),
steth_holders as (select * from flipside_prod_db.ethereum.erc20_balances
where balance_date = current_date()
and contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
and user_address in (select user_address from top200_ldo_address)
and balance > 0.001),
wsteth_holders as (select * from flipside_prod_db.ethereum.erc20_balances
where balance_date = current_date()
and contract_address = lower('0x7f39C581F595B53c5cb19bD0b3f8dA6c935E2Ca0')
and user_address in (select user_address from top200_ldo_address)
and balance > 0.001)
select
'stETH holders' as label,
count(*) as n_holder
from steth_holders
union
select
'wstETH holders' as label,
count(*) as n_holder
from wsteth_holders
union select
'non stETH or wstETH holder' as label,
176 as n_holder
from wsteth_holders
Run a query to Download Data