爬虫获取期货数据

from urllib import request
import json
import pandas as pd


def get_data(id):
    url_1d = 'http://stock2.finance.sina.com.cn/futures/api/json.php/IndexService.getInnerFuturesDailyKLine?symbol='
    url = url_1d + id
    req = request.Request(url)
    rsp = request.urlopen(req)
    res = rsp.read()
    res_json = json.loads(res)


    bar_list = []

    #res_json.reverse()
    for line in res_json:
        bar = {}
        bar['datetime'] = line[0]
        bar['open'] = float(line[1])
        bar['high'] = float(line[2])
        bar['low'] = float(line[3])
        bar['close'] = float(line[4])
        bar['volume'] = int(line[5])
        bar_list.append(bar)

    df = pd.DataFrame(data=bar_list)
    print(df)
    df.to_csv('F:/data.csv', index=None)

if __name__ == '__main__':
    get_data('SC0') #这里修改为期货对应的代码就可以