0-MIDstake share
    Updated 2025-03-05
    with act1 as (
    with tab1 as (
    SELECT TX_HASH
    from near.core.ez_token_transfers
    where CONTRACT_ADDRESS='linear-protocol.near'
    and MEMO='stake'
    )
    select FROM_ADDRESS
    ,count(distinct TX_HASH) as stakes
    from near.core.ez_token_transfers
    where TX_HASH in (select TX_HASH from tab1)
    and TO_ADDRESS='linear-protocol.near'
    group by 1
    )
    select case
    when stakes=1 then 'One Stake' else 'More Than One Stake' end as s_dis
    ,count(distinct FROM_ADDRESS) as stakers
    from act1
    group by 1
    order by 1
    QueryRunArchived: QueryRun has been archived