Arkanstake 3
    Updated 2023-01-09
    WITH
    table1 as (
    SELECT
    tx_signer,
    stake_amount
    FROM
    near.core.dim_staking_actions
    WHERE
    block_timestamp >= '2022-12-01'
    AND action = 'Stake'
    )
    SELECT
    tx_signer as staker,
    SUM(stake_amount/1e24) as Staked_Amount
    FROM
    table1
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 20
    Run a query to Download Data