python+pyecharts绘制股票k线图与日均收益率图

k线图的绘制

数据库的连接不再赘述，需要的数据为：
1.开盘价格
2.最高价格
3.最低价格
4.收盘价格

源代码：

from pyecharts import options as opts
from pyecharts.charts import Kline
import sqlutil as ql
import datetime

ql.conn.connect()
ql.cursor = ql.conn.cursor(cursor=ql.pymysql.cursors.DictCursor)
sql = 'select date, start_price, max_price, min_price, stop_price from abc001_defect;'
ql.cursor.execute(sql)
ret = ql.cursor.fetchall()
print(ret)

x_data = []
y_data = []

for i in ret:
    str_date = datetime.datetime.strftime(i['date'], '%Y-%m-%d')
    x_data.append(str_date)
    y_data.append([i['start_price'], i['max_price'], i['min_price'], i['stop_price']])

c = (
    Kline(init_opts=opts.InitOpts(width="1440px", height