MLDZMNstk4
    Updated 2022-09-05
    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