MLDZMNstk4
Updated 2022-09-05
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
›
⌄
with tb1 as (select
ORIGIN_FROM_ADDRESS as users,
case
when ORIGIN_TO_ADDRESS=lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') then 'LIDO'
when ORIGIN_TO_ADDRESS=lower('0xC874b064f465bdD6411D45734b56fac750Cda29A') then 'Stakewise'
when ORIGIN_TO_ADDRESS=lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670') then 'stkr'
when ORIGIN_TO_ADDRESS=lower('0x49d72e3973900a195a155a46441f0c08179fdb64') then 'Cream'
when ORIGIN_TO_ADDRESS=lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58') then 'Rocket_pool'
when ORIGIN_TO_ADDRESS=lower('0x00000000219ab540356cBB839Cbe05303d7705Fa') then 'Direct staking'
end as platform,
count(distinct tx_hash) as no_stake
from ethereum.core.fact_token_transfers
group by 1,2)
select
platform,
case
when no_stake=1 then 'One time staker'
else 'DCA stakers'
end as staker_type,
count(distinct users) as no_users
from tb1
group by 1,2
Run a query to Download Data