Query editor
WITH daily_fees AS (SELECTfrom_unixtime(CAST(json_extract_scalar(item, '$[0]') AS bigint)) AS day,CAST(json_extract_scalar(item, '$[1]') AS double) AS daily_feesFROM (SELECT json_parse(http_get('https://api.llama.fi/summary/fees/hyperliquid?dataType=dailyFees')) AS data)CROSS JOIN UNNEST(CAST(json_extract(data, '$.totalDataChart') AS array(json))) AS t(item)),daily_revenue AS (SELECTfrom_unixtime(CAST(json_extract_scalar(item, '$[0]') AS bigint)) AS day,CAST(json_extract_scalar(item, '$[1]') AS double) AS daily_revenueFROM (SELECT json_parse(http_get('https://api.llama.fi/summary/fees/hyperliquid?dataType=dailyRevenue')) AS data)CROSS JOIN UNNEST(CAST(json_extract(data, '$.totalDataChart') AS array(json))) AS t(item))SELECTCOALESCE(f.day, r.day) AS day,COALESCE(f.daily_fees, 0) AS daily_fees,COALESCE(r.daily_revenue, 0) AS daily_revenueFROM daily_fees fFULL OUTER JOIN daily_revenue r ON f.day = r.dayORDER BY day ASC