reactjs - 如何重新组织此 JSON 以在 Google React Charts 烛台格式中工作？

Question

另一个菜鸟问题！因此，我使用 AlphaVantage API 来获取每日比特币 OHLC 数据，JSON 如下所示：

"2021-05-23": {
        "1a. open (CNY)": "241019.29089300",
        "1b. open (USD)": "37458.51000000",
        "2a. high (CNY)": "245051.66670300",
        "2b. high (USD)": "38085.21000000",
        "3a. low (CNY)": "235939.28235700",
        "3b. low (USD)": "36668.99000000",
        "4a. close (CNY)": "244032.53792600",
        "4b. close (USD)": "37926.82000000",
        "5. volume": "5431.07431100",
        "6. market cap (USD)": "5431.07431100"
    },
    "2021-05-22": {
        "1a. open (CNY)": "239763.57290500",
        "1b. open (USD)": "37263.35000000",
        "2a. high (CNY)": "249837.43470000",
        "2b. high (USD)": "38829.00000000",
        "3a. low (CNY)": "226491.34926600",
        "3b. low (USD)": "35200.62000000",
        "4a. close (CNY)": "240962.79773900",
        "4b. close (USD)": "37449.73000000",
        "5. volume": "126542.24368900",
        "6. market cap (USD)": "126542.24368900"

Google React Charts 采用如下数据：

<Chart
  width={'100%'}
  height={350}
  chartType="CandlestickChart"
  loader={<div>Loading Chart</div>}
  data={[
    ['day', 'a', 'b', 'c', 'd'],
    ['Mon', 20, 28, 38, 45],
    ['Tue', 31, 38, 55, 66],
    ['Wed', 50, 55, 77, 80],
    ['Thu', 77, 77, 66, 50],
    ['Fri', 68, 66, 22, 15],
  ]}
  options={{
    legend: 'none',
  }}
  rootProps={{ 

'data-testid': '1' }}
/>

我环顾四周，但还没有真正找到将 json 文件转换为适用于 Google Charts 的格式的方法。

任何线索将不胜感激，这是我的第一个作品集之一。

标签： reactjs