No Data to Display
yasmingiant-lime
Updated 3 days ago
9999
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
33
34
35
36
›
⌄
-- WITH api_response AS (
-- SELECT livequery.live.udf_api(
-- 'GET',
-- 'https://api.blockberry.one/sui/v1/accounts?page=0&size=20&orderBy=DESC&sortBy=BALANCE',
-- {
-- 'accept': '*/*',
-- 'x-api-key': 'HSNclxULkLyTBO4XiG4xn9M13iZ8Kn' },NULL) AS response)
-- SELECT response
-- FROM api_response;
--request GET \
--url https://api.blockberry.one/sui/v1/total/values/transactions \
--header 'accept: */*' \
--header 'x-api-key: HSNclxULkLyTBO4XiG4xn9M13iZ8Kn'
WITH api_response AS (
SELECT livequery.live.udf_api(
'GET',
'https://api.blockberry.one/sui/v1/widgets/daily-active-accounts?period=DAY&size=LARGE',
{
'accept': '*/*',
'x-api-key': 'HSNclxULkLyTBO4XiG4xn9M13iZ8Kn'
}, NULL
) AS response
),
flattened_data AS (
SELECT
DATEADD(SECOND, (t.value:timestamp::NUMBER) / 1000, '1970-01-01') AS date,
t.value:value::INTEGER AS daily_active_accounts
FROM api_response,
LATERAL FLATTEN(input => PARSE_JSON(response:data:chart)) t
)
SELECT
ROUND(AVG(daily_active_accounts), 2) AS avg_daily_active_accounts_30d
Last run: 3 days ago
0
2B
4s