Mrfti2024-07-09 08:48 PM
Updated 2024-10-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
WITH Current_volume AS (
SELECT
ADDRESS AS Validator,
BALANCE
FROM near.gov.fact_staking_pool_daily_balances
WHERE date >= current_date - 1
ORDER BY 2 DESC
),
Total AS (
SELECT
SUM(BALANCE) AS Total_Stake
FROM near.gov.fact_staking_pool_daily_balances
WHERE date >= current_date - 1
),
main_T AS (
SELECT
Validator,
ROUND(BALANCE, 2) AS Balance
FROM Current_volume
LEFT JOIN Total
)
SELECT
Validator AS "Validator Address",
Balance AS "Balance ($NEAR)"
FROM main_T
ORDER BY 2 DESC;
LIMIT 10
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived