No Data to Display
CartanGroupdatacloud/Current Validators
Updated 2024-01-04
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
29
30
31
32
›
⌄
SELECT
value:name::string AS name,
value:stake_balance::int AS stake_balance
FROM
(
SELECT
chainbase_utils.post(
'/v1/dw/query',
{
'query':
'WITH latest AS (
SELECT max(epoch) AS latest
FROM sui.validators
)
SELECT
name,
staking_pool_sui_balance / 1000000000 AS stake_balance,
image_url
FROM
sui.validators,
latest
WHERE
sui.validators.epoch = latest.latest
ORDER BY
stake_balance DESC'
}
) :: variant AS resp
) AS subquery,
LATERAL FLATTEN(input => resp:data:data:result)
Last run: about 2 months ago
0
2B
2s