crypto_gosttop current stakers
Updated 2024-11-17
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
28
29
30
›
⌄
with stakers as (
select
signer_id as user,
sum(amount) as total_staked
from
near.gov.fact_staking_actions
where
action = 'staking' -- Only include staking actions
group by
signer_id
),
unstakers as (
select
signer_id
from
near.gov.fact_staking_actions
where
action in ('unstaking', 'withdrawal') -- Include users who have unstaked or withdrawn
)
select
s.user,
s.total_staked
from
stakers s
where
s.user not in (select signer_id from unstakers) -- Exclude users who have unstaked or withdrawn
order by
s.total_staked desc -- Order by total staked amount in descending order
limit 10; -- Limit the results to the top 5 users
QueryRunArchived: QueryRun has been archived