CartanGroupSui
Updated 2024-05-09
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
›
⌄
WITH api_call as (
SELECT
livequery.live.udf_api(
'POST',
'https://rpc.mainnet.sui.flipside.services',
{ 'Content-Type': 'application/json' },
{ 'jsonrpc': '2.0',
'id': 1,
'method': 'suix_getValidatorsApy',
'params': [] }
) as rawOutput
),
formatted_results as (
SELECT
value:address::string as address,
value:apy::FLOAT as apy
FROM
api_call,
LATERAL FLATTEN (input => rawoutput:data:result:apys)
)
SELECT
*
FROM
formatted_results
ORDER BY apy DESC
QueryRunArchived: QueryRun has been archived