0-MIDdis stake
Updated 2025-03-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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