=========================================================================
2025-08-20 08:20:11 Wed START TASK.01 hibor_data update_data
=========================================================================
PAGE 1*********************************************************
skip article: 格林大华期货-早盘提示：全球经济
skip article: 永安期货-合成橡胶早报
skip article: 永安期货-沥青早报
skip article: 永安期货-焦煤日报
skip article: 永安期货-焦炭日报
skip article: 金信期货-日刊
skip article: 长江期货-油脂：供需边际收紧，价格重心上移
skip article: 天富期货-原油继续回落，能化延续下跌压力
skip article: 浙商期货-【油脂周报】接连利多后迎来分化
skip article: 浙商期货-【棉花棉纱周报】下游需求有所转好，棉花价格震荡偏强
skip article: 浙商期货-【玉米周报】部分企业开始停收玉米，玉米价格继续震荡偏弱
skip article: 浙商期货-【白糖周报】中秋备货启动，现货小幅反弹
skip article: 浙商期货-【生猪鸡蛋周报】旺季临近利好需求，供给限制上方空间
skip article: 浙商期货-【粕类周报】菜籽反倾销叠加USDA报告利多，粕类板块偏强运行
skip article: 中信期货-航运策略日报：MSK开舱9月首周2100美元/FEU跌幅收窄，多航司线上步入2500美元/FEU区间
skip article: 国金期货-纯碱期货日报
skip article: 国金期货-烧碱期货日报
skip article: 国金期货-铁矿石期货日报
skip article: 国金期货-锰硅期货日报
skip article: 宁证期货-期现日报
PAGE 2*********************************************************
skip article: 国金期货-纯碱期货周报：先涨后跌，弱势震荡
skip article: 国金期货-苹果期货日报
skip article: 国金期货-铁矿石期货日报
skip article: 国金期货-烧碱期货周报：延续反弹
skip article: 国金期货-锰硅期货日报
skip article: 国贸期货-白糖数据日报
skip article: 国贸期货-生猪数据日报
skip article: 国贸期货-甲醇数据日报
skip article: 国贸期货-玻璃纯碱数据日报
skip article: 国贸期货-瓶片短纤数据日报
skip article: 国贸期货-聚酯数据日报
skip article: 国贸期货-碳酸锂数据日报
skip article: 国贸期货-纸浆数据日报
skip article: 国金期货-天然橡胶期货日报
skip article: 国金期货-合成橡胶期货日报
skip article: 国金期货-尿素期货周报
skip article: 国金期货-不锈钢期货日报
skip article: 国金期货-合成橡胶周报：震荡上行后承压回调
skip article: 银河期货-航运日报
skip article: 国贸期货-玉米系数据日报
PAGE 3*********************************************************
skip article: 天富期货-玉米、鸡蛋持续下挫
skip article: 南华期货-锌风险管理报告
skip article: 南华期货-甲醇产业风险管理日报
skip article: 南华期货-碳酸锂企业风险管理日报
skip article: 南华期货-烧碱产业风险管理日报
skip article: 南华期货-原油市场日报：盘面缩量反弹，美俄会谈成关键变量
skip article: 南华期货-硅产业链企业风险管理日报
skip article: 通惠期货-期货新品种纯苯专题报告（二）：产业链格局
skip article: 通惠期货-期货新品种纯苯专题报告（三）：纯苯与己内酰胺
skip article: 南华期货-尿素产业风险管理日报
skip article: 南华期货-商品指数：农产品板块上涨，黑色板块领跌
skip article: 宏源期货-有色金属周报（工业硅&多晶硅）：走势坚挺
skip article: 山金期货-贵金属策略报告
skip article: 冠通期货-冠通每日交易策略
skip article: 国联期货-橡胶周报：库存水平暂时稳定，观察全钢积极因素能否扩散
skip article: 国贸期货-油脂数据日报
skip article: 国都期货-热点追踪
skip article: 国都期货-国都观势
skip article: 华鑫期货-每日晨报
skip article: 华鑫期货-每日晨报
PAGE 4*********************************************************
skip article: 南华期货-国债期货日报：债市弱反弹
skip article: 华鑫期货-每日国内期货收盘数据和点评
skip article: 华鑫期货-每日国内期货收盘数据和点评
skip article: 华鑫期货-每日国内期货收盘数据和点评
skip article: 华鑫期货-每日国内期货收盘数据和点评
skip article: 华鑫期货-每日国内期货收盘数据和点评
skip article: 华鑫期货-每日晨报
skip article: 华鑫期货-每日晨报
skip article: 华鑫期货-每日晨报
skip article: 华鑫期货-每日晨报
skip article: 冠通期货-PVC：震荡下行
skip article: 冠通期货-出口预期转好，尿素上行
skip article: 冠通期货-沥青：震荡下行
skip article: 冠通期货-等待新的驱动
skip article: 冠通期货-PP：震荡下行
skip article: 冠通期货-原油：震荡下行
skip article: 冠通期货-塑料：震荡下行
skip article: 国投期货-商品量化CTA周度跟踪
skip article: 国投期货-有色金属周度观点
skip article: 国投期货-钢材：弱需求压制短期盘面
PAGE 5*********************************************************
skip article: 国投期货-USDA周度大豆玉米生长报告
skip article: 国投期货-能源日报
skip article: 国投期货-黑色金属日报
skip article: 国投期货-软商品日报
skip article: 国投期货-有色金属日报
skip article: 国投期货-化工日报
skip article: 国投期货-农产品日报
skip article: 国投期货-有色金属现货升贴水
skip article: 银河期货-鸡蛋日报
skip article: 东证期货-液化石油气热点报告：FEI的相对强势还能持续多久？
skip article: 银河期货-黑色金属每日早盘观察
skip article: 银河期货-铁合金日报
skip article: 银河期货-螺纹热卷日报
skip article: 银河期货-螺纹热卷日报
skip article: 银河期货-白糖日报
skip article: 宏源期货-甲醇周报：偏弱震荡为主
skip article: 国元期货-贵金属期货周报：美经济数据施压，金银产业机遇犹存
skip article: 华鑫期货-每日晨报
skip article: 银河期货-铁矿石日报
skip article: 银河期货-每日早盘观察
PAGE 6*********************************************************
skip article: 银河期货-棉花、棉纱日报
skip article: 银河期货-焦煤、焦炭日报
skip article: 银河期货-苹果日报
skip article: 南华期货-铝产业链?险管理报告
skip article: 东证期货-原油和石油产品贸易流跟踪
skip article: 宏源期货-镍不锈钢周报：降息预期与“反内卷”情绪反复，趋势难成
skip article: 银河期货-高硫三季度供应压力较预期下行，低硫关注配额节奏
skip article: 银河期货-燃料油日报
skip article: 银河期货-沥青日报
skip article: 银河期货-油脂日报
skip article: 方正中期期货-能源产业链日度策略
skip article: 银河期货-沥青日报
skip article: 宏源期货-有色金属周报（锌）：区间整理，关注宏观及海外风险
skip article: 方正中期期货-钢矿日度策略报告
skip article: 银河期货-【生猪日报】供应压力缓解，现货小幅反弹
skip article: 南华期货-人民币汇率热点：杰克逊霍尔全球央行年会前瞻
skip article: 方正中期期货-聚酯产业链日度策略报告
skip article: 银河期货-【粕类日报】市场新增题材有限，盘面窄幅震荡
skip article: 方正中期期货-铁合金日度策略
skip article: 银河期货-燃料油日报
PAGE 7*********************************************************
skip article: 中信期货-图说金融：是否需要担心中报披露季
skip article: 中信期货-【航运】数据报告：关税政策下运量及运力数据
skip article: 中信期货-海外苯乙烯开工下滑，全球开工中性
skip article: 瑞达期货-锰硅硅铁产业日报
skip article: 方正中期期货-有色金属日度策略
skip article: 方正中期期货-养殖油脂产业链日度策略报告
skip article: 方正中期期货-生鲜软商品板块日度策略报告
skip article: 方正中期期货-国债期货日度策略报告
skip article: =========================================================================
2025-08-20 09:00:41 Wed START TASK.01 hibor_data update_data
=========================================================================
=========================================================================
2025-08-20 09:41:13 Wed START TASK.01 hibor_data update_data
=========================================================================
=========================================================================
2025-08-20 10:21:44 Wed START TASK.01 hibor_data update_data
=========================================================================
PAGE 1*********************************************************
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 782, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1144, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py", line 702, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 483, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 453, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 744, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 788, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/hibor_data/update_data.py", line 8, in
run(playwright)
File "/root/project/hibor_data/hibor_request.py", line 161, in run
add_df.to_sql('hibor_data', con=engine, if_exists='append', index=False)
File "/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/dist-packages/pandas/core/generic.py", line 3087, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/dist-packages/pandas/io/sql.py", line 841, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/dist-packages/pandas/io/sql.py", line 1645, in __exit__
self.exit_stack.close()
File "/usr/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2631, in commit
self._do_commit()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2736, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2707, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1146, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1144, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py", line 702, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 483, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 453, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 744, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 788, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
PAGE 1*********************************************************
skip article: 招商期货-金融期货早班车
skip article: 招商期货-商品期货早班车
>>>>>>>>> add to db: 华泰期货-新能源及有色金属日报：多空博弈激烈，沪镍不锈钢震荡走弱
>>>>>>>>> add to db: 华泰期货-农产品日报：现货价格坚挺，豆粕震荡运行
>>>>>>>>> add to db: 华泰期货-新能源及有色金属日报：北方受运输影响现货表现尚可
>>>>>>>>> add to db: 华泰期货-新能源及有色金属日报：海外氧化铝价格同步出现松动
>>>>>>>>> add to db: 华泰期货-农产品日报：郑棉承压回落，白糖延续震荡
>>>>>>>>> add to db: 华泰期货-新能源及有色金属日报：冶炼产量仍偏高，铜价暂时难有靓丽表现
>>>>>>>>> add to db: 华泰期货-贵金属日报：白宫筹划美、俄、乌三方会晤避险溢价短期趋弱
>>>>>>>>> add to db: 华泰期货-FICC日报：马士基9月第一周报价下修，关注其他船司价格跟随情况
>>>>>>>>> add to db: 华泰期货-新能源及有色金属日报：下游表现持续偏淡，铅价维持震荡格局
>>>>>>>>> add to db: 华泰期货-化工日报：需求边际好转，关注成本端变动
>>>>>>>>> add to db: 华泰期货-FICC日报：市场波动加剧，股指震荡调整
>>>>>>>>> add to db: 华泰期货-聚烯烃日报：需求端缓慢跟进，市场支撑偏弱
>>>>>>>>> add to db: 华泰期货-黑色建材日报：市场情绪转弱，钢价震荡下行
>>>>>>>>> add to db: 华泰期货-新能源及有色金属日报：现货价格继续上涨，需关注供应端扰动
>>>>>>>>> add to db: 华泰期货-纯苯苯乙烯日报：EB港口基差持稳
>>>>>>>>> add to db: 华泰期货-燃料油日报：原油端延续弱势，短期市场驱动有限
>>>>>>>>> add to db: 华泰期货-石油沥青日报：需求维持弱势，市场情绪承压
>>>>>>>>> add to db: 华泰期货-黑色建材日报：市场情绪转弱，钢价震荡下行
PAGE 2*********************************************************
skip article: 长城期货-品种点评日报
>>>>>>>>> add to db: 国泰君安期货-LLDPE：区间震荡
>>>>>>>>> add to db: 国泰君安期货-PP：趋势偏弱，但低位追空要谨慎
>>>>>>>>> add to db: 国泰君安期货-合成橡胶：短线回调，中期仍为区间震荡
>>>>>>>>> add to db: 国泰君安期货-LPG：近月挤仓风险仍在，丙烯，成本支撑偏弱
>>>>>>>>> add to db: 国泰君安期货-PVC：趋势偏弱
>>>>>>>>> add to db: 国泰君安期货-尿素：短期消息面驱动，上方空间收窄
>>>>>>>>> add to db: 国泰君安期货-沥青：出货未见好，原油难偏多
>>>>>>>>> add to db: 国泰君安期货-棉花：关注新棉上市情况
>>>>>>>>> add to db: 国泰君安期货-棕榈油：跟随宏观为主，回调整理，豆油，美豆驱动不足，回调整理
>>>>>>>>> add to db: 国泰君安期货-工业硅：情绪转弱，多晶硅，市场消息发酵，情绪提振
>>>>>>>>> add to db: 国泰君安期货-橡胶：震荡偏弱
>>>>>>>>> add to db: 国泰君安期货-甲醇：震荡运行
>>>>>>>>> add to db: 国泰君安期货-烧碱：偏多对待，但需注意近月仓单情况
>>>>>>>>> add to db: 国泰君安期货-焦炭：高位震荡，焦煤，高位震荡
>>>>>>>>> add to db: 国泰君安期货-燃料油：弱势震荡走势为主，短期波动缩小，低硫燃料油，窄幅盘整，外盘现货高低硫价差小幅反弹
>>>>>>>>> add to db: 国泰君安期货-玉米：偏弱运行
>>>>>>>>> add to db: 国泰君安期货-玻璃：原片价格平稳
>>>>>>>>> add to db: 国泰君安期货-短纤：短期震荡市，关注旺季需求临近，瓶片，下方空间有限，震荡市
>>>>>>>>> add to db: 国泰君安期货-纯苯：偏弱震荡
PAGE 3*********************************************************
===exist in db, skip aritcle: 国泰君安期货-PVC：趋势偏弱===
===exist in db, skip aritcle: 国泰君安期货-尿素：短期消息面驱动，上方空间收窄===
===exist in db, skip aritcle: 国泰君安期货-沥青：出货未见好，原油难偏多===
{('苹果',): 'AP', ('一号棉花', '棉花'): 'CF', ('红枣', '枣'): 'CJ', ('棉纱', '纱线'): 'CY', ('玻璃',): 'FG', ('中证500指数', '中证500', '500指数'): 'IC', ('沪深300指数', '沪深300', '300指数'): 'IF', ('上证50指数', '上证50', '50指数'): 'IH', ('中证1000指数', '中证1000', '1000指数'): 'IM', ('粳稻', '北方稻'): 'JR', ('晚籼稻', '晚稻', '晚籼'): 'LR', ('甲醇N', '甲醇', '木醇', '工业酒精', '羟基甲烷'): 'MA', ('菜籽油', '食用油', '菜油'): 'OI', ('短纤', 'PF'): 'PF', ('花生仁', '花生'): 'PK', ('普通小麦', '普麦', '普通麦'): 'PM', ('对二甲苯', 'PX'): 'PX', ('早籼稻', '早稻', '早籼'): 'RI', ('菜籽粕', '菜粕', '饲料粕'): 'RM', ('油菜籽', '油籽', '菜籽'): 'RS', ('纯碱', '碳酸钠', '轻碱'): 'SA', ('硅铁',): 'SF', ('烧碱', '氢氧化钠', '片碱'): 'SH', ('锰硅', '硅锰合金'): 'SM', ('白砂糖', '食糖', '砂糖', '白糖'): 'SR', ('10年期国债期货', '10年期国债', '10年期债', '10年期'): 'T', ('精对苯二甲酸', '对苯酸', 'PTA'): 'TA', ('5年期国债期货', '5年期国债', '5年期债', '5年期'): 'TF', ('30年期国债期货', '30年期国债', '30年期债', '30年期'): 'TL', ('2年期国债期货', '2年期国债', '2年期债', '2年期'): 'TS', ('尿素',): 'UR', ('优质强筋小麦', '强筋麦', '高筋小麦', '强麦'): 'WH', ('动力煤N', '电煤', '动力煤'): 'ZC', ('黄大豆1号', '豆1', '豆一'): 'a', ('白银',): 'ag', ('铝',): 'al', ('氧化铝', '铝氧', '工业氧化铝'): 'ao', ('黄金',): 'au', ('黄大豆2号', '豆2', '豆二'): 'b', ('胶合板', '人造板', '胶板'): 'bb', ('国际铜', '铜（BC）', '铜(BC)'): 'bc', ('丁二烯橡胶', '合成橡胶', '丁二烯', '顺丁橡胶'): 'br', ('石油沥青', '沥青'): 'bu', ('黄玉米', '玉米'): 'c', ('玉米淀粉', '淀粉'): 'cs', ('铜',): 'cu', ('苯乙烯', '乙烯基苯'): 'eb', ('SCFIS欧线', '欧线', '集运', '集装', '欧洲航线'): 'ec', ('乙二醇', 'MEG'): 'eg', ('纤维板', '密度板'): 'fb', ('燃料油', '船用燃料', '燃油'): 'fu', ('热轧卷板', '热卷', '钢卷'): 'hc', ('铁矿石', '矿石', '铁矿'): 'i', ('冶金焦炭', '焦炭'): 'j', ('鸡蛋', '蛋'): 'jd', ('焦煤', '煤焦'): 'jm', ('线型低密度聚乙烯', '聚乙烯', '低密度聚乙烯', 'LLDPE'): 'l', ('碳酸锂', '锂盐'): 'lc', ('生猪', '猪'): 'lh', ('低硫燃料油', '低硫油', '船用油'): 'lu', ('豆粕', '饲料粕'): 'm', ('镍',): 'ni', ('20号胶', 'TSR20'): 'nr', ('棕榈油', '棕油'): 'p', ('铅',): 'pb', ('液化石油气', 'LPG', '瓶装气'): 'pg', ('聚丙烯', 'PP', '塑料原料'): 'pp', ('螺纹钢', '螺纹', '钢筋'): 'rb', ('粳米',): 'rr', ('天然橡胶', '天胶'): 'ru', ('原油', '石油'): 'sc', ('工业硅', '冶金硅'): 'si', ('锡',): 'sn', ('漂针浆', '纸浆', '针叶浆'): 'sp', ('不锈钢', '钢材'): 'ss', ('聚氯乙烯', 'PVC'): 'v', ('线材', '钢线', '线钢'): 'wr', ('豆油',): 'y', ('锌',): 'zn', ('瓶片', 'PET'): 'PR', ('原木',): 'lg', ('多晶硅',): 'ps', ('铝合金', '铸造铝合金'): 'ad', ('纯苯',): 'bz', ('丙烯',): 'PL'}
add pg,PL 液化石油气,丙烯
add SH,v 烧碱,聚氯乙烯
add UR 尿素
add bu,sc 石油沥青,原油
add CF,CY 一号棉花,棉纱
add RS,c,m,p,y 油菜籽,黄玉米,豆粕,棕榈油,豆油
add si,ps 工业硅,多晶硅
add
add MA 甲醇N
add SH,al,ao,v 烧碱,铝,氧化铝,聚氯乙烯
add al,j,jm,pp 铝,冶金焦炭,焦煤,聚丙烯
add fu,lu 燃料油,低硫燃料油
add c,ec,lh 黄玉米,SCFIS欧线,生猪
add FG 玻璃
add PF,PR 短纤,瓶片
add bz 纯苯
=========================================================================
2025-08-20 12:20:11 Wed START TASK.01 hibor_data update_data
=========================================================================
PAGE 1*********************************************************
skip article: 安粮期货-安粮观市
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 782, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1144, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py", line 702, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 483, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 453, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 744, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 788, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/hibor_data/update_data.py", line 8, in
run(playwright)
File "/root/project/hibor_data/hibor_request.py", line 161, in run
add_df.to_sql('hibor_data', con=engine, if_exists='append', index=False)
File "/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/dist-packages/pandas/core/generic.py", line 3087, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/dist-packages/pandas/io/sql.py", line 841, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/dist-packages/pandas/io/sql.py", line 1645, in __exit__
self.exit_stack.close()
File "/usr/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2631, in commit
self._do_commit()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2736, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2707, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1146, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1144, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py", line 702, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 483, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 453, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 744, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 788, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
方正中期期货-贵金属日度策略
skip article: 方正中期期货-新能源产业链日度策略
skip article: 方正中期期货-煤化工策略日报
skip article: 方正中期期货-天然橡胶产业链日度策略报告
skip article: 方正中期期货-上海→欧洲集运期货日报策略报告
skip article: 方正中期期货-黑色系焦煤焦炭日度策略
skip article: 方正中期期货-玻璃纯碱产业链日度策略
skip article: 东证期货-铸造铝合金热点报告：税返退坡压力增大，警惕产能关停风险
skip article: 瑞达期货-沪铜产业日报
skip article: 瑞达期货-热轧卷板产业链日报
skip article: 瑞达期货-工业硅产业日报
skip article: 瑞达期货-沪锌产业日报
PAGE 8*********************************************************
skip article: 瑞达期货-沪锡产业日报
skip article: 瑞达期货-沪铅产业日报
skip article: 瑞达期货-沪镍产业日报
skip article: 瑞达期货-碳酸锂产业日报
skip article: 瑞达期货-生猪产业日报
skip article: 瑞达期货-天然橡胶产业日报
skip article: 瑞达期货-甲醇产业日报
skip article: 瑞达期货-铝类产业日报
skip article: 瑞达期货-菜籽系产业日报
skip article: 瑞达期货-铁矿石产业链日报
skip article: 瑞达期货-合成橡胶产业日报
skip article: 瑞达期货-鸡蛋产业日报
skip article: 瑞达期货-纯碱玻璃产业日报
skip article: 瑞达期货-苹果产业日报
skip article: 瑞达期货-螺纹钢产业链日报
skip article: 瑞达期货-集运指数（欧线）期货日报
skip article: 瑞达期货-烧碱产业日报
skip article: 瑞达期货-尿素产业日报
skip article: 瑞达期货-塑料产业日报
skip article: 瑞达期货-焦煤焦炭产业日报
PAGE 9*********************************************************
skip article: 瑞达期货-玉米系产业日报
skip article: 银河期货-甲醇日报
skip article: 银河期货-尿素日报
skip article: 银河期货-内地转弱，甲醇延续跌势为主
skip article: 格林大华期货-市场快讯：短期供增需减，铁合金领跌黑色品种
skip article: 格林大华期货-市场快讯：出口印度可能放宽，尿素期价快速拉涨
skip article: 银河期货-印标再次扰动，尿素止跌反弹
skip article: 瑞达期货-多晶硅产业日报
skip article: 迈科期货-铜市日评：供需两弱但进口窗口打开预计到货增加
skip article: 长江期货-美国关税政策梳理及对铜价影响分析
skip article: 南华期货-早评
skip article: 浙商期货-【白银周报20250817】降息预期反复变动，银价小幅震荡
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 782, in _read_bytes
data = self._rfile.read(num_bytes)
File "/usr/lib/python3.10/socket.py", line 705, in readinto
return self._sock.recv_into(b)
ConnectionResetError: [Errno 104] Connection reset by peer
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1144, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py", line 702, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 483, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 453, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 744, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 788, in _read_bytes
raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/root/project/hibor_data/update_data.py", line 8, in
run(playwright)
File "/root/project/hibor_data/hibor_request.py", line 161, in run
add_df.to_sql('hibor_data', con=engine, if_exists='append', index=False)
File "/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py", line 333, in wrapper
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/dist-packages/pandas/core/generic.py", line 3087, in to_sql
return sql.to_sql(
File "/usr/local/lib/python3.10/dist-packages/pandas/io/sql.py", line 841, in to_sql
with pandasSQL_builder(con, schema=schema, need_transaction=True) as pandas_sql:
File "/usr/local/lib/python3.10/dist-packages/pandas/io/sql.py", line 1645, in __exit__
self.exit_stack.close()
File "/usr/lib/python3.10/contextlib.py", line 584, in close
self.__exit__(None, None, None)
File "/usr/lib/python3.10/contextlib.py", line 576, in __exit__
raise exc_details[1]
File "/usr/lib/python3.10/contextlib.py", line 561, in __exit__
if cb(*exc_details):
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/util.py", line 147, in __exit__
with util.safe_reraise():
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__
raise exc_value.with_traceback(exc_tb)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/util.py", line 145, in __exit__
self.commit()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2631, in commit
self._do_commit()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2736, in _do_commit
self._connection_commit_impl()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2707, in _connection_commit_impl
self.connection._commit_impl()
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1146, in _commit_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/base.py", line 1144, in _commit_impl
self.engine.dialect.do_commit(self.connection)
File "/usr/local/lib/python3.10/dist-packages/sqlalchemy/engine/default.py", line 702, in do_commit
dbapi_connection.commit()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 483, in commit
self._read_ok_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 453, in _read_ok_packet
pkt = self._read_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 744, in _read_packet
packet_header = self._read_bytes(4)
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 788, in _read_bytes
raise err.OperationalError(
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')
(Background on this error at: https://sqlalche.me/e/20/e3q8)
PAGE 1*********************************************************
skip article: 华宝期货-煤焦晨报：盘面震荡回调，关注环保限产落地
skip article: 华宝期货-铝锭晨报：淡季氛围持续，铝价区间调整
skip article: 华宝期货-铁矿石：供给增速超预期，短期矿价跟随运行
skip article: 申银万国期货-品种策略日报~聚烯烃
skip article: 申银万国期货-品种策略日报：国债
skip article: 申银万国期货-品种策略日报：油脂油料
skip article: 申银万国期货-首席点评：财政拐点与养老新政助力，A股生态迎来“慢牛”新起点
skip article: 中辉期货-有色观点
skip article: 华宝期货-成材晨报：弱需求下，钢价回调
skip article: 中辉期货-能化观点
skip article: 中辉期货-黑色观点
skip article: 中信期货-农业策略日报：基差或见底回升，豆粕正套机会可期
skip article: 中信期货-有色每日报告：需求逐步走弱，基本金属震荡承压
skip article: 华鑫期货-每日晨报
skip article: 中信期货-新能源金属每日报告：供应扰动风险仍存，新能源金属整体延续强势
skip article: 中信期货-能源列国志：刚果
skip article: 中信期货-晨报：国内商品期货多数下跌，黑色系普遍下跌
skip article: 中信期货-中国期货每日简报
skip article: 中信期货-能源化工策略日报：原油和煤炭价格双双走弱，成本端拖累化工
skip article: 格林大华期货-市场快讯：复产叠加改运消息缓解供应紧张预期，碳酸锂价格大幅下调
PAGE 2*********************************************************
skip article: 格林大华期货-市场快讯：红枣被美列入所谓重点执法对象
skip article: 中信期货-金融衍生品策略日报：股市震荡消化，债市情绪回暖
skip article: 中信期货-贵金属策略日报：经济数据良莠不齐，黄金延续震荡
skip article: 中信期货-黑色建材策略日报：需求预期偏弱，价格承压运行
>>>>>>>>> add to db: 国泰君安期货-欧盟碳市场行情简报（2025年第147期）
>>>>>>>>> add to db: 国泰君安期货-全国碳市场行情简报（2025年第140期）
skip article: 新世纪期货-集运日报：停火消息对盘面影响有限，近期波动较大，不建议继续加仓，设置好止损
>>>>>>>>> add to db: 国泰君安期货-铜：美元回升，价格承压
>>>>>>>>> add to db: 国泰君安期货-铅：海外库存大幅增加，价格承压
>>>>>>>>> add to db: 国泰君安期货-锌：小幅下跌
>>>>>>>>> add to db: 国泰君安期货-铝：区间震荡，氧化铝，重心下移，铸造铝合金，跟随电解铝
skip article: 宏源期货-镍与不锈钢日评：“反内卷”情绪变化快、波动大
>>>>>>>>> add to db: 国泰君安期货-硅铁：市场偏向基本面，偏弱震荡，锰硅，市场偏向基本面，偏弱震荡
>>>>>>>>> add to db: 国泰君安期货-锡：区间震荡
>>>>>>>>> add to db: 国泰君安期货-镍：基本面逻辑窄幅震荡，警惕消息面风险，不锈钢，宏观预期与现实博弈，钢价震荡运行
>>>>>>>>> add to db: 国泰君安期货-鸡蛋：远端预期较弱
skip article: 申银万国期货-品种策略日报：贵金属
skip article: 铜冠金源期货-商品日报
skip article: 申银万国期货-黑色金属现货价格数据监测
skip article: 东证期货-综合晨报：7月财政收入同比增2.6%
PAGE 3*********************************************************
skip article: 永安期货-内外套日报
skip article: 长城期货-品种点评日报
===exist in db, skip aritcle: 国泰君安期货-LLDPE：区间震荡===
===exist in db, skip aritcle: 国泰君安期货-PP：趋势偏弱，但低位追空要谨慎===
===exist in db, skip aritcle: 国泰君安期货-合成橡胶：短线回调，中期仍为区间震荡===
{('苹果',): 'AP', ('一号棉花', '棉花'): 'CF', ('红枣', '枣'): 'CJ', ('棉纱', '纱线'): 'CY', ('玻璃',): 'FG', ('中证500指数', '中证500', '500指数'): 'IC', ('沪深300指数', '沪深300', '300指数'): 'IF', ('上证50指数', '上证50', '50指数'): 'IH', ('中证1000指数', '中证1000', '1000指数'): 'IM', ('粳稻', '北方稻'): 'JR', ('晚籼稻', '晚稻', '晚籼'): 'LR', ('甲醇N', '甲醇', '木醇', '工业酒精', '羟基甲烷'): 'MA', ('菜籽油', '食用油', '菜油'): 'OI', ('短纤', 'PF'): 'PF', ('花生仁', '花生'): 'PK', ('普通小麦', '普麦', '普通麦'): 'PM', ('对二甲苯', 'PX'): 'PX', ('早籼稻', '早稻', '早籼'): 'RI', ('菜籽粕', '菜粕', '饲料粕'): 'RM', ('油菜籽', '油籽', '菜籽'): 'RS', ('纯碱', '碳酸钠', '轻碱'): 'SA', ('硅铁',): 'SF', ('烧碱', '氢氧化钠', '片碱'): 'SH', ('锰硅', '硅锰合金'): 'SM', ('白砂糖', '食糖', '砂糖', '白糖'): 'SR', ('10年期国债期货', '10年期国债', '10年期债', '10年期'): 'T', ('精对苯二甲酸', '对苯酸', 'PTA'): 'TA', ('5年期国债期货', '5年期国债', '5年期债', '5年期'): 'TF', ('30年期国债期货', '30年期国债', '30年期债', '30年期'): 'TL', ('2年期国债期货', '2年期国债', '2年期债', '2年期'): 'TS', ('尿素',): 'UR', ('优质强筋小麦', '强筋麦', '高筋小麦', '强麦'): 'WH', ('动力煤N', '电煤', '动力煤'): 'ZC', ('黄大豆1号', '豆1', '豆一'): 'a', ('白银',): 'ag', ('铝',): 'al', ('氧化铝', '铝氧', '工业氧化铝'): 'ao', ('黄金',): 'au', ('黄大豆2号', '豆2', '豆二'): 'b', ('胶合板', '人造板', '胶板'): 'bb', ('国际铜', '铜（BC）', '铜(BC)'): 'bc', ('丁二烯橡胶', '合成橡胶', '丁二烯', '顺丁橡胶'): 'br', ('石油沥青', '沥青'): 'bu', ('黄玉米', '玉米'): 'c', ('玉米淀粉', '淀粉'): 'cs', ('铜',): 'cu', ('苯乙烯', '乙烯基苯'): 'eb', ('SCFIS欧线', '欧线', '集运', '集装', '欧洲航线'): 'ec', ('乙二醇', 'MEG'): 'eg', ('纤维板', '密度板'): 'fb', ('燃料油', '船用燃料', '燃油'): 'fu', ('热轧卷板', '热卷', '钢卷'): 'hc', ('铁矿石', '矿石', '铁矿'): 'i', ('冶金焦炭', '焦炭'): 'j', ('鸡蛋', '蛋'): 'jd', ('焦煤', '煤焦'): 'jm', ('线型低密度聚乙烯', '聚乙烯', '低密度聚乙烯', 'LLDPE'): 'l', ('碳酸锂', '锂盐'): 'lc', ('生猪', '猪'): 'lh', ('低硫燃料油', '低硫油', '船用油'): 'lu', ('豆粕', '饲料粕'): 'm', ('镍',): 'ni', ('20号胶', 'TSR20'): 'nr', ('棕榈油', '棕油'): 'p', ('铅',): 'pb', ('液化石油气', 'LPG', '瓶装气'): 'pg', ('聚丙烯', 'PP', '塑料原料'): 'pp', ('螺纹钢', '螺纹', '钢筋'): 'rb', ('粳米',): 'rr', ('天然橡胶', '天胶'): 'ru', ('原油', '石油'): 'sc', ('工业硅', '冶金硅'): 'si', ('锡',): 'sn', ('漂针浆', '纸浆', '针叶浆'): 'sp', ('不锈钢', '钢材'): 'ss', ('聚氯乙烯', 'PVC'): 'v', ('线材', '钢线', '线钢'): 'wr', ('豆油',): 'y', ('锌',): 'zn', ('瓶片', 'PET'): 'PR', ('原木',): 'lg', ('多晶硅',): 'ps', ('铝合金', '铸造铝合金'): 'ad', ('纯苯',): 'bz', ('丙烯',): 'PL'}
add
add
add al,cu 铝,铜
add al,pb 铝,铅
add zn 锌
add al,ao,ad 铝,氧化铝,铝合金
add SF,SM 硅铁,锰硅
add al,sn 铝,锡
add i,ni,ss 铁矿石,镍,不锈钢
add jd 鸡蛋
=========================================================================
2025-08-20 17:50:16 Wed START TASK.01 hibor_data update_data
=========================================================================
PAGE 1*********************************************************
skip article: 国金期货-玉米淀粉期货周报
skip article: 国金期货-棕榈油货周报：利多影响，期价破位上行
skip article: 银河期货-鸡蛋日报
skip article: 国金期货-氧化铝期货日报
skip article: 南华期货-锌风险管理报告
skip article: 华鑫期货-豆粕专题报告：USDA8月供需报告意外利多，豆粕强势上涨
skip article: 银河期货-白糖日报
skip article: 银河期货-苹果日报
skip article: 银河期货-棉花、棉纱日报
skip article: 银河期货-燃料油日报
skip article: 银河期货-沥青日报
skip article: 宝城期货-钢材&铁矿石日报：市场情绪切换，钢矿延续震荡
skip article: 宝城期货-焦炭，高位整理
skip article: 宝城期货-橡胶甲醇原油日报：偏空情绪消化，能化收敛跌幅
skip article: 宝城期货-煤焦日报：观望情绪增加，煤焦高位回调
skip article: 宝城期货-有色日报：有色延续弱势
skip article: 宝城期货-钢联15港港口进口矿库存
skip article: 宝城期货-国债期货日报：国债期货震荡偏弱
skip article: 瑞达期货-焦煤焦炭产业日报
skip article: 瑞达期货-铝类产业日报
PAGE 2*********************************************************
skip article: 瑞达期货-焦煤焦炭产业日报
skip article: 瑞达期货-铝类产业日报
skip article: 瑞达期货-玉米系产业日报
skip article: 瑞达期货-沪铅产业日报
skip article: 瑞达期货-沪镍产业日报
skip article: 瑞达期货-苹果产业日报
skip article: 瑞达期货-纯碱玻璃产业日报
skip article: 瑞达期货-沪铜产业日报
skip article: 瑞达期货-菜籽系产业日报
skip article: 瑞达期货-鸡蛋产业日报
skip article: 瑞达期货-贵金属产业日报
skip article: 瑞达期货-集运指数（欧线）期货日报
skip article: 瑞达期货-锰硅硅铁产业日报
skip article: 瑞达期货-国债期货日报
skip article: 瑞达期货-不锈钢产业日报
skip article: 瑞达期货-PVC产业日报
skip article: 瑞达期货-塑料产业日报
skip article: 瑞达期货-多晶硅产业日报
skip article: 瑞达期货-天然橡胶产业日报
skip article: 瑞达期货-沪锌产业日报
PAGE 3*********************************************************
skip article: 瑞达期货-天然橡胶产业日报
skip article: 瑞达期货-沪锌产业日报
skip article: 瑞达期货-工业硅产业日报
skip article: 瑞达期货-尿素产业日报
skip article: 瑞达期货-棉花（纱）产业日报
skip article: 瑞达期货-沪锡产业日报
skip article: 瑞达期货-生猪产业日报
skip article: 瑞达期货-烧碱产业日报
skip article: 瑞达期货-纯苯产业日报
skip article: 瑞达期货-苯乙烯产业日报
skip article: 瑞达期货-红枣产业日报
skip article: 瑞达期货-碳酸锂产业日报
skip article: 瑞达期货-白糖产业日报
skip article: 瑞达期货-甲醇产业日报
skip article: 银河期货-锌专题：SMM锌业大会现场调研报告及会议纪要
skip article: 瑞达期货-合成橡胶产业日报
skip article: 银河期货-贵金属衍生品日报
skip article: 银河期货-贵金属衍生品日报
skip article: 银河期货-贵金属衍生品日报
skip article: 银河期货-有色和贵金属每日早盘观察
PAGE 4*********************************************************
skip article: 银河期货-有色和贵金属每日早盘观察
skip article: 银河期货-有色和贵金属每日早盘观察
skip article: 银河期货-有色和贵金属每日早盘观察
skip article: 通惠期货-纯苯&苯乙烯日报：纯苯供需趋紧或支撑价稳，苯乙烯承压难改弱势
skip article: 通惠期货-原油、燃料油日报：地缘缓和持续施压油价，关注俄乌首脑会谈
skip article: 浙商期货-库存超季节性回升，沪锌延续弱势震荡
skip article: 国投期货-能源&航运策略周观察：2025年度·第19期
skip article: 南华期货-早评
skip article: 南华期货-玻璃纯碱产业风险管理日报
skip article: 南华期货-聚酯产业风险管理日报：旺季预期初现端倪，下方支撑较强
skip article: 南华期货-铅风险管理报告
skip article: 紫金天风期货-聚酯周报：估值不高，博弈弹性
skip article: 紫金天风期货-甲醇周报：宏观转弱回归现实
skip article: 国富期货-【早间看点】Pro Farmer作物巡回调查已开启，25/26年巴西大豆种植面积或增1.2%至2.9%
skip article: 国贸期货-航运衍生品数据日报
skip article: 国贸期货-瓶片短纤数据日报
skip article: 国贸期货-宏观金融数据日报
skip article: 国贸期货-纸浆数据日报
skip article: 国贸期货-黑色金属数据日报
skip article: 国富期货-【国富期货早间看点】SPPOMA马棕8月前15日产量增0.88%，美豆当周优良率为68%高于预期
PAGE 5*********************************************************
skip article: 国富期货-【国富期货早间看点】SPPOMA马棕8月前15日产量增0.88%，美豆当周优良率为68%高于预期
skip article: 国贸期货-聚酯数据日报
skip article: 国贸期货-蛋白数据日报
skip article: 国贸期货-贵金属数据日报
skip article: 国贸期货-白糖数据日报
skip article: 中泰期货-原木周报
skip article: 迈科期货-早评：菜系供应端收紧
skip article: 紫金天风期货-油脂周报：供应端和政策端驱动
skip article: 紫金天风期货-镍&不锈钢周报：水波不惊
skip article: 中信期货-金融衍生品策略日报：股市震荡消化，债市持续调整
skip article: 紫金天风期货-铜周报：还有机会吗？
skip article: 紫金天风期货-碳酸锂周报：雾里看花
skip article: 迈科期货-聚酯原料早评：美俄谈判倾向结束战争，聚酯链条价格震荡偏空看待
skip article: 迈科期货-能源品早评：市场充分交易美俄谈判，短期大幅下行风险有限
skip article: 中信期货-能源列国志：南非
skip article: 迈科期货-早评：宜春银锂即将复产，但矿端报价仍强
skip article: 迈科期货-早评：煤矿开始累库，关注海运煤进口情况
skip article: 迈科期货-LPG早评：成本端下跌，短期震荡运行
skip article: 迈科期货-锌早评：国内外锌价区间震荡
skip article: 迈科期货-早评：弱势运行
PAGE 6*********************************************************
skip article: 迈科期货-早评：弱势运行
skip article: 迈科期货-油脂早评：获利了结
skip article: 迈科期货-黑色金属早评：基本面不佳，黑色延续弱势运行
skip article: 迈科期货-生猪早评：窄幅波动
skip article: 中辉期货-农产品观点
skip article: 银河期货-金融衍生品日报
skip article: 格林大华期货-焦煤期货近期行业政策与期货风险管控措施总结
skip article: 银河期货-国债期货持仓日报
>>>>>>>>> add to db: 国泰君安期货-股指期货将震荡整理，焦煤、玻璃、纯碱期货将震荡偏弱，工业硅、多晶硅、碳酸锂期货将偏弱宽幅震荡，黄金、白银、螺纹钢、铁矿石、豆粕、豆油期货将偏弱震荡
skip article: 国投期货-综合晨报
skip article: 南华期货-纯苯~苯乙烯风险管理日报
skip article: 南华期货-生猪企业风险管理日报
skip article: 南华期货-棉花产业风险管理日报
skip article: 南华期货-油料产业风险管理日报
skip article: 南华期货-锡风险管理日报
skip article: 南华期货-丙烯产业风险管理日报
skip article: 南华期货-贵金属日报：聚焦全球央行年会，贵金属偏弱整理
skip article: 南华期货-镍&不锈钢风险管理日报：持续回调涨幅，基本面支撑仍存
skip article: 南华期货-铝产业链风险管理报告
skip article: 南华期货-铜风险管理日报
PAGE 7*********************************************************
skip article: 南华期货-铜风险管理日报
skip article: 南华期货-LPG产业风险管理日报
skip article: 华宝期货-煤焦晨报：盘面震荡回调，关注环保限产落地
skip article: 华宝期货-铝锭晨报：淡季氛围持续，铝价区间调整
skip article: 华宝期货-铁矿石：供给增速超预期，短期矿价跟随运行
skip article: 申银万国期货-品种策略日报~聚烯烃
skip article: 申银万国期货-品种策略日报：国债
skip article: 申银万国期货-品种策略日报：油脂油料
skip article: 申银万国期货-首席点评：财政拐点与养老新政助力，A股生态迎来“慢牛”新起点
skip article: 中辉期货-有色观点
skip article: 华宝期货-成材晨报：弱需求下，钢价回调
skip article: 中辉期货-能化观点
skip article: 中辉期货-黑色观点
skip article: 中信期货-农业策略日报：基差或见底回升，豆粕正套机会可期
skip article: 中信期货-有色每日报告：需求逐步走弱，基本金属震荡承压
skip article: 华鑫期货-每日晨报
skip article: 中信期货-新能源金属每日报告：供应扰动风险仍存，新能源金属整体延续强势
skip article: 中信期货-能源列国志：刚果
skip article: 中信期货-晨报：国内商品期货多数下跌，黑色系普遍下跌
skip article: 中信期货-中国期货每日简报
PAGE 8*********************************************************
skip article: 中信期货-能源化工策略日报：原油和煤炭价格双双走弱，成本端拖累化工
skip article: 格林大华期货-市场快讯：复产叠加改运消息缓解供应紧张预期，碳酸锂价格大幅下调
skip article: 格林大华期货-市场快讯：红枣被美列入所谓重点执法对象
skip article: 中信期货-金融衍生品策略日报：股市震荡消化，债市情绪回暖
skip article: 中信期货-贵金属策略日报：经济数据良莠不齐，黄金延续震荡
skip article: 中信期货-黑色建材策略日报：需求预期偏弱，价格承压运行
===exist in db, skip aritcle: 国泰君安期货-欧盟碳市场行情简报（2025年第147期）===
===exist in db, skip aritcle: 国泰君安期货-全国碳市场行情简报（2025年第140期）===
skip article: 新世纪期货-集运日报：停火消息对盘面影响有限，近期波动较大，不建议继续加仓，设置好止损
===exist in db, skip aritcle: 国泰君安期货-铜：美元回升，价格承压===
{('苹果',): 'AP', ('一号棉花', '棉花'): 'CF', ('红枣', '枣'): 'CJ', ('棉纱', '纱线'): 'CY', ('玻璃',): 'FG', ('中证500指数', '中证500', '500指数'): 'IC', ('沪深300指数', '沪深300', '300指数'): 'IF', ('上证50指数', '上证50', '50指数'): 'IH', ('中证1000指数', '中证1000', '1000指数'): 'IM', ('粳稻', '北方稻'): 'JR', ('晚籼稻', '晚稻', '晚籼'): 'LR', ('甲醇N', '甲醇', '木醇', '工业酒精', '羟基甲烷'): 'MA', ('菜籽油', '食用油', '菜油'): 'OI', ('短纤', 'PF'): 'PF', ('花生仁', '花生'): 'PK', ('普通小麦', '普麦', '普通麦'): 'PM', ('对二甲苯', 'PX'): 'PX', ('早籼稻', '早稻', '早籼'): 'RI', ('菜籽粕', '菜粕', '饲料粕'): 'RM', ('油菜籽', '油籽', '菜籽'): 'RS', ('纯碱', '碳酸钠', '轻碱'): 'SA', ('硅铁',): 'SF', ('烧碱', '氢氧化钠', '片碱'): 'SH', ('锰硅', '硅锰合金'): 'SM', ('白砂糖', '食糖', '砂糖', '白糖'): 'SR', ('10年期国债期货', '10年期国债', '10年期债', '10年期'): 'T', ('精对苯二甲酸', '对苯酸', 'PTA'): 'TA', ('5年期国债期货', '5年期国债', '5年期债', '5年期'): 'TF', ('30年期国债期货', '30年期国债', '30年期债', '30年期'): 'TL', ('2年期国债期货', '2年期国债', '2年期债', '2年期'): 'TS', ('尿素',): 'UR', ('优质强筋小麦', '强筋麦', '高筋小麦', '强麦'): 'WH', ('动力煤N', '电煤', '动力煤'): 'ZC', ('黄大豆1号', '豆1', '豆一'): 'a', ('白银',): 'ag', ('铝',): 'al', ('氧化铝', '铝氧', '工业氧化铝'): 'ao', ('黄金',): 'au', ('黄大豆2号', '豆2', '豆二'): 'b', ('胶合板', '人造板', '胶板'): 'bb', ('国际铜', '铜（BC）', '铜(BC)'): 'bc', ('丁二烯橡胶', '合成橡胶', '丁二烯', '顺丁橡胶'): 'br', ('石油沥青', '沥青'): 'bu', ('黄玉米', '玉米'): 'c', ('玉米淀粉', '淀粉'): 'cs', ('铜',): 'cu', ('苯乙烯', '乙烯基苯'): 'eb', ('SCFIS欧线', '欧线', '集运', '集装', '欧洲航线'): 'ec', ('乙二醇', 'MEG'): 'eg', ('纤维板', '密度板'): 'fb', ('燃料油', '船用燃料', '燃油'): 'fu', ('热轧卷板', '热卷', '钢卷'): 'hc', ('铁矿石', '矿石', '铁矿'): 'i', ('冶金焦炭', '焦炭'): 'j', ('鸡蛋', '蛋'): 'jd', ('焦煤', '煤焦'): 'jm', ('线型低密度聚乙烯', '聚乙烯', '低密度聚乙烯', 'LLDPE'): 'l', ('碳酸锂', '锂盐'): 'lc', ('生猪', '猪'): 'lh', ('低硫燃料油', '低硫油', '船用油'): 'lu', ('豆粕', '饲料粕'): 'm', ('镍',): 'ni', ('20号胶', 'TSR20'): 'nr', ('棕榈油', '棕油'): 'p', ('铅',): 'pb', ('液化石油气', 'LPG', '瓶装气'): 'pg', ('聚丙烯', 'PP', '塑料原料'): 'pp', ('螺纹钢', '螺纹', '钢筋'): 'rb', ('粳米',): 'rr', ('天然橡胶', '天胶'): 'ru', ('原油', '石油'): 'sc', ('工业硅', '冶金硅'): 'si', ('锡',): 'sn', ('漂针浆', '纸浆', '针叶浆'): 'sp', ('不锈钢', '钢材'): 'ss', ('聚氯乙烯', 'PVC'): 'v', ('线材', '钢线', '线钢'): 'wr', ('豆油',): 'y', ('锌',): 'zn', ('瓶片', 'PET'): 'PR', ('原木',): 'lg', ('多晶硅',): 'ps', ('铝合金', '铸造铝合金'): 'ad', ('纯苯',): 'bz', ('丙烯',): 'PL'}
add FG,MA,SA,TA,ag,al,ao,au,cu,hc,i,jm,lc,m,p,rb,ru,si,v,y,ps 玻璃,甲醇N,纯碱,精对苯二甲酸,白银,铝,氧化铝,黄金,铜,热轧卷板,铁矿石,焦煤,碳酸锂,豆粕,棕榈油,螺纹钢,天然橡胶,工业硅,聚氯乙烯,豆油,多晶硅