crypto_gosttop current stakers
    Updated 2024-11-17
    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