Query editor
WITH json_data AS (SELECT json_parse(http_get('https://api-data.asxn.xyz/api/data/hl-buybacks')) AS parsed_data),buybacks AS (SELECTCAST(json_extract_scalar(item, '$.sz') AS DOUBLE) AS hype_amountFROM json_dataCROSS JOIN UNNEST(CAST(json_extract(parsed_data, '$') AS ARRAY(JSON))) AS t(item))SELECTSUM(hype_amount) AS hype_buybackFROM buybacks;