zvtvz / zvt

modular quant framework.
https://zvt.readthedocs.io/en/latest/
MIT License
3.23k stars 860 forks source link

更新数据出错 #66

Closed ohyeah521 closed 4 years ago

ohyeah521 commented 4 years ago

从百度网盘下载数据库,然后替换data文件夹中默认的,执行下面命令,

import os from zvt.api import from zvt.domain import FinanceFactor.recorders Traceback (most recent call last): File "", line 1, in AttributeError: type object 'FinanceFactor' has no attribute 'recorders'

Stock.record_data(provider='eastmoney') Stock registered recorders:{'joinquant': <class 'zvt.recorders.joinquant.meta.china_stock_meta_recorder.JqChinaStockRecorder'>, 'exchange': <class 'zvt.recorders.exchange.china_stock_list_spider.ExchangeChinaStockListRecorder'>, 'eastmoney': <class 'zvt.recorders.eastmoney.meta.china_stock_meta_recorder.EastmoneyChinaStockListRecorder'>} Empty DataFrame Columns: [code, name, list_date] Index: [] Traceback (most recent call last): File "D:\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 1193, in _execute_context context) File "D:\Anaconda3\lib\site-packages\sqlalchemy\engine\default.py", line 509, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: too many SQL variables

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "", line 1, in File "D:\Anaconda3\lib\site-packages\zvdata__init__.py", line 260, in record_data r.run() File "E:\AITrader\SourceCode\zvt\zvt\recorders\exchange\china_stock_list_spider.py", line 23, in run self.download_stock_list(response=resp, exchange='sh') File "E:\AITrader\SourceCode\zvt\zvt\recorders\exchange\china_stock_list_spider.py", line 64, in download_stock_list df_to_db(df=df, data_schema=self.data_schema, provider=self.provider, force_update=False) File "D:\Anaconda3\lib\site-packages\zvdata\api.py", line 246, in df_to_db ids=df_current['id'].tolist()) File "D:\Anaconda3\lib\site-packages\zvdata\api.py", line 128, in get_data df = pd.read_sql(query.statement, query.session.bind) File "D:\Anaconda3\lib\site-packages\pandas\io\sql.py", line 397, in read_sql chunksize=chunksize) File "D:\Anaconda3\lib\site-packages\pandas\io\sql.py", line 1099, in read_query result = self.execute(args) File "D:\Anaconda3\lib\site-packages\pandas\io\sql.py", line 990, in execute return self.connectable.execute(args, *kwargs) File "D:\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 2075, in execute return connection.execute(statement, multiparams, **params) File "D:\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 948, in execute return meth(self, multiparams, params) File "D:\Anaconda3\lib\site-packages\sqlalchemy\sql\elements.py", line 269, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "D:\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 1060, in _execute_clauseelement compiled_sql, distilled_params File "D:\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 1200, in _execute_context context) File "D:\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 1413, in _handle_dbapi_exception exc_info File "D:\Anaconda3\lib\site-packages\sqlalchemy\util\compat.py", line 265, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "D:\Anaconda3\lib\site-packages\sqlalchemy\util\compat.py", line 248, in reraise raise value.with_traceback(tb) File "D:\Anaconda3\lib\site-packages\sqlalchemy\engine\base.py", line 1193, in _execute_context context) File "D:\Anaconda3\lib\site-packages\sqlalchemy\engine\default.py", line 509, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) too many SQL variables [SQL: 'SELECT stock.id, stock.timestamp \nFROM stock \nWHERE stock.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY stock.timestamp ASC'] [parameters: ('stock_sh_600000', 'stock_sh_600004', 'stock_sh_600006', 'stock_sh_600007', 'stock_sh_600008', 'stock_sh_600009', 'stock_sh_600010', 'stock_sh_600011', 'stock_sh_600012', 'stock_sh_600015', 'stock_sh_600016', 'stock_sh_600017', 'stock_sh_600018', 'stock_sh_600019', 'stock_sh_600020', 'stock_sh_600021', 'stock_sh_600022', 'stock_sh_600023', 'stock_sh_600025', 'stock_sh_600026', 'stock_sh_600027', 'stock_sh_600028', 'stock_sh_600029', 'stock_sh_600030', 'stock_sh_600031', 'stock_sh_600033', 'stock_sh_600035', 'stock_sh_600036', 'stock_sh_600037', 'stock_sh_600038', 'stock_sh_600039', 'stock_sh_600048', 'stock_sh_600050', 'stock_sh_600051', 'stock_sh_600052', 'stock_sh_600053', 'stock_sh_600054', 'stock_sh_600055', 'stock_sh_600056', 'stock_sh_600057', 'stock_sh_600058', 'stock_sh_600059', 'stock_sh_600060', 'stock_sh_600061', 'stock_sh_600062', 'stock_sh_600063', 'stock_sh_600064', 'stock_sh_600066', 'stock_sh_600067', 'stock_sh_600068', 'stock_sh_600069', 'stock_sh_600070', 'stock_sh_600071', 'stock_sh_600072', 'stock_sh_600073', 'stock_sh_600074', 'stock_sh_600075', 'stock_sh_600076', 'stock_sh_600077', 'stock_sh_600078', 'stock_sh_600079', 'stock_sh_600080', 'stock_sh_600081', 'stock_sh_600082', 'stock_sh_600083', 'stock_sh_600084', 'stock_sh_600085', 'stock_sh_600086', 'stock_sh_600088', 'stock_sh_600089', 'stock_sh_600090', 'stock_sh_600091', 'stock_sh_600093', 'stock_sh_600094', 'stock_sh_600095', 'stock_sh_600096', 'stock_sh_600097', 'stock_sh_600098', 'stock_sh_600099', 'stock_sh_600100', 'stock_sh_600101', 'stock_sh_600103', 'stock_sh_600104', 'stock_sh_600105', 'stock_sh_600106', 'stock_sh_600107', 'stock_sh_600108', 'stock_sh_600109', 'stock_sh_600110', 'stock_sh_600111', 'stock_sh_600112', 'stock_sh_600113', 'stock_sh_600114', 'stock_sh_600115', 'stock_sh_600116', 'stock_sh_600117', 'stock_sh_600118', 'stock_sh_600119', 'stock_sh_600120', 'stock_sh_600121', 'stock_sh_600122', 'stock_sh_600123', 'stock_sh_600125', 'stock_sh_600126', 'stock_sh_600127', 'stock_sh_600128', 'stock_sh_600129', 'stock_sh_600130', 'stock_sh_600131', 'stock_sh_600132', 'stock_sh_600133', 'stock_sh_600135', 'stock_sh_600136', 'stock_sh_600137', 'stock_sh_600138', 'stock_sh_600139', 'stock_sh_600141', 'stock_sh_600143', 'stock_sh_600145', 'stock_sh_600146', 'stock_sh_600148', 'stock_sh_600149', 'stock_sh_600150', 'stock_sh_600151', 'stock_sh_600152', 'stock_sh_600153', 'stock_sh_600155', 'stock_sh_600156', 'stock_sh_600157', 'stock_sh_600158', 'stock_sh_600159', 'stock_sh_600160', 'stock_sh_600161', 'stock_sh_600162', 'stock_sh_600163', 'stock_sh_600165', 'stock_sh_600166', 'stock_sh_600167', 'stock_sh_600168', 'stock_sh_600169', 'stock_sh_600170', 'stock_sh_600171', 'stock_sh_600172', 'stock_sh_600173', 'stock_sh_600175', 'stock_sh_600176', 'stock_sh_600177', 'stock_sh_600178', 'stock_sh_600179', 'stock_sh_600180', 'stock_sh_600182', 'stock_sh_600183', 'stock_sh_600184', 'stock_sh_600185', 'stock_sh_600186', 'stock_sh_600187', 'stock_sh_600188', 'stock_sh_600189', 'stock_sh_600190', 'stock_sh_600191', 'stock_sh_600192', 'stock_sh_600193', 'stock_sh_600195', 'stock_sh_600196', 'stock_sh_600197', 'stock_sh_600198', 'stock_sh_600199', 'stock_sh_600200', 'stock_sh_600201', 'stock_sh_600202', 'stock_sh_600203', 'stock_sh_600206', 'stock_sh_600207', 'stock_sh_600208', 'stock_sh_600209', 'stock_sh_600210', 'stock_sh_600211', 'stock_sh_600212', 'stock_sh_600213', 'stock_sh_600215', 'stock_sh_600216', 'stock_sh_600217', 'stock_sh_600218', 'stock_sh_600219', 'stock_sh_600220', 'stock_sh_600221', 'stock_sh_600222', 'stock_sh_600223', 'stock_sh_600225', 'stock_sh_600226', 'stock_sh_600227', 'stock_sh_600228', 'stock_sh_600229', 'stock_sh_600230', 'stock_sh_600231', 'stock_sh_600232', 'stock_sh_600233', 'stock_sh_600234', 'stock_sh_600235', 'stock_sh_600236', 'stock_sh_600237', 'stock_sh_600238', 'stock_sh_600239', 'stock_sh_600241', 'stock_sh_600242', 'stock_sh_600243', 'stock_sh_600246', 'stock_sh_600247', 'stock_sh_600248', 'stock_sh_600249', 'stock_sh_600250', 'stock_sh_600251', 'stock_sh_600252', 'stock_sh_600255', 'stock_sh_600256', 'stock_sh_600257', 'stock_sh_600258', 'stock_sh_600259', 'stock_sh_600260', 'stock_sh_600261', 'stock_sh_600262', 'stock_sh_600265', 'stock_sh_600266', 'stock_sh_600267', 'stock_sh_600268', 'stock_sh_600269', 'stock_sh_600271', 'stock_sh_600272', 'stock_sh_600273', 'stock_sh_600275', 'stock_sh_600276', 'stock_sh_600277', 'stock_sh_600278', 'stock_sh_600279', 'stock_sh_600280', 'stock_sh_600281', 'stock_sh_600282', 'stock_sh_600283', 'stock_sh_600284', 'stock_sh_600285', 'stock_sh_600287', 'stock_sh_600288', 'stock_sh_600289', 'stock_sh_600290', 'stock_sh_600291', 'stock_sh_600292', 'stock_sh_600293', 'stock_sh_600295', 'stock_sh_600297', 'stock_sh_600298', 'stock_sh_600299', 'stock_sh_600300', 'stock_sh_600301', 'stock_sh_600302', 'stock_sh_600303', 'stock_sh_600305', 'stock_sh_600306', 'stock_sh_600307', 'stock_sh_600308', 'stock_sh_600309', 'stock_sh_600310', 'stock_sh_600311', 'stock_sh_600312', 'stock_sh_600313', 'stock_sh_600315', 'stock_sh_600316', 'stock_sh_600317', 'stock_sh_600318', 'stock_sh_600319', 'stock_sh_600320', 'stock_sh_600321', 'stock_sh_600322', 'stock_sh_600323', 'stock_sh_600325', 'stock_sh_600326', 'stock_sh_600327', 'stock_sh_600328', 'stock_sh_600329', 'stock_sh_600330', 'stock_sh_600331', 'stock_sh_600332', 'stock_sh_600333', 'stock_sh_600335', 'stock_sh_600336', 'stock_sh_600337', 'stock_sh_600338', 'stock_sh_600339', 'stock_sh_600340', 'stock_sh_600343', 'stock_sh_600345', 'stock_sh_600346', 'stock_sh_600348', 'stock_sh_600350', 'stock_sh_600351', 'stock_sh_600352', 'stock_sh_600353', 'stock_sh_600354', 'stock_sh_600355', 'stock_sh_600356', 'stock_sh_600358', 'stock_sh_600359', 'stock_sh_600360', 'stock_sh_600361', 'stock_sh_600362', 'stock_sh_600363', 'stock_sh_600365', 'stock_sh_600366', 'stock_sh_600367', 'stock_sh_600368', 'stock_sh_600369', 'stock_sh_600370', 'stock_sh_600371', 'stock_sh_600372', 'stock_sh_600373', 'stock_sh_600375', 'stock_sh_600376', 'stock_sh_600377', 'stock_sh_600378', 'stock_sh_600379', 'stock_sh_600380', 'stock_sh_600381', 'stock_sh_600382', 'stock_sh_600383', 'stock_sh_600385', 'stock_sh_600386', 'stock_sh_600387', 'stock_sh_600388', 'stock_sh_600389', 'stock_sh_600390', 'stock_sh_600391', 'stock_sh_600392', 'stock_sh_600393', 'stock_sh_600395', 'stock_sh_600396', 'stock_sh_600397', 'stock_sh_600398', 'stock_sh_600399', 'stock_sh_600400', 'stock_sh_600403', 'stock_sh_600405', 'stock_sh_600406', 'stock_sh_600408', 'stock_sh_600409', 'stock_sh_600410', 'stock_sh_600415', 'stock_sh_600416', 'stock_sh_600418', 'stock_sh_600419', 'stock_sh_600420', 'stock_sh_600421', 'stock_sh_600422', 'stock_sh_600423', 'stock_sh_600425', 'stock_sh_600426', 'stock_sh_600428', 'stock_sh_600429', 'stock_sh_600433', 'stock_sh_600435', 'stock_sh_600436', 'stock_sh_600438', 'stock_sh_600439', 'stock_sh_600444', 'stock_sh_600446', 'stock_sh_600448', 'stock_sh_600449', 'stock_sh_600452', 'stock_sh_600455', 'stock_sh_600456', 'stock_sh_600458', 'stock_sh_600459', 'stock_sh_600460', 'stock_sh_600461', 'stock_sh_600462', 'stock_sh_600463', 'stock_sh_600466', 'stock_sh_600467', 'stock_sh_600468', 'stock_sh_600469', 'stock_sh_600470', 'stock_sh_600475', 'stock_sh_600476', 'stock_sh_600477', 'stock_sh_600478', 'stock_sh_600479', 'stock_sh_600480', 'stock_sh_600481', 'stock_sh_600482', 'stock_sh_600483', 'stock_sh_600485', 'stock_sh_600486', 'stock_sh_600487', 'stock_sh_600488', 'stock_sh_600489', 'stock_sh_600490', 'stock_sh_600491', 'stock_sh_600493', 'stock_sh_600495', 'stock_sh_600496', 'stock_sh_600497', 'stock_sh_600498', 'stock_sh_600499', 'stock_sh_600500', 'stock_sh_600501', 'stock_sh_600502', 'stock_sh_600503', 'stock_sh_600505', 'stock_sh_600506', 'stock_sh_600507', 'stock_sh_600508', 'stock_sh_600509', 'stock_sh_600510', 'stock_sh_600511', 'stock_sh_600512', 'stock_sh_600513', 'stock_sh_600515', 'stock_sh_600516', 'stock_sh_600517', 'stock_sh_600518', 'stock_sh_600519', 'stock_sh_600520', 'stock_sh_600521', 'stock_sh_600522', 'stock_sh_600523', 'stock_sh_600525', 'stock_sh_600526', 'stock_sh_600527', 'stock_sh_600528', 'stock_sh_600529', 'stock_sh_600530', 'stock_sh_600531', 'stock_sh_600532', 'stock_sh_600533', 'stock_sh_600535', 'stock_sh_600536', 'stock_sh_600537', 'stock_sh_600538', 'stock_sh_600539', 'stock_sh_600540', 'stock_sh_600543', 'stock_sh_600545', 'stock_sh_600546', 'stock_sh_600547', 'stock_sh_600548', 'stock_sh_600549', 'stock_sh_600550', 'stock_sh_600551', 'stock_sh_600552', 'stock_sh_600555', 'stock_sh_600556', 'stock_sh_600557', 'stock_sh_600558', 'stock_sh_600559', 'stock_sh_600560', 'stock_sh_600561', 'stock_sh_600562', 'stock_sh_600563', 'stock_sh_600565', 'stock_sh_600566', 'stock_sh_600567', 'stock_sh_600568', 'stock_sh_600569', 'stock_sh_600570', 'stock_sh_600571', 'stock_sh_600572', 'stock_sh_600573', 'stock_sh_600575', 'stock_sh_600576', 'stock_sh_600577', 'stock_sh_600578', 'stock_sh_600579', 'stock_sh_600580', 'stock_sh_600581', 'stock_sh_600582', 'stock_sh_600583', 'stock_sh_600584', 'stock_sh_600585', 'stock_sh_600586', 'stock_sh_600587', 'stock_sh_600588', 'stock_sh_600589', 'stock_sh_600590', 'stock_sh_600592', 'stock_sh_600593', 'stock_sh_600594', 'stock_sh_600595', 'stock_sh_600596', 'stock_sh_600597', 'stock_sh_600598', 'stock_sh_600599', 'stock_sh_600600', 'stock_sh_600601', 'stock_sh_600602', 'stock_sh_600603', 'stock_sh_600604', 'stock_sh_600605', 'stock_sh_600606', 'stock_sh_600608', 'stock_sh_600609', 'stock_sh_600610', 'stock_sh_600611', 'stock_sh_600612', 'stock_sh_600613', 'stock_sh_600614', 'stock_sh_600615', 'stock_sh_600616', 'stock_sh_600617', 'stock_sh_600618', 'stock_sh_600619', 'stock_sh_600620', 'stock_sh_600621', 'stock_sh_600622', 'stock_sh_600623', 'stock_sh_600624', 'stock_sh_600626', 'stock_sh_600628', 'stock_sh_600629', 'stock_sh_600630', 'stock_sh_600633', 'stock_sh_600634', 'stock_sh_600635', 'stock_sh_600636', 'stock_sh_600637', 'stock_sh_600638', 'stock_sh_600639', 'stock_sh_600640', 'stock_sh_600641', 'stock_sh_600642', 'stock_sh_600643', 'stock_sh_600644', 'stock_sh_600645', 'stock_sh_600647', 'stock_sh_600648', 'stock_sh_600649', 'stock_sh_600650', 'stock_sh_600651', 'stock_sh_600652', 'stock_sh_600653', 'stock_sh_600654', 'stock_sh_600655', 'stock_sh_600657', 'stock_sh_600658', 'stock_sh_600660', 'stock_sh_600661', 'stock_sh_600662', 'stock_sh_600663', 'stock_sh_600664', 'stock_sh_600665', 'stock_sh_600666', 'stock_sh_600667', 'stock_sh_600668', 'stock_sh_600671', 'stock_sh_600673', 'stock_sh_600674', 'stock_sh_600675', 'stock_sh_600676', 'stock_sh_600677', 'stock_sh_600678', 'stock_sh_600679', 'stock_sh_600681', 'stock_sh_600682', 'stock_sh_600683', 'stock_sh_600684', 'stock_sh_600685', 'stock_sh_600686', 'stock_sh_600687', 'stock_sh_600688', 'stock_sh_600689', 'stock_sh_600690', 'stock_sh_600691', 'stock_sh_600692', 'stock_sh_600693', 'stock_sh_600694', 'stock_sh_600695', 'stock_sh_600696', 'stock_sh_600697', 'stock_sh_600698', 'stock_sh_600699', 'stock_sh_600701', 'stock_sh_600702', 'stock_sh_600703', 'stock_sh_600704', 'stock_sh_600705', 'stock_sh_600706', 'stock_sh_600707', 'stock_sh_600708', 'stock_sh_600710', 'stock_sh_600711', 'stock_sh_600712', 'stock_sh_600713', 'stock_sh_600714', 'stock_sh_600715', 'stock_sh_600716', 'stock_sh_600717', 'stock_sh_600718','stock_sh_600719', 'stock_sh_600720', 'stock_sh_600721', 'stock_sh_600722', 'stock_sh_600723', 'stock_sh_600724', 'stock_sh_600725', 'stock_sh_600726', 'stock_sh_600727', 'stock_sh_600728', 'stock_sh_600729', 'stock_sh_600730', 'stock_sh_600731', 'stock_sh_600732', 'stock_sh_600733', 'stock_sh_600734', 'stock_sh_600735', 'stock_sh_600736', 'stock_sh_600737', 'stock_sh_600738', 'stock_sh_600739', 'stock_sh_600740', 'stock_sh_600741', 'stock_sh_600742', 'stock_sh_600743', 'stock_sh_600744', 'stock_sh_600745', 'stock_sh_600746', 'stock_sh_600748', 'stock_sh_600749', 'stock_sh_600750', 'stock_sh_600751', 'stock_sh_600753', 'stock_sh_600754', 'stock_sh_600755', 'stock_sh_600756', 'stock_sh_600757', 'stock_sh_600758', 'stock_sh_600759', 'stock_sh_600760', 'stock_sh_600761', 'stock_sh_600763', 'stock_sh_600764', 'stock_sh_600765', 'stock_sh_600766', 'stock_sh_600767', 'stock_sh_600768', 'stock_sh_600769', 'stock_sh_600770', 'stock_sh_600771', 'stock_sh_600773', 'stock_sh_600774', 'stock_sh_600775', 'stock_sh_600776', 'stock_sh_600777', 'stock_sh_600778', 'stock_sh_600779', 'stock_sh_600780', 'stock_sh_600781', 'stock_sh_600782', 'stock_sh_600783', 'stock_sh_600784', 'stock_sh_600785', 'stock_sh_600787', 'stock_sh_600789', 'stock_sh_600790', 'stock_sh_600791', 'stock_sh_600792', 'stock_sh_600793', 'stock_sh_600794', 'stock_sh_600795', 'stock_sh_600796', 'stock_sh_600797', 'stock_sh_600798', 'stock_sh_600800', 'stock_sh_600801', 'stock_sh_600802', 'stock_sh_600803', 'stock_sh_600804', 'stock_sh_600805', 'stock_sh_600807', 'stock_sh_600808', 'stock_sh_600809', 'stock_sh_600810', 'stock_sh_600811', 'stock_sh_600812', 'stock_sh_600814', 'stock_sh_600815', 'stock_sh_600816', 'stock_sh_600817', 'stock_sh_600818', 'stock_sh_600819', 'stock_sh_600820', 'stock_sh_600821', 'stock_sh_600822', 'stock_sh_600823', 'stock_sh_600824', 'stock_sh_600825', 'stock_sh_600826', 'stock_sh_600827', 'stock_sh_600828', 'stock_sh_600829', 'stock_sh_600830', 'stock_sh_600831', 'stock_sh_600833', 'stock_sh_600834', 'stock_sh_600835', 'stock_sh_600836', 'stock_sh_600837', 'stock_sh_600838', 'stock_sh_600839', 'stock_sh_600841', 'stock_sh_600843', 'stock_sh_600844', 'stock_sh_600845', 'stock_sh_600846', 'stock_sh_600847', 'stock_sh_600848', 'stock_sh_600850', 'stock_sh_600851', 'stock_sh_600853', 'stock_sh_600854', 'stock_sh_600855', 'stock_sh_600856', 'stock_sh_600857', 'stock_sh_600858', 'stock_sh_600859', 'stock_sh_600860', 'stock_sh_600861', 'stock_sh_600862', 'stock_sh_600863', 'stock_sh_600864', 'stock_sh_600865', 'stock_sh_600866', 'stock_sh_600867', 'stock_sh_600868', 'stock_sh_600869', 'stock_sh_600870', 'stock_sh_600871', 'stock_sh_600872', 'stock_sh_600873', 'stock_sh_600874', 'stock_sh_600875', 'stock_sh_600876', 'stock_sh_600877', 'stock_sh_600879', 'stock_sh_600880', 'stock_sh_600881', 'stock_sh_600882', 'stock_sh_600883', 'stock_sh_600884', 'stock_sh_600885', 'stock_sh_600886', 'stock_sh_600887', 'stock_sh_600888', 'stock_sh_600889', 'stock_sh_600890', 'stock_sh_600891', 'stock_sh_600892', 'stock_sh_600893', 'stock_sh_600894', 'stock_sh_600895', 'stock_sh_600896', 'stock_sh_600897', 'stock_sh_600898', 'stock_sh_600900', 'stock_sh_600901', 'stock_sh_600903', 'stock_sh_600908', 'stock_sh_600909', 'stock_sh_600917', 'stock_sh_600919', 'stock_sh_600926', 'stock_sh_600928', 'stock_sh_600929', 'stock_sh_600933', 'stock_sh_600936', 'stock_sh_600939', 'stock_sh_600958', 'stock_sh_600959', 'stock_sh_600960', 'stock_sh_600961', 'stock_sh_600962', 'stock_sh_600963', 'stock_sh_600965', 'stock_sh_600966', 'stock_sh_600967', 'stock_sh_600968', 'stock_sh_600969', 'stock_sh_600970', 'stock_sh_600971', 'stock_sh_600973', 'stock_sh_600975', 'stock_sh_600976', 'stock_sh_600977', 'stock_sh_600978', 'stock_sh_600979', 'stock_sh_600980', 'stock_sh_600981', 'stock_sh_600982', 'stock_sh_600983', 'stock_sh_600984', 'stock_sh_600985', 'stock_sh_600986', 'stock_sh_600987', 'stock_sh_600988', 'stock_sh_600989', 'stock_sh_600990', 'stock_sh_600992', 'stock_sh_600993', 'stock_sh_600995', 'stock_sh_600996', 'stock_sh_600997', 'stock_sh_600998', 'stock_sh_600999', 'stock_sh_601000', 'stock_sh_601001', 'stock_sh_601002', 'stock_sh_601003', 'stock_sh_601005', 'stock_sh_601006', 'stock_sh_601007', 'stock_sh_601008', 'stock_sh_601009', 'stock_sh_601010', 'stock_sh_601011', 'stock_sh_601012', 'stock_sh_601015', 'stock_sh_601016', 'stock_sh_601018', 'stock_sh_601019', 'stock_sh_601020', 'stock_sh_601021', 'stock_sh_601028', 'stock_sh_601038', 'stock_sh_601058', 'stock_sh_601066', 'stock_sh_601068', 'stock_sh_601069', 'stock_sh_601077', 'stock_sh_601086', 'stock_sh_601088', 'stock_sh_601098', 'stock_sh_601099', 'stock_sh_601100', 'stock_sh_601101', 'stock_sh_601106', 'stock_sh_601107', 'stock_sh_601108', 'stock_sh_601111', 'stock_sh_601113', 'stock_sh_601116', 'stock_sh_601117', 'stock_sh_601118', 'stock_sh_601126', 'stock_sh_601127', 'stock_sh_601128', 'stock_sh_601137', 'stock_sh_601138', 'stock_sh_601139', 'stock_sh_601155', 'stock_sh_601158', 'stock_sh_601162', 'stock_sh_601163', 'stock_sh_601166', 'stock_sh_601168', 'stock_sh_601169', 'stock_sh_601177', 'stock_sh_601179', 'stock_sh_601186', 'stock_sh_601188', 'stock_sh_601198', 'stock_sh_601199', 'stock_sh_601200', 'stock_sh_601208', 'stock_sh_601211', 'stock_sh_601212', 'stock_sh_601216', 'stock_sh_601218', 'stock_sh_601222', 'stock_sh_601225', 'stock_sh_601226', 'stock_sh_601228', 'stock_sh_601229', 'stock_sh_601231', 'stock_sh_601233', 'stock_sh_601236', 'stock_sh_601238', 'stock_sh_601258', 'stock_sh_601288', 'stock_sh_601298', 'stock_sh_601311', 'stock_sh_601318', 'stock_sh_601319', 'stock_sh_601326', 'stock_sh_601328', 'stock_sh_601330', 'stock_sh_601333', 'stock_sh_601336', 'stock_sh_601339', 'stock_sh_601360', 'stock_sh_601366', 'stock_sh_601368', 'stock_sh_601369', 'stock_sh_601375', 'stock_sh_601377', 'stock_sh_601388', 'stock_sh_601390', 'stock_sh_601398', 'stock_sh_601500', 'stock_sh_601512', 'stock_sh_601515', 'stock_sh_601518', 'stock_sh_601519', 'stock_sh_601555', 'stock_sh_601558', 'stock_sh_601566', 'stock_sh_601567', 'stock_sh_601577', 'stock_sh_601579', 'stock_sh_601588', 'stock_sh_601595', 'stock_sh_601598', 'stock_sh_601599', 'stock_sh_601600', 'stock_sh_601601', 'stock_sh_601606', 'stock_sh_601607', 'stock_sh_601608', 'stock_sh_601611', 'stock_sh_601615', 'stock_sh_601616', 'stock_sh_601618', 'stock_sh_601619', 'stock_sh_601628', 'stock_sh_601633', 'stock_sh_601636', 'stock_sh_601658', 'stock_sh_601666', 'stock_sh_601668', 'stock_sh_601669', 'stock_sh_601677', 'stock_sh_601678', 'stock_sh_601688', 'stock_sh_601689', 'stock_sh_601696', 'stock_sh_601698', 'stock_sh_601699', 'stock_sh_601700', 'stock_sh_601717', 'stock_sh_601718', 'stock_sh_601727', 'stock_sh_601766', 'stock_sh_601777', 'stock_sh_601788', 'stock_sh_601789', 'stock_sh_601798', 'stock_sh_601799', 'stock_sh_601800', 'stock_sh_601801', 'stock_sh_601808', 'stock_sh_601811', 'stock_sh_601816', 'stock_sh_601818', 'stock_sh_601828', 'stock_sh_601838', 'stock_sh_601857', 'stock_sh_601858', 'stock_sh_601860', 'stock_sh_601865', 'stock_sh_601866', 'stock_sh_601869', 'stock_sh_601872', 'stock_sh_601877', 'stock_sh_601878', 'stock_sh_601880', 'stock_sh_601881', 'stock_sh_601882', 'stock_sh_601886', 'stock_sh_601888', 'stock_sh_601890', 'stock_sh_601898', 'stock_sh_601899', 'stock_sh_601900', 'stock_sh_601901', 'stock_sh_601908', 'stock_sh_601916', 'stock_sh_601918', 'stock_sh_601919', 'stock_sh_601928', 'stock_sh_601929', 'stock_sh_601933', 'stock_sh_601939', 'stock_sh_601949', 'stock_sh_601952', 'stock_sh_601958', 'stock_sh_601965', 'stock_sh_601966', 'stock_sh_601968', 'stock_sh_601969', 'stock_sh_601975', 'stock_sh_601985', 'stock_sh_601988', 'stock_sh_601989', 'stock_sh_601990', 'stock_sh_601991', 'stock_sh_601992', 'stock_sh_601996', 'stock_sh_601997', 'stock_sh_601998', 'stock_sh_601999', 'stock_sh_603000', 'stock_sh_603001', 'stock_sh_603002', 'stock_sh_603003', 'stock_sh_603005', 'stock_sh_603006', 'stock_sh_603007', 'stock_sh_603008', 'stock_sh_603009', 'stock_sh_603010', 'stock_sh_603011', 'stock_sh_603012', 'stock_sh_603013', 'stock_sh_603015', 'stock_sh_603016', 'stock_sh_603017', 'stock_sh_603018', 'stock_sh_603019', 'stock_sh_603020', 'stock_sh_603021', 'stock_sh_603022', 'stock_sh_603023', 'stock_sh_603025', 'stock_sh_603026', 'stock_sh_603027', 'stock_sh_603028', 'stock_sh_603029', 'stock_sh_603030', 'stock_sh_603031', 'stock_sh_603032', 'stock_sh_603033', 'stock_sh_603035', 'stock_sh_603036', 'stock_sh_603037', 'stock_sh_603038', 'stock_sh_603039', 'stock_sh_603040', 'stock_sh_603041', 'stock_sh_603042', 'stock_sh_603043', 'stock_sh_603045', 'stock_sh_603050', 'stock_sh_603053', 'stock_sh_603055', 'stock_sh_603056', 'stock_sh_603058', 'stock_sh_603059', 'stock_sh_603060', 'stock_sh_603063', 'stock_sh_603066', 'stock_sh_603067', 'stock_sh_603068', 'stock_sh_603069', 'stock_sh_603076', 'stock_sh_603077', 'stock_sh_603078', 'stock_sh_603079', 'stock_sh_603080', 'stock_sh_603081', 'stock_sh_603083', 'stock_sh_603085', 'stock_sh_603086', 'stock_sh_603088', 'stock_sh_603089', 'stock_sh_603090', 'stock_sh_603093', 'stock_sh_603096', 'stock_sh_603098', 'stock_sh_603099', 'stock_sh_603100', 'stock_sh_603101', 'stock_sh_603103', 'stock_sh_603105', 'stock_sh_603106', 'stock_sh_603108', 'stock_sh_603109', 'stock_sh_603110', 'stock_sh_603111', 'stock_sh_603113', 'stock_sh_603115', 'stock_sh_603116', 'stock_sh_603117', 'stock_sh_603118', 'stock_sh_603121', 'stock_sh_603123', 'stock_sh_603126', 'stock_sh_603127', 'stock_sh_603128', 'stock_sh_603129', 'stock_sh_603131', 'stock_sh_603133', 'stock_sh_603136', 'stock_sh_603138', 'stock_sh_603139', 'stock_sh_603156', 'stock_sh_603157', 'stock_sh_603158', 'stock_sh_603159', 'stock_sh_603160', 'stock_sh_603161', 'stock_sh_603165', 'stock_sh_603166', 'stock_sh_603167', 'stock_sh_603168', 'stock_sh_603169', 'stock_sh_603177', 'stock_sh_603178', 'stock_sh_603179', 'stock_sh_603180', 'stock_sh_603181', 'stock_sh_603183', 'stock_sh_603185', 'stock_sh_603186', 'stock_sh_603187', 'stock_sh_603188', 'stock_sh_603189', 'stock_sh_603192', 'stock_sh_603195', 'stock_sh_603196', 'stock_sh_603197', 'stock_sh_603198', 'stock_sh_603199', 'stock_sh_603200', 'stock_sh_603203', 'stock_sh_603208', 'stock_sh_603214', 'stock_sh_603217', 'stock_sh_603218', 'stock_sh_603220', 'stock_sh_603221', 'stock_sh_603222', 'stock_sh_603223', 'stock_sh_603225', 'stock_sh_603226', 'stock_sh_603227', 'stock_sh_603228', 'stock_sh_603229', 'stock_sh_603232', 'stock_sh_603233', 'stock_sh_603236', 'stock_sh_603238', 'stock_sh_603239', 'stock_sh_603256', 'stock_sh_603258', 'stock_sh_603259', 'stock_sh_603260', 'stock_sh_603266', 'stock_sh_603267', 'stock_sh_603268', 'stock_sh_603269', 'stock_sh_603277', 'stock_sh_603278', 'stock_sh_603279', 'stock_sh_603283', 'stock_sh_603286', 'stock_sh_603288', 'stock_sh_603289', 'stock_sh_603290', 'stock_sh_603297', 'stock_sh_603298', 'stock_sh_603299', 'stock_sh_603300', 'stock_sh_603301', 'stock_sh_603303', 'stock_sh_603305', 'stock_sh_603306', 'stock_sh_603308', 'stock_sh_603309', 'stock_sh_603311', 'stock_sh_603313', 'stock_sh_603315', 'stock_sh_603316', 'stock_sh_603317', 'stock_sh_603318', 'stock_sh_603319', 'stock_sh_603320', 'stock_sh_603321', 'stock_sh_603322', 'stock_sh_603323', 'stock_sh_603326', 'stock_sh_603327', 'stock_sh_603328', 'stock_sh_603329', 'stock_sh_603330', 'stock_sh_603331', 'stock_sh_603332', 'stock_sh_603333', 'stock_sh_603335', 'stock_sh_603336', 'stock_sh_603337', 'stock_sh_603338', 'stock_sh_603339', 'stock_sh_603345', 'stock_sh_603348', 'stock_sh_603351', 'stock_sh_603355', 'stock_sh_603356', 'stock_sh_603357', 'stock_sh_603358', 'stock_sh_603359', 'stock_sh_603360', 'stock_sh_603363', 'stock_sh_603365', 'stock_sh_603366', 'stock_sh_603367', 'stock_sh_603368', 'stock_sh_603369', 'stock_sh_603377', 'stock_sh_603378', 'stock_sh_603379', 'stock_sh_603380', 'stock_sh_603383', 'stock_sh_603385', 'stock_sh_603386', 'stock_sh_603387', 'stock_sh_603388', 'stock_sh_603389', 'stock_sh_603390', 'stock_sh_603393', 'stock_sh_603396', 'stock_sh_603398', 'stock_sh_603399', 'stock_sh_603416', 'stock_sh_603421', 'stock_sh_603429', 'stock_sh_603444', 'stock_sh_603456', 'stock_sh_603458', 'stock_sh_603466', 'stock_sh_603477', 'stock_sh_603486', 'stock_sh_603488', 'stock_sh_603489', 'stock_sh_603496', 'stock_sh_603499', 'stock_sh_603500', 'stock_sh_603501', 'stock_sh_603505', 'stock_sh_603506', 'stock_sh_603507', 'stock_sh_603508', 'stock_sh_603515', 'stock_sh_603516', 'stock_sh_603517', 'stock_sh_603518', 'stock_sh_603519', 'stock_sh_603520', 'stock_sh_603527', 'stock_sh_603528', 'stock_sh_603530', 'stock_sh_603533', 'stock_sh_603535', 'stock_sh_603536', 'stock_sh_603538', 'stock_sh_603551', 'stock_sh_603555', 'stock_sh_603556', 'stock_sh_603557', 'stock_sh_603558', 'stock_sh_603559', 'stock_sh_603566', 'stock_sh_603567', 'stock_sh_603568', 'stock_sh_603569', 'stock_sh_603577', 'stock_sh_603578', 'stock_sh_603579', 'stock_sh_603580', 'stock_sh_603583', 'stock_sh_603585', 'stock_sh_603586', 'stock_sh_603587', 'stock_sh_603588', 'stock_sh_603589', 'stock_sh_603590', 'stock_sh_603595', 'stock_sh_603596', 'stock_sh_603598', 'stock_sh_603599', 'stock_sh_603600', 'stock_sh_603601', 'stock_sh_603602', 'stock_sh_603603', 'stock_sh_603605', 'stock_sh_603606', 'stock_sh_603607', 'stock_sh_603608', 'stock_sh_603609', 'stock_sh_603610', 'stock_sh_603611', 'stock_sh_603612', 'stock_sh_603613', 'stock_sh_603615', 'stock_sh_603616', 'stock_sh_603617', 'stock_sh_603618', 'stock_sh_603619', 'stock_sh_603626', 'stock_sh_603628', 'stock_sh_603629', 'stock_sh_603630', 'stock_sh_603633', 'stock_sh_603636', 'stock_sh_603637', 'stock_sh_603638', 'stock_sh_603639', 'stock_sh_603648', 'stock_sh_603650', 'stock_sh_603655', 'stock_sh_603656', 'stock_sh_603657', 'stock_sh_603658', 'stock_sh_603659', 'stock_sh_603660', 'stock_sh_603661', 'stock_sh_603662', 'stock_sh_603663', 'stock_sh_603665', 'stock_sh_603666', 'stock_sh_603667', 'stock_sh_603668', 'stock_sh_603669', 'stock_sh_603676', 'stock_sh_603677', 'stock_sh_603678', 'stock_sh_603679', 'stock_sh_603680', 'stock_sh_603681', 'stock_sh_603683', 'stock_sh_603685', 'stock_sh_603686', 'stock_sh_603687', 'stock_sh_603688', 'stock_sh_603689', 'stock_sh_603690', 'stock_sh_603693', 'stock_sh_603696', 'stock_sh_603697', 'stock_sh_603698', 'stock_sh_603699', 'stock_sh_603700', 'stock_sh_603701', 'stock_sh_603703', 'stock_sh_603706', 'stock_sh_603707', 'stock_sh_603708', 'stock_sh_603709', 'stock_sh_603711', 'stock_sh_603712', 'stock_sh_603713', 'stock_sh_603716', 'stock_sh_603717', 'stock_sh_603718', 'stock_sh_603719', 'stock_sh_603721', 'stock_sh_603722', 'stock_sh_603725', 'stock_sh_603726', 'stock_sh_603727', 'stock_sh_603728', 'stock_sh_603729', 'stock_sh_603730', 'stock_sh_603733', 'stock_sh_603737', 'stock_sh_603738', 'stock_sh_603739', 'stock_sh_603755', 'stock_sh_603757', 'stock_sh_603758', 'stock_sh_603766', 'stock_sh_603767', 'stock_sh_603768', 'stock_sh_603773', 'stock_sh_603776', 'stock_sh_603777', 'stock_sh_603778', 'stock_sh_603779', 'stock_sh_603786', 'stock_sh_603787', 'stock_sh_603788', 'stock_sh_603789', 'stock_sh_603790', 'stock_sh_603797', 'stock_sh_603798', 'stock_sh_603799', 'stock_sh_603800', 'stock_sh_603801', 'stock_sh_603803', 'stock_sh_603806','stock_sh_603808', 'stock_sh_603809', 'stock_sh_603810', 'stock_sh_603811', 'stock_sh_603813', 'stock_sh_603815', 'stock_sh_603816', 'stock_sh_603817', 'stock_sh_603818', 'stock_sh_603819', 'stock_sh_603822', 'stock_sh_603823', 'stock_sh_603825', 'stock_sh_603826', 'stock_sh_603828', 'stock_sh_603829', 'stock_sh_603833', 'stock_sh_603838', 'stock_sh_603839', 'stock_sh_603843', 'stock_sh_603848', 'stock_sh_603855', 'stock_sh_603856', 'stock_sh_603858', 'stock_sh_603859', 'stock_sh_603860', 'stock_sh_603861', 'stock_sh_603863', 'stock_sh_603866', 'stock_sh_603867', 'stock_sh_603868', 'stock_sh_603869', 'stock_sh_603871', 'stock_sh_603876', 'stock_sh_603877', 'stock_sh_603878', 'stock_sh_603879', 'stock_sh_603880', 'stock_sh_603881', 'stock_sh_603882', 'stock_sh_603883', 'stock_sh_603885', 'stock_sh_603886', 'stock_sh_603887', 'stock_sh_603888', 'stock_sh_603889', 'stock_sh_603890', 'stock_sh_603893', 'stock_sh_603895', 'stock_sh_603896', 'stock_sh_603897', 'stock_sh_603898', 'stock_sh_603899', 'stock_sh_603900', 'stock_sh_603901', 'stock_sh_603903', 'stock_sh_603906', 'stock_sh_603908', 'stock_sh_603909', 'stock_sh_603912', 'stock_sh_603915', 'stock_sh_603916', 'stock_sh_603917', 'stock_sh_603918', 'stock_sh_603919', 'stock_sh_603920', 'stock_sh_603922', 'stock_sh_603926', 'stock_sh_603927', 'stock_sh_603928', 'stock_sh_603929', 'stock_sh_603933', 'stock_sh_603936', 'stock_sh_603937', 'stock_sh_603938', 'stock_sh_603939', 'stock_sh_603948', 'stock_sh_603949', 'stock_sh_603955', 'stock_sh_603956', 'stock_sh_603958', 'stock_sh_603959', 'stock_sh_603960', 'stock_sh_603963', 'stock_sh_603966', 'stock_sh_603967', 'stock_sh_603968', 'stock_sh_603969', 'stock_sh_603970', 'stock_sh_603976', 'stock_sh_603977', 'stock_sh_603978', 'stock_sh_603979', 'stock_sh_603980', 'stock_sh_603982', 'stock_sh_603983', 'stock_sh_603985', 'stock_sh_603986', 'stock_sh_603987', 'stock_sh_603988', 'stock_sh_603989', 'stock_sh_603990', 'stock_sh_603991', 'stock_sh_603992', 'stock_sh_603993', 'stock_sh_603995', 'stock_sh_603996', 'stock_sh_603997', 'stock_sh_603998', 'stock_sh_603999')] (Background on this error at: http://sqlalche.me/e/e3q8)

foolcage commented 4 years ago

请使用最新的版本。 "too many SQL variables"是 sqlite版本的问题,ubuntu16以上和mac暂时没碰到,windows请参考网上的解决办法。