[056量化交易]python获取新浪财经行情数据写入mongodb

import pymongo
import akshare as ak
import json
#打开数据库
mongo_client = pymongo.MongoClient('mongodb://localhost:27017/')
# 若没有Database 和Collection，则会自动创建
mongo_db = mongo_client['SinaData']
mongo_collection = mongo_db['sz000001']

# 在量化投资研究中普遍采用后复权数据  新浪财经
stock_zh_a_daily_qfq_df = ak.stock_zh_a_daily(symbol="sz000001", adjust="qfq") #历史行情数据(前复权)
print(stock_zh_a_daily_qfq_df)
print(type(stock_zh_a_daily_qfq_df)) # DataFrame

# DataFrame 日期列转换为字符串
stock_zh_a_daily_qfq_df['date'] = stock_zh_a_daily_qfq_df['date'].astype(str)
#将 DataFrame 写入MongoDB
data = json.loads(stock_zh_a_daily_qfq_df.T.to_json()).values()
mongo_collection.insert_many(data)