0-MIDdis stake
    Updated 2025-03-02
    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 stakes
    ,count(distinct FROM_ADDRESS) as stakers
    from act1
    group by 1
    order by 1
    QueryRunArchived: QueryRun has been archived