Elprognerdtop 10 stakers
    Updated 2023-02-06
    SELECT
    tx_signer,
    --count(distinct POOL_ADDRESS) as "Total Number of Pools",
    sum(stake_amount/pow(10, 24)) as "Total Volume"
    FROM near.core.dim_staking_actions
    WHERE action in ('Stake') and block_timestamp >= CURRENT_DATE - INTERVAL '14 days'
    group by 1
    order by 2 DESC
    LIMIT 10

    Run a query to Download Data