--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