import pymongo
import akshare as ak
import json
stockNUm = 0
mongo_client = pymongo.MongoClient('mongodb://localhost:27017/')
mongo_db = mongo_client['SinaData']
mongo_collection = mongo_db['SinaAllStockName']
mydoc = mongo_collection.find()
for x in mydoc:
print(x)
stockNUm = stockNUm + 1
if stockNUm == 3:
break
stock_zh_a_daily_qfq_df = ak.stock_zh_a_daily(symbol=str(x['code']), adjust="qfq")
print(stock_zh_a_daily_qfq_df)
print(type(stock_zh_a_daily_qfq_df))
stock_zh_a_daily_qfq_df['date'] = stock_zh_a_daily_qfq_df['date'].astype(str)
data = json.loads(stock_zh_a_daily_qfq_df.T.to_json()).values()
stock_trade = mongo_db[str(x['code'])]
stock_trade.insert_many(data)