flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
top 6 most unstaked validator so far
crypto_gost
top 6 most unstaked validator so far
Updated 2024-11-17
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
address
AS
validator_address
,
SUM
(
amount
)
AS
total_staked
FROM
NEAR
.
gov
.
fact_staking_actions
WHERE
action
IN
(
'unstaking'
)
AND
block_timestamp
>=
'2024-01-01'
GROUP
BY
validator_address
ORDER
BY
total_staked
DESC
LIMIT
6
;
Results
QueryRunArchived: QueryRun has been archived