yasmingiant-lime
    Updated 3 days ago
    -- 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
    No Data to Display
    0
    2B
    4s