读取股票数据存储到本地MySQL数据库（二）

通过凤凰api获取到json数据。

#encoding = utf-8
import requests
import json
import pandas as pd

class GetStockPrice(object):

    def get_daily_price(self, stock):
        DAY_PRICE_URL = 'http://api.finance.ifeng.com/akdaily/?code=%s&type=last'
        url = DAY_PRICE_URL % stock
        columns = ['date', 'open', 'high', 'close', 'low', 'volume', 'chg', 'chg_percent', 'ma5', 'ma10', 'ma20', 'vma5',\
                   'vma10','vma20', 'turnover']
        response = requests.get(url)
        response.raise_for_status()
        response.encoding = 'utf-8'
        text = response.text
        js = json.loads(text)
        if js['record']:
            df = pd.DataFrame(js['record'], columns=columns)
        else:
            print('该条记录无数据࿰