原物料市場

在原物料市場，我們擁有 2 種資料集，如下:

• 黃金價格表 GoldPrice

• 原油資料表 CrudeOilPrices

另外針對資料集整理出原油清單，目前共有 2 種

data_id	Brent	WTI
原油	布蘭特	西德州

黃金價格表 GoldPrice

Example

import requests
import pandas as pd

url = 'https://api.finmindtrade.com/api/v4/data'
parameter = {
     "dataset": "GoldPrice",
     "start_date": "2020-01-01",
     "end_date": "2020-01-02",
}
data = requests.get(url, params=parameter)
data = data.json()
data = pd.DataFrame(data['data'])
print(data.head())

Price                 date
0  1517.2  2020-01-01 00:00:01
1  1517.2  2020-01-01 00:03:01
2  1517.2  2020-01-01 00:08:02
3  1517.2  2020-01-01 00:13:02
4  1517.2  2020-01-01 00:18:01

Output

Schema

{
    Price: float32,
    date: str
}

原油資料表 CrudeOilPrices

Example

import requests
import pandas as pd

url = 'https://api.finmindtrade.com/api/v4/data'
parameter = {
     "dataset": "CrudeOilPrices",
     "data_id": "WTI",
     "start_date": "2020-01-01",
     "end_date": "2020-01-08",
}
data = requests.get(url, params=parameter)
data = data.json()
data = pd.DataFrame(data['data'])
print(data.head())

     date name  price
0  2020-01-02  WTI  61.17
1  2020-01-03  WTI     63
2  2020-01-06  WTI  63.27
3  2020-01-07  WTI   62.7
4  2020-01-08  WTI  59.65

Output

Schema

{
    date: str,
    name: str,
    price: float64
}