Arkanstake 3
Updated 2023-01-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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