---------------------------------------------------------------------------
ParserException Traceback (most recent call last)
Cell In[1], line 66
29 m1 = M.input_features_dai.v6(
30 sql="""-- 使用DAI SQL获取数据,构建因子等,如下是一个例子作为参考
31 -- DAI SQL 语法: https://bigquant.com/wiki/doc/dai-PLSbc1SbZX#h-sql%E5%85%A5%E9%97%A8%E6%95%99%E7%A8%8B
(...)
62 """
63 )
65 # @module(position="-981,-294", comment='6. 预测数据,设置预测时间,开启模拟交易时绑定交易日期', comment_collapsed=True)
---> 66 m7 = M.extract_data_dai.v7(
67 sql=m1.data,
68 start_date='2024-01-01',
69 start_date_bound_to_trading_date=True,
70 end_date='2024-01-23',
71 end_date_bound_to_trading_date=True,
72 before_start_days=90,
73 debug=False
74 )
75 # </aistudiograph>
File module2/common/modulemanagerv2.py:88, in biglearning.module2.common.modulemanagerv2.BigQuantModuleVersion.__call__()
File module2/common/moduleinvoker.py:370, in biglearning.module2.common.moduleinvoker.module_invoke()
File module2/common/moduleinvoker.py:292, in biglearning.module2.common.moduleinvoker._invoke_with_cache()
File module2/common/moduleinvoker.py:253, in biglearning.module2.common.moduleinvoker._invoke_with_cache()
File module2/common/moduleinvoker.py:210, in biglearning.module2.common.moduleinvoker._module_run()
File /var/app/data/custom_module/publicmodules/extract_data_dai/v7/__init__.py:99, in run(sql, start_date, start_date_bound_to_trading_date, end_date, end_date_bound_to_trading_date, before_start_days, debug)
96 query_start_date = start_date
98 logger.info(f"{start_date=}, {end_date=}, {query_start_date=} ..")
---> 99 data = dai.query(sql, filters={"date": [query_start_date, end_date]}).df()
101 if "date" in data.columns:
102 data = data[(data["date"] >= start_date) & (data["date"] <= end_date)]
File /var/app/enabled/dai/_functions.py:121, in query(sql, udf_list, full_db_scan, filters)
ParserException: Parser Error: syntax error at or near "select"
LINE 8: -- 在时间截面的total_market_cap排名