[019量化交易] python读取股票信息并写入数据库

import numpy as np
import pandas as pd
import tushare as ts
import pandas_datareader.data as web
import matplotlib.pyplot as plt
# import mpl_finance as mpf
import datetime
import time
# import talib
import sqlite3
from sqlalchemy import create_engine
from pandas.io import sql

# 初始化pro接口
pro = ts.pro_api('')

# # 拉取数据
# df = pro.daily(**{
#     "ts_code": "000651.SZ",
#     "start_date": 20190101,
#     "end_date": 20190201,
# }, fields=[
#     "ts_code",
#     "trade_date",
#     "open",
#     "high",
#     "low",
#     "close",
#     "pre_close",
#     "change",
#     "pct_chg",
#     "vol",
#     "amount"
# ])
# print(df)
# print('股票信息已经打印完成.')

print('open data base.')
conn = sqlite3.connect('stock-data.db')
c = conn.cursor()

# print("write data to sql.")
# df.to_sql(name='STOCK000651', con=conn, index=False, if_exists='replace')

print("read sqlite data to show.")
sql_gldq = pd.read_sql_query("select * from 'STOCK000651';", conn)
print(sql_gldq)