def insert_index_data():
m = MongoDB_io()
m.set_db('index_daily_data')
m.set_collection('index_info')
m.delete_document_include_condition()
logging_joinquant()
df = get_all_securities(types='index', date=None)
df.index.name = 'index'
df.reset_index(inplace=True)
df.start_date = pd.to_datetime(df.start_date)
df.end_date = pd.to_datetime(df.end_date)
# 插入数据库
m.insert_huge_dataframe_by_block_to_mongodb(df)
pass
def insert_zz500_data():
m = MongoDB_io()
m.set_db('index_daily_data')
m.set_collection('000905_XSHG')
m.delete_document_include_condition()
logging_joinquant()
df = get_price('000905.XSHG',
start_date='2005-01-01',
end_date='2019-09-25',
fq=None,
frequency='daily')
df.dropna(inplace=True)
## 指数没有复权一说
# df2=get_price('000905.XSHG',fq='pre')
df.index.name = 'date'
df.reset_index(inplace=True)
df.date = pd.to_datetime(df.date)
# 插入数据库
m.insert_huge_dataframe_by_block_to_mongodb(df)
pass
