Comments (3)
苹果的M系列芯片采用ARM架构,而 PyMiniRacer 并没有编译相对应的版本。下载编译好的文件:libmini_racer.dylib
1.只需要把该文件下载到本地,然后存放在报错提示的路径即可,
2.如果你使用的是 macOS 系统自带的 Python,则这个路径一般是 /Users//Library/Python/<python_version>/lib/python/site-packages/py_mini_racer, 具体可以找到自己机器 Python 第三方包的下载路径。
from stock.
数据处理报错:
2024-07-03 19:04:37,043 ######## 任务执行时间: 2024-07-03 19:04:37.043564 #######
2024-07-03 19:05:15,655 database.insert_other_db_from_df处理异常:cn_stock_fund_flow表(pymysql.err.OperationalError) (1054, "Unknown column 'change_rate_3' in 'field list'")
[SQL: INSERT INTO cn_stock_fund_flow (date, code, name, new_price, change_rate, fund_amount, fund_rate, fund_amount_super, fund_rate_super, fund_amount_large, fund_rate_large, fund_amount_medium, fund_rate_medium, fund_amount_small, fund_rate_small, change_rate_3, fund_amount_3, fund_rate_3, fund_amount_super_3, fund_rate_super_3, fund_amount_large_3, fund_rate_large_3, fund_amount_medium_3, fund_rate_medium_3, fund_amount_small_3, fund_rate_small_3, change_rate_5, fund_amount_5, fund_rate_5, fund_amount_super_5, fund_rate_super_5, fund_amount_large_5, fund_rate_large_5, fund_amount_medium_5, fund_rate_medium_5, fund_amount_small_5, fund_rate_small_5, change_rate_10, fund_amount_10, fund_rate_10, fund_amount_super_10, fund_rate_super_10, fund_amount_large_10, fund_rate_large_10, fund_amount_medium_10, fund_rate_medium_10, fund_amount_small_10, fund_rate_small_10) VALUES (%(date)s, %(code)s, %(name)s, %(new_price)s, %(change_rate)s, %(fund_amount)s, %(fund_rate)s, %(fund_amount_super)s, %(fund_rate_super)s, %(fund_amount_large)s, %(fund_rate_large)s, %(fund_amount_medium)s, %(fund_rate_medium)s, %(fund_amount_small)s, %(fund_rate_small)s, %(change_rate_3)s, %(fund_amount_3)s, %(fund_rate_3)s, %(fund_amount_super_3)s, %(fund_rate_super_3)s, %(fund_amount_large_3)s, %(fund_rate_large_3)s, %(fund_amount_medium_3)s, %(fund_rate_medium_3)s, %(fund_amount_small_3)s, %(fund_rate_small_3)s, %(change_rate_5)s, %(fund_amount_5)s, %(fund_rate_5)s, %(fund_amount_super_5)s, %(fund_rate_super_5)s, %(fund_amount_large_5)s, %(fund_rate_large_5)s, %(fund_amount_medium_5)s, %(fund_rate_medium_5)s, %(fund_amount_small_5)s, %(fund_rate_small_5)s, %(change_rate_10)s, %(fund_amount_10)s, %(fund_rate_10)s, %(fund_amount_super_10)s, %(fund_rate_super_10)s, %(fund_amount_large_10)s, %(fund_rate_large_10)s, %(fund_amount_medium_10)s, %(fund_rate_medium_10)s, %(fund_amount_small_10)s, %(fund_rate_small_10)s)]
[parameters: [{'date': '2024-07-03', 'code': '601888', 'name': '**中免', 'new_price': 67.98, 'change_rate': 9.98, 'fund_amount': 591347616.0, 'fund_rate': 13.42, 'fund_amount_super': 409197904.0, 'fund_rate_super': 9.29, 'fund_amount_large': 182149712.0, 'fund_rate_large': 4.13, 'fund_amount_medium': -189779728.0, 'fund_rate_medium': -4.31, 'fund_amount_small': -401567888.0, 'fund_rate_small': -9.11, 'change_rate_3': 8.79, 'fund_amount_3': 593778010.0, 'fund_rate_3': 9.92, 'fund_amount_super_3': 424159986.0, 'fund_rate_super_3': 7.09, 'fund_amount_large_3': 169618024.0, 'fund_rate_large_3': 2.83, 'fund_amount_medium_3': -190143879.0, 'fund_rate_medium_3': -3.18, 'fund_amount_small_3': -403634129.0, 'fund_rate_small_3': -6.75, 'change_rate_5': 5.54, 'fund_amount_5': 486412828.0, 'fund_rate_5': 6.32, 'fund_amount_super_5': 355668927.0, 'fund_rate_super_5': 4.62, 'fund_amount_large_5': 130743901.0, 'fund_rate_large_5': 1.7, 'fund_amount_medium_5': -204168075.0, 'fund_rate_medium_5': -2.65, 'fund_amount_small_5': -282244736.0, 'fund_rate_small_5': -3.67, 'change_rate_10': 0.7, 'fund_amount_10': -160252310.0, 'fund_rate_10': -1.21, 'fund_amount_super_10': 76921995.0, 'fund_rate_super_10': 0.58, 'fund_amount_large_10': -237174305.0, 'fund_rate_large_10': -1.79, 'fund_amount_medium_10': -75054267.0, 'fund_rate_medium_10': -0.57, 'fund_amount_small_10': 235306583.0, 'fund_rate_small_10': 1.78}, {'date': '2024-07-03', 'code': '600519', 'name': '贵州茅台', 'new_price': 1500.0, 'change_rate': 0.62, 'fund_amount': 542393936.0, 'fund_rate': 11.44, 'fund_amount_super': 101385936.0, 'fund_rate_super': 2.14, 'fund_amount_large': 441008000.0, 'fund_rate_large': 9.3, 'fund_amount_medium': -542235856.0, 'fund_rate_medium': -11.44, 'fund_amount_small': -158081.0, 'fund_rate_small': 0.0, 'change_rate_3': 2.22, 'fund_amount_3': 721869120.0, 'fund_rate_3': 4.24, 'fund_amount_super_3': 638485664.0, 'fund_rate_super_3': 3.75, 'fund_amount_large_3': 83383456.0, 'fund_rate_large_3': 0.49, 'fund_amount_medium_3': -721208096.0, 'fund_rate_medium_3': -4.23, 'fund_amount_small_3': -661042.0, 'fund_rate_small_3': 0.0, 'change_rate_5': 0.72, 'fund_amount_5': 1088983008.0, 'fund_rate_5': 3.95, 'fund_amount_super_5': 454481168.0, 'fund_rate_super_5': 1.65, 'fund_amount_large_5': 634501840.0, 'fund_rate_large_5': 2.3, 'fund_amount_medium_5': -1087870000.0, 'fund_rate_medium_5': -3.94, 'fund_amount_small_5': -1113037.0, 'fund_rate_small_5': 0.0, 'change_rate_10': -0.07, 'fund_amount_10': 810650256.0, 'fund_rate_10': 1.4, 'fund_amount_super_10': 855176864.0, 'fund_rate_super_10': 1.48, 'fund_amount_large_10': -44526608.0, 'fund_rate_large_10': -0.08, 'fund_amount_medium_10': -795816320.0, 'fund_rate_medium_10': -1.38, 'fund_amount_small_10': -14833961.0, 'fund_rate_small_10': -0.03}, {'date': '2024-07-03', 'code': '600276', 'name': '恒瑞医药', 'new_price': 38.67, 'change_rate': 3.2, 'fund_amount': 375577060.0, 'fund_rate': 17.57, 'fund_amount_super': 169004868.0, 'fund_rate_super': 7.91, 'fund_amount_large': 206572192.0, 'fund_rate_large': 9.66, 'fund_amount_medium': -112153792.0, 'fund_rate_medium': -5.25, 'fund_amount_small': -263423264.0, 'fund_rate_small': -12.32, 'change_rate_3': 0.55, 'fund_amount_3': 297208316.0, 'fund_rate_3': 7.05, 'fund_amount_super_3': 161000532.0, 'fund_rate_super_3': 3.82, 'fund_amount_large_3': 136207784.0, 'fund_rate_large_3': 3.23, 'fund_amount_medium_3': -211851200.0, 'fund_rate_medium_3': -5.02, 'fund_amount_small_3': -85357136.0, 'fund_rate_small_3': -2.02, 'change_rate_5': -3.08, 'fund_amount_5': 117733982.0, 'fund_rate_5': 1.82, 'fund_amount_super_5': 20809706.0, 'fund_rate_super_5': 0.32, 'fund_amount_large_5': 96924276.0, 'fund_rate_large_5': 1.5, 'fund_amount_medium_5': -197533152.0, 'fund_rate_medium_5': -3.05, 'fund_amount_small_5': 79799168.0, 'fund_rate_small_5': 1.23, 'change_rate_10': -6.5, 'fund_amount_10': 142721377.0, 'fund_rate_10': 1.2, 'fund_amount_super_10': 45360819.0, 'fund_rate_super_10': 0.38, 'fund_amount_large_10': 97360558.0, 'fund_rate_large_10': 0.82, 'fund_amount_medium_10': -126219883.0, 'fund_rate_medium_10': -1.06, 'fund_amount_small_10': -16501456.0, 'fund_rate_small_10': -0.14}, {'date': '2024-07-03', 'code': '000625', 'name': '长安汽车', 'new_price': 13.89, 'change_rate': 1.91, 'fund_amount': 244484911.0, 'fund_rate': 13.28, 'fund_amount_super': 161983887.0, 'fund_rate_super': 8.8, 'fund_amount_large': 82501024.0, 'fund_rate_large': 4.48, 'fund_amount_medium': -101030704.0, 'fund_rate_medium': -5.49, 'fund_amount_small': -143454208.0, 'fund_rate_small': -7.79, 'change_rate_3': 3.43, 'fund_amount_3': 210150531.0, 'fund_rate_3': 4.44, 'fund_amount_super_3': 82614947.0, 'fund_rate_super_3': 1.75, 'fund_amount_large_3': 127535584.0, 'fund_rate_large_3': 2.69, 'fund_amount_medium_3': -108614512.0, 'fund_rate_medium_3': -2.29, 'fund_amount_small_3': -101535984.0, 'fund_rate_small_3': -2.14, 'change_rate_5': 2.36, 'fund_amount_5': 201443256.0, 'fund_rate_5': 2.86, 'fund_amount_super_5': 104445508.0, 'fund_rate_super_5': 1.48, 'fund_amount_large_5': 96997748.0, 'fund_rate_large_5': 1.38, 'fund_amount_medium_5': -168346560.0, 'fund_rate_medium_5': -2.39, 'fund_amount_small_5': -33096640.0, 'fund_rate_small_5': -0.47, 'change_rate_10': -1.56, 'fund_amount_10': -336212360.0, 'fund_rate_10': -2.3, 'fund_amount_super_10': -237772940.0, 'fund_rate_super_10': -1.62, 'fund_amount_large_10': -98439420.0, 'fund_rate_large_10': -0.67, 'fund_amount_medium_10': -227501248.0, 'fund_rate_medium_10': -1.55, 'fund_amount_small_10': 563713648.0, 'fund_rate_small_10': 3.85}, {'date': '2024-07-03', 'code': '600418', 'name': '江淮汽车', 'new_price': 16.77, 'change_rate': 1.7, 'fund_amount': 242800960.0, 'fund_rate': 11.93, 'fund_amount_super': 174971344.0, 'fund_rate_super': 8.6, 'fund_amount_large': 67829616.0, 'fund_rate_large': 3.33, 'fund_amount_medium': -36803184.0, 'fund_rate_medium': -1.81, 'fund_amount_small': -205997776.0, 'fund_rate_small': -10.12, 'change_rate_3': 5.87, 'fund_amount_3': 369682697.0, 'fund_rate_3': 7.54, 'fund_amount_super_3': 225811417.0, 'fund_rate_super_3': 4.6, 'fund_amount_large_3': 143871280.0, 'fund_rate_large_3': 2.93, 'fund_amount_medium_3': -95264480.0, 'fund_rate_medium_3': -1.94, 'fund_amount_small_3': -274418224.0, 'fund_rate_small_3': -5.59, 'change_rate_5': 5.67, 'fund_amount_5': 431657148.0, 'fund_rate_5': 6.15, 'fund_amount_super_5': 248813374.0, 'fund_rate_super_5': 3.55, 'fund_amount_large_5': 182843774.0, 'fund_rate_large_5': 2.61, 'fund_amount_medium_5': -89778824.0, 'fund_rate_medium_5': -1.28, 'fund_amount_small_5': -341878316.0, 'fund_rate_small_5': -4.87, 'change_rate_10': 1.27, 'fund_amount_10': 113360946.0, 'fund_rate_10': 0.88, 'fund_amount_super_10': -30793219.0, 'fund_rate_super_10': -0.24, 'fund_amount_large_10': 144154165.0, 'fund_rate_large_10': 1.12, 'fund_amount_medium_10': -59214344.0, 'fund_rate_medium_10': -0.46, 'fund_amount_small_10': -54146627.0, 'fund_rate_small_10': -0.42}, {'date': '2024-07-03', 'code': '603350', 'name': 'N安乃达', 'new_price': 41.19, 'change_rate': 100.34, 'fund_amount': 207607986.0, 'fund_rate': 22.35, 'fund_amount_super': 48329744.0, 'fund_rate_super': 5.2, 'fund_amount_large': 159278242.0, 'fund_rate_large': 17.14, 'fund_amount_medium': 328255963.0, 'fund_rate_medium': 35.33, 'fund_amount_small': -535863952.0, 'fund_rate_small': -57.68, 'change_rate_3': 100.34, 'fund_amount_3': 207607986.0, 'fund_rate_3': 22.35, 'fund_amount_super_3': 48329744.0, 'fund_rate_super_3': 5.2, 'fund_amount_large_3': 159278242.0, 'fund_rate_large_3': 17.14, 'fund_amount_medium_3': 328255963.0, 'fund_rate_medium_3': 35.33, 'fund_amount_small_3': -535863952.0, 'fund_rate_small_3': -57.68, 'change_rate_5': 100.34, 'fund_amount_5': 207607986.0, 'fund_rate_5': 22.35, 'fund_amount_super_5': 48329744.0, 'fund_rate_super_5': 5.2, 'fund_amount_large_5': 159278242.0, 'fund_rate_large_5': 17.14, 'fund_amount_medium_5': 328255963.0, 'fund_rate_medium_5': 35.33, 'fund_amount_small_5': -535863952.0, 'fund_rate_small_5': -57.68, 'change_rate_10': 100.34, 'fund_amount_10': 207607986.0, 'fund_rate_10': 22.35, 'fund_amount_super_10': 48329744.0, 'fund_rate_super_10': 5.2, 'fund_amount_large_10': 159278242.0, 'fund_rate_large_10': 17.14, 'fund_amount_medium_10': 328255963.0, 'fund_rate_medium_10': 35.33, 'fund_amount_small_10': -535863952.0, 'fund_rate_small_10': -57.68}, {'date': '2024-07-03', 'code': '601899', 'name': '紫金矿业', 'new_price': 17.89, 'change_rate': 0.28, 'fund_amount': 197921873.0, 'fund_rate': 10.68, 'fund_amount_super': 149071841.0, 'fund_rate_super': 8.04, 'fund_amount_large': 48850032.0, 'fund_rate_large': 2.64, 'fund_amount_medium': -65902256.0, 'fund_rate_medium': -3.56, 'fund_amount_small': -132019616.0, 'fund_rate_small': -7.12, 'change_rate_3': 1.82, 'fund_amount_3': 494179231.0, 'fund_rate_3': 7.93, 'fund_amount_super_3': 241635103.0, 'fund_rate_super_3': 3.88, 'fund_amount_large_3': 252544128.0, 'fund_rate_large_3': 4.05, 'fund_amount_medium_3': -147751104.0, 'fund_rate_medium_3': -2.37, 'fund_amount_small_3': -346428112.0, 'fund_rate_small_3': -5.56, 'change_rate_5': 3.65, 'fund_amount_5': 381035423.0, 'fund_rate_5': 3.74, 'fund_amount_super_5': 112422319.0, 'fund_rate_super_5': 1.1, 'fund_amount_large_5': 268613104.0, 'fund_rate_large_5': 2.64, 'fund_amount_medium_5': -44156416.0, 'fund_rate_medium_5': -0.43, 'fund_amount_small_5': -336879008.0, 'fund_rate_small_5': -3.31, 'change_rate_10': 3.29, 'fund_amount_10': 145888665.0, 'fund_rate_10': 0.7, 'fund_amount_super_10': 36850777.0, 'fund_rate_super_10': 0.18, 'fund_amount_large_10': 109037888.0, 'fund_rate_large_10': 0.52, 'fund_amount_medium_10': 415563536.0, 'fund_rate_medium_10': 2.0, 'fund_amount_small_10': -561452240.0, 'fund_rate_small_10': -2.7}, {'date': '2024-07-03', 'code': '601766', 'name': '**中车', 'new_price': 7.74, 'change_rate': 0.91, 'fund_amount': 195692242.0, 'fund_rate': 17.39, 'fund_amount_super': 75518674.0, 'fund_rate_super': 6.71, 'fund_amount_large': 120173568.0, 'fund_rate_large': 10.68, 'fund_amount_medium': -89501217.0, 'fund_rate_medium': -7.96, 'fund_amount_small': -106191026.0, 'fund_rate_small': -9.44, 'change_rate_3': 3.06, 'fund_amount_3': 261010628.0, 'fund_rate_3': 7.28, 'fund_amount_super_3': 36674900.0, 'fund_rate_super_3': 1.02, 'fund_amount_large_3': 224335728.0, 'fund_rate_large_3': 6.26, 'fund_amount_medium_3': -182207169.0, 'fund_rate_medium_3': -5.08, 'fund_amount_small_3': -78803474.0, 'fund_rate_small_3': -2.2, 'change_rate_5': 7.5, 'fund_amount_5': 300979991.0, 'fund_rate_5': 4.73, 'fund_amount_super_5': 8555944.0, 'fund_rate_super_5': 0.13, 'fund_amount_large_5': 292424047.0, 'fund_rate_large_5': 4.59, 'fund_amount_medium_5': -180831327.0, 'fund_rate_medium_5': -2.84, 'fund_amount_small_5': -120148669.0, 'fund_rate_small_5': -1.89, 'change_rate_10': 9.17, 'fund_amount_10': 302516663.0, 'fund_rate_10': 2.81, 'fund_amount_super_10': 2281206.0, 'fund_rate_super_10': 0.02, 'fund_amount_large_10': 300235457.0, 'fund_rate_large_10': 2.79, 'fund_amount_medium_10': -160641312.0, 'fund_rate_medium_10': -1.49, 'fund_amount_small_10': -141875381.0, 'fund_rate_small_10': -1.32} ... displaying 10 of 4512 total bound parameter sets ... {'date': '2024-07-03', 'code': '600733', 'name': '北汽蓝谷', 'new_price': 8.67, 'change_rate': -2.36, 'fund_amount': -232360572.0, 'fund_rate': -10.34, 'fund_amount_super': -149755580.0, 'fund_rate_super': -6.67, 'fund_amount_large': -82604992.0, 'fund_rate_large': -3.68, 'fund_amount_medium': 103212496.0, 'fund_rate_medium': 4.59, 'fund_amount_small': 129148096.0, 'fund_rate_small': 5.75, 'change_rate_3': 7.3, 'fund_amount_3': -225999116.0, 'fund_rate_3': -2.22, 'fund_amount_super_3': -99078700.0, 'fund_rate_super_3': -0.97, 'fund_amount_large_3': -126920416.0, 'fund_rate_large_3': -1.25, 'fund_amount_medium_3': 102768464.0, 'fund_rate_medium_3': 1.01, 'fund_amount_small_3': 123230656.0, 'fund_rate_small_3': 1.21, 'change_rate_5': 12.89, 'fund_amount_5': -91972352.0, 'fund_rate_5': -0.63, 'fund_amount_super_5': 4088160.0, 'fund_rate_super_5': 0.03, 'fund_amount_large_5': -96060512.0, 'fund_rate_large_5': -0.66, 'fund_amount_medium_5': 73016992.0, 'fund_rate_medium_5': 0.5, 'fund_amount_small_5': 18955376.0, 'fund_rate_small_5': 0.13, 'change_rate_10': 13.04, 'fund_amount_10': -325383632.0, 'fund_rate_10': -1.25, 'fund_amount_super_10': -341271696.0, 'fund_rate_super_10': -1.31, 'fund_amount_large_10': 15888064.0, 'fund_rate_large_10': 0.06, 'fund_amount_medium_10': 91315984.0, 'fund_rate_medium_10': 0.35, 'fund_amount_small_10': 234067664.0, 'fund_rate_small_10': 0.9}, {'date': '2024-07-03', 'code': '300059', 'name': '东方财富', 'new_price': 10.26, 'change_rate': -0.1, 'fund_amount': -253414848.0, 'fund_rate': -9.16, 'fund_amount_super': -133465248.0, 'fund_rate_super': -4.82, 'fund_amount_large': -119949600.0, 'fund_rate_large': -4.33, 'fund_amount_medium': 48497872.0, 'fund_rate_medium': 1.75, 'fund_amount_small': 204916960.0, 'fund_rate_small': 7.4, 'change_rate_3': -2.84, 'fund_amount_3': -839887424.0, 'fund_rate_3': -11.05, 'fund_amount_super_3': -534586144.0, 'fund_rate_super_3': -7.04, 'fund_amount_large_3': -305301280.0, 'fund_rate_large_3': -4.02, 'fund_amount_medium_3': 86662224.0, 'fund_rate_medium_3': 1.14, 'fund_amount_small_3': 753225216.0, 'fund_rate_small_3': 9.91, 'change_rate_5': -12.23, 'fund_amount_5': -1768308469.0, 'fund_rate_5': -13.0, 'fund_amount_super_5': -1132073173.0, 'fund_rate_super_5': -8.32, 'fund_amount_large_5': -636235296.0, 'fund_rate_large_5': -4.68, 'fund_amount_medium_5': 287819056.0, 'fund_rate_medium_5': 2.12, 'fund_amount_small_5': 1480489447.0, 'fund_rate_small_5': 10.89, 'change_rate_10': -15.83, 'fund_amount_10': -2759854680.0, 'fund_rate_10': -12.98, 'fund_amount_super_10': -1622646824.0, 'fund_rate_super_10': -7.63, 'fund_amount_large_10': -1137207856.0, 'fund_rate_large_10': -5.35, 'fund_amount_medium_10': 597527392.0, 'fund_rate_medium_10': 2.81, 'fund_amount_small_10': 2162327271.0, 'fund_rate_small_10': 10.17}]]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2024-07-03 19:05:20,558 database.insert_other_db_from_df处理异常:cn_stock_fund_flow_industry表(pymysql.err.OperationalError) (1054, "Unknown column 'change_rate_10' in 'field list'")
[SQL: INSERT INTO cn_stock_fund_flow_industry (date, name, change_rate, fund_amount, fund_rate, fund_amount_super, fund_rate_super, fund_amount_large, fund_rate_large, fund_amount_medium, fund_rate_medium, fund_amount_small, fund_rate_small, stock_name, change_rate_5, fund_amount_5, fund_rate_5, fund_amount_super_5, fund_rate_super_5, fund_amount_large_5, fund_rate_large_5, fund_amount_medium_5, fund_rate_medium_5, fund_amount_small_5, fund_rate_small_5, stock_name_5, change_rate_10, fund_amount_10, fund_rate_10, fund_amount_super_10, fund_rate_super_10, fund_amount_large_10, fund_rate_large_10, fund_amount_medium_10, fund_rate_medium_10, fund_amount_small_10, fund_rate_small_10, stock_name_10) VALUES (%(date)s, %(name)s, %(change_rate)s, %(fund_amount)s, %(fund_rate)s, %(fund_amount_super)s, %(fund_rate_super)s, %(fund_amount_large)s, %(fund_rate_large)s, %(fund_amount_medium)s, %(fund_rate_medium)s, %(fund_amount_small)s, %(fund_rate_small)s, %(stock_name)s, %(change_rate_5)s, %(fund_amount_5)s, %(fund_rate_5)s, %(fund_amount_super_5)s, %(fund_rate_super_5)s, %(fund_amount_large_5)s, %(fund_rate_large_5)s, %(fund_amount_medium_5)s, %(fund_rate_medium_5)s, %(fund_amount_small_5)s, %(fund_rate_small_5)s, %(stock_name_5)s, %(change_rate_10)s, %(fund_amount_10)s, %(fund_rate_10)s, %(fund_amount_super_10)s, %(fund_rate_super_10)s, %(fund_amount_large_10)s, %(fund_rate_large_10)s, %(fund_amount_medium_10)s, %(fund_rate_medium_10)s, %(fund_amount_small_10)s, %(fund_rate_small_10)s, %(stock_name_10)s)]
[parameters: [{'date': '2024-07-03', 'name': '航空机场', 'change_rate': 0.49, 'fund_amount': 92548442.0, 'fund_rate': 4.21, 'fund_amount_super': 99065482.0, 'fund_rate_super': 4.51, 'fund_amount_large': -6517040.0, 'fund_rate_large': -0.3, 'fund_amount_medium': -63900880.0, 'fund_rate_medium': -2.91, 'fund_amount_small': -28647568.0, 'fund_rate_small': -1.3, 'stock_name': '上海机场', 'change_rate_5': 2.88, 'fund_amount_5': -226325081.0, 'fund_rate_5': -1.9, 'fund_amount_super_5': -44090601.0, 'fund_rate_super_5': -0.37, 'fund_amount_large_5': -182234480.0, 'fund_rate_large_5': -1.53, 'fund_amount_medium_5': -85543920.0, 'fund_rate_medium_5': -0.72, 'fund_amount_small_5': 311868976.0, 'fund_rate_small_5': 2.61, 'stock_name_5': '上海机场', 'change_rate_10': -0.77, 'fund_amount_10': -1107673046.0, 'fund_rate_10': -4.42, 'fund_amount_super_10': -505287414.0, 'fund_rate_super_10': -2.01, 'fund_amount_large_10': -602385632.0, 'fund_rate_large_10': -2.4, 'fund_amount_medium_10': -2539248.0, 'fund_rate_medium_10': -0.01, 'fund_amount_small_10': 1110212256.0, 'fund_rate_small_10': 4.43, 'stock_name_10': '**东航'}, {'date': '2024-07-03', 'name': '铁路公路', 'change_rate': 0.0, 'fund_amount': -74251223.0, 'fund_rate': -4.34, 'fund_amount_super': -54086551.0, 'fund_rate_super': -3.16, 'fund_amount_large': -20164672.0, 'fund_rate_large': -1.18, 'fund_amount_medium': -15570304.0, 'fund_rate_medium': -0.91, 'fund_amount_small': 89821520.0, 'fund_rate_small': 5.25, 'stock_name': '海汽集团', 'change_rate_5': 2.45, 'fund_amount_5': -393149111.0, 'fund_rate_5': -5.22, 'fund_amount_super_5': -92520975.0, 'fund_rate_super_5': -1.23, 'fund_amount_large_5': -300628136.0, 'fund_rate_large_5': -3.99, 'fund_amount_medium_5': -41898368.0, 'fund_rate_medium_5': -0.56, 'fund_amount_small_5': 435047456.0, 'fund_rate_small_5': 5.78, 'stock_name_5': '宁沪高速', 'change_rate_10': 1.28, 'fund_amount_10': -417016044.0, 'fund_rate_10': -2.75, 'fund_amount_super_10': -115761336.0, 'fund_rate_super_10': -0.76, 'fund_amount_large_10': -301254708.0, 'fund_rate_large_10': -1.98, 'fund_amount_medium_10': -7851024.0, 'fund_rate_medium_10': -0.05, 'fund_amount_small_10': 424867056.0, 'fund_rate_small_10': 2.8, 'stock_name_10': '赣粤高速'}, {'date': '2024-07-03', 'name': '物流行业', 'change_rate': -0.63, 'fund_amount': -162392624.0, 'fund_rate': -3.59, 'fund_amount_super': -80417920.0, 'fund_rate_super': -1.78, 'fund_amount_large': -81974704.0, 'fund_rate_large': -1.81, 'fund_amount_medium': 9358128.0, 'fund_rate_medium': 0.21, 'fund_amount_small': 152205120.0, 'fund_rate_small': 3.37, 'stock_name': '顺丰控股', 'change_rate_5': 0.21, 'fund_amount_5': -900668048.0, 'fund_rate_5': -3.62, 'fund_amount_super_5': -515621280.0, 'fund_rate_super_5': -2.07, 'fund_amount_large_5': -385046768.0, 'fund_rate_large_5': -1.55, 'fund_amount_medium_5': 124269104.0, 'fund_rate_medium_5': 0.5, 'fund_amount_small_5': 775407088.0, 'fund_rate_small_5': 3.12, 'stock_name_5': '长江投资', 'change_rate_10': -2.35, 'fund_amount_10': -1815150721.0, 'fund_rate_10': -3.8, 'fund_amount_super_10': -939357665.0, 'fund_rate_super_10': -1.97, 'fund_amount_large_10': -875793056.0, 'fund_rate_large_10': -1.83, 'fund_amount_medium_10': 132904288.0, 'fund_rate_medium_10': 0.28, 'fund_amount_small_10': 1681533120.0, 'fund_rate_small_10': 3.52, 'stock_name_10': 'ST万林'}, {'date': '2024-07-03', 'name': '水泥建材', 'change_rate': 0.28, 'fund_amount': 11230634.0, 'fund_rate': 0.67, 'fund_amount_super': 44659786.0, 'fund_rate_super': 2.65, 'fund_amount_large': -33429152.0, 'fund_rate_large': -1.99, 'fund_amount_medium': -32675952.0, 'fund_rate_medium': -1.94, 'fund_amount_small': 21445328.0, 'fund_rate_small': 1.27, 'stock_name': '亚泰集团', 'change_rate_5': 1.05, 'fund_amount_5': -148739380.0, 'fund_rate_5': -1.71, 'fund_amount_super_5': 62921548.0, 'fund_rate_super_5': 0.72, 'fund_amount_large_5': -211660928.0, 'fund_rate_large_5': -2.43, 'fund_amount_medium_5': -116342928.0, 'fund_rate_medium_5': -1.34, 'fund_amount_small_5': 265082320.0, 'fund_rate_small_5': 3.04, 'stock_name_5': '亚泰集团', 'change_rate_10': 1.14, 'fund_amount_10': -175968350.0, 'fund_rate_10': -0.88, 'fund_amount_super_10': 107817202.0, 'fund_rate_super_10': 0.54, 'fund_amount_large_10': -283785552.0, 'fund_rate_large_10': -1.43, 'fund_amount_medium_10': -135328512.0, 'fund_rate_medium_10': -0.68, 'fund_amount_small_10': 311296880.0, 'fund_rate_small_10': 1.56, 'stock_name_10': '西藏天路'}, {'date': '2024-07-03', 'name': '工程建设', 'change_rate': -0.63, 'fund_amount': -283193952.0, 'fund_rate': -4.33, 'fund_amount_super': -182982992.0, 'fund_rate_super': -2.8, 'fund_amount_large': -100210960.0, 'fund_rate_large': -1.53, 'fund_amount_medium': -12012528.0, 'fund_rate_medium': -0.18, 'fund_amount_small': 293073264.0, 'fund_rate_small': 4.48, 'stock_name': '**建筑', 'change_rate_5': 0.0, 'fund_amount_5': -598565808.0, 'fund_rate_5': -1.45, 'fund_amount_super_5': 931520.0, 'fund_rate_super_5': 0.0, 'fund_amount_large_5': -599497328.0, 'fund_rate_large_5': -1.46, 'fund_amount_medium_5': -514692768.0, 'fund_rate_medium_5': -1.25, 'fund_amount_small_5': 1110700768.0, 'fund_rate_small_5': 2.7, 'stock_name_5': '**电建', 'change_rate_10': -2.95, 'fund_amount_10': -2158332288.0, 'fund_rate_10': -2.58, 'fund_amount_super_10': -637402416.0, 'fund_rate_super_10': -0.76, 'fund_amount_large_10': -1520929872.0, 'fund_rate_large_10': -1.82, 'fund_amount_medium_10': -863472128.0, 'fund_rate_medium_10': -1.03, 'fund_amount_small_10': 3008561904.0, 'fund_rate_small_10': 3.6, 'stock_name_10': '腾达建设'}, {'date': '2024-07-03', 'name': '公用事业', 'change_rate': -1.14, 'fund_amount': -31092777.0, 'fund_rate': -2.97, 'fund_amount_super': -19710204.0, 'fund_rate_super': -1.88, 'fund_amount_large': -11382573.0, 'fund_rate_large': -1.09, 'fund_amount_medium': -32236560.0, 'fund_rate_medium': -3.08, 'fund_amount_small': 63329344.0, 'fund_rate_small': 6.05, 'stock_name': '兴蓉环境', 'change_rate_5': 0.9, 'fund_amount_5': -78135143.0, 'fund_rate_5': -1.27, 'fund_amount_super_5': 49462393.0, 'fund_rate_super_5': 0.81, 'fund_amount_large_5': -127597536.0, 'fund_rate_large_5': -2.08, 'fund_amount_medium_5': -67711904.0, 'fund_rate_medium_5': -1.1, 'fund_amount_small_5': 145847056.0, 'fund_rate_small_5': 2.37, 'stock_name_5': '兴蓉环境', 'change_rate_10': -1.28, 'fund_amount_10': -300619686.0, 'fund_rate_10': -2.34, 'fund_amount_super_10': -20256052.0, 'fund_rate_super_10': -0.16, 'fund_amount_large_10': -280363634.0, 'fund_rate_large_10': -2.18, 'fund_amount_medium_10': -156481056.0, 'fund_rate_medium_10': -1.22, 'fund_amount_small_10': 457100736.0, 'fund_rate_small_10': 3.56, 'stock_name_10': '联美控股'}, {'date': '2024-07-03', 'name': '电力行业', 'change_rate': -1.19, 'fund_amount': -789456512.0, 'fund_rate': -5.58, 'fund_amount_super': -327201632.0, 'fund_rate_super': -2.31, 'fund_amount_large': -462254880.0, 'fund_rate_large': -3.27, 'fund_amount_medium': -181315840.0, 'fund_rate_medium': -1.28, 'fund_amount_small': 970772176.0, 'fund_rate_small': 6.86, 'stock_name': '湖北能源', 'change_rate_5': 2.44, 'fund_amount_5': -1179472800.0, 'fund_rate_5': -1.38, 'fund_amount_super_5': 242351696.0, 'fund_rate_super_5': 0.28, 'fund_amount_large_5': -1421824496.0, 'fund_rate_large_5': -1.67, 'fund_amount_medium_5': -830914816.0, 'fund_rate_medium_5': -0.97, 'fund_amount_small_5': 2010387168.0, 'fund_rate_small_5': 2.36, 'stock_name_5': '国电电力', 'change_rate_10': 0.61, 'fund_amount_10': -3515918864.0, 'fund_rate_10': -2.14, 'fund_amount_super_10': -529383088.0, 'fund_rate_super_10': -0.32, 'fund_amount_large_10': -2986535776.0, 'fund_rate_large_10': -1.82, 'fund_amount_medium_10': -727187200.0, 'fund_rate_medium_10': -0.44, 'fund_amount_small_10': 4243105760.0, 'fund_rate_small_10': 2.58, 'stock_name_10': '国电电力'}, {'date': '2024-07-03', 'name': '交运设备', 'change_rate': -1.37, 'fund_amount': 140186176.0, 'fund_rate': 2.91, 'fund_amount_super': 138802704.0, 'fund_rate_super': 2.88, 'fund_amount_large': 1383472.0, 'fund_rate_large': 0.03, 'fund_amount_medium': -52678528.0, 'fund_rate_medium': -1.09, 'fund_amount_small': -87334256.0, 'fund_rate_small': -1.81, 'stock_name': '**中车', 'change_rate_5': -2.39, 'fund_amount_5': -308652710.0, 'fund_rate_5': -1.19, 'fund_amount_super_5': -82981334.0, 'fund_rate_super_5': -0.32, 'fund_amount_large_5': -225671376.0, 'fund_rate_large_5': -0.87, 'fund_amount_medium_5': -263669264.0, 'fund_rate_medium_5': -1.02, 'fund_amount_small_5': 565447584.0, 'fund_rate_small_5': 2.18, 'stock_name_5': '**中车', 'change_rate_10': -6.13, 'fund_amount_10': -1443719575.0, 'fund_rate_10': -2.61, 'fund_amount_super_10': -605294887.0, 'fund_rate_super_10': -1.09, 'fund_amount_large_10': -838424688.0, 'fund_rate_large_10': -1.51, 'fund_amount_medium_10': -469573392.0, 'fund_rate_medium_10': -0.85, 'fund_amount_small_10': 1901611104.0, 'fund_rate_small_10': 3.43, 'stock_name_10': '**中车'} ... displaying 10 of 86 total bound parameter sets ... {'date': '2024-07-03', 'name': '房地产服务', 'change_rate': 1.47, 'fund_amount': 5061401.0, 'fund_rate': 0.18, 'fund_amount_super': 12779433.0, 'fund_rate_super': 0.45, 'fund_amount_large': -7718032.0, 'fund_rate_large': -0.27, 'fund_amount_medium': 49803952.0, 'fund_rate_medium': 1.75, 'fund_amount_small': -54865360.0, 'fund_rate_small': -1.93, 'stock_name': '我爱我家', 'change_rate_5': 4.72, 'fund_amount_5': -32910346.0, 'fund_rate_5': -0.26, 'fund_amount_super_5': 137087078.0, 'fund_rate_super_5': 1.08, 'fund_amount_large_5': -169997424.0, 'fund_rate_large_5': -1.35, 'fund_amount_medium_5': 129149792.0, 'fund_rate_medium_5': 1.02, 'fund_amount_small_5': -96239456.0, 'fund_rate_small_5': -0.76, 'stock_name_5': '我爱我家', 'change_rate_10': 0.8, 'fund_amount_10': -300808088.0, 'fund_rate_10': -1.43, 'fund_amount_super_10': 98220790.0, 'fund_rate_super_10': 0.47, 'fund_amount_large_10': -399028878.0, 'fund_rate_large_10': -1.9, 'fund_amount_medium_10': 53164400.0, 'fund_rate_medium_10': 0.25, 'fund_amount_small_10': 247643696.0, 'fund_rate_small_10': 1.18, 'stock_name_10': '荣盛发展'}, {'date': '2024-07-03', 'name': '游戏', 'change_rate': -0.71, 'fund_amount': 12613519.0, 'fund_rate': 0.42, 'fund_amount_super': 8040287.0, 'fund_rate_super': 0.26, 'fund_amount_large': 4573232.0, 'fund_rate_large': 0.15, 'fund_amount_medium': -28412544.0, 'fund_rate_medium': -0.94, 'fund_amount_small': 15799024.0, 'fund_rate_small': 0.52, 'stock_name': '恺英网络', 'change_rate_5': -0.77, 'fund_amount_5': -374370416.0, 'fund_rate_5': -2.09, 'fund_amount_super_5': -76724048.0, 'fund_rate_super_5': -0.43, 'fund_amount_large_5': -297646368.0, 'fund_rate_large_5': -1.66, 'fund_amount_medium_5': -166671904.0, 'fund_rate_medium_5': -0.93, 'fund_amount_small_5': 541042288.0, 'fund_rate_small_5': 3.02, 'stock_name_5': '恺英网络', 'change_rate_10': -3.72, 'fund_amount_10': -922388575.0, 'fund_rate_10': -2.38, 'fund_amount_super_10': -353256079.0, 'fund_rate_super_10': -0.91, 'fund_amount_large_10': -569132496.0, 'fund_rate_large_10': -1.47, 'fund_amount_medium_10': -287526560.0, 'fund_rate_medium_10': -0.74, 'fund_amount_small_10': 1209915136.0, 'fund_rate_small_10': 3.12, 'stock_name_10': '恺英网络'}]]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2024-07-03 19:05:28,191 database.insert_other_db_from_df处理异常:cn_stock_fund_flow_concept表(pymysql.err.OperationalError) (1054, "Unknown column 'change_rate_10' in 'field list'")
[SQL: INSERT INTO cn_stock_fund_flow_concept (date, name, change_rate, fund_amount, fund_rate, fund_amount_super, fund_rate_super, fund_amount_large, fund_rate_large, fund_amount_medium, fund_rate_medium, fund_amount_small, fund_rate_small, stock_name, change_rate_5, fund_amount_5, fund_rate_5, fund_amount_super_5, fund_rate_super_5, fund_amount_large_5, fund_rate_large_5, fund_amount_medium_5, fund_rate_medium_5, fund_amount_small_5, fund_rate_small_5, stock_name_5, change_rate_10, fund_amount_10, fund_rate_10, fund_amount_super_10, fund_rate_super_10, fund_amount_large_10, fund_rate_large_10, fund_amount_medium_10, fund_rate_medium_10, fund_amount_small_10, fund_rate_small_10, stock_name_10) VALUES (%(date)s, %(name)s, %(change_rate)s, %(fund_amount)s, %(fund_rate)s, %(fund_amount_super)s, %(fund_rate_super)s, %(fund_amount_large)s, %(fund_rate_large)s, %(fund_amount_medium)s, %(fund_rate_medium)s, %(fund_amount_small)s, %(fund_rate_small)s, %(stock_name)s, %(change_rate_5)s, %(fund_amount_5)s, %(fund_rate_5)s, %(fund_amount_super_5)s, %(fund_rate_super_5)s, %(fund_amount_large_5)s, %(fund_rate_large_5)s, %(fund_amount_medium_5)s, %(fund_rate_medium_5)s, %(fund_amount_small_5)s, %(fund_rate_small_5)s, %(stock_name_5)s, %(change_rate_10)s, %(fund_amount_10)s, %(fund_rate_10)s, %(fund_amount_super_10)s, %(fund_rate_super_10)s, %(fund_amount_large_10)s, %(fund_rate_large_10)s, %(fund_amount_medium_10)s, %(fund_rate_medium_10)s, %(fund_amount_small_10)s, %(fund_rate_small_10)s, %(stock_name_10)s)]
[parameters: [{'date': '2024-07-03', 'name': '军工', 'change_rate': -1.46, 'fund_amount': -2765640592.0, 'fund_rate': -5.24, 'fund_amount_super': -1328366480.0, 'fund_rate_super': -2.52, 'fund_amount_large': -1437274112.0, 'fund_rate_large': -2.72, 'fund_amount_medium': 5057024.0, 'fund_rate_medium': 0.01, 'fund_amount_small': 2738802432.0, 'fund_rate_small': 5.19, 'stock_name': '银邦股份', 'change_rate_5': -2.08, 'fund_amount_5': -7111880912.0, 'fund_rate_5': -2.33, 'fund_amount_super_5': -2168892880.0, 'fund_rate_super_5': -0.71, 'fund_amount_large_5': -4942988032.0, 'fund_rate_large_5': -1.62, 'fund_amount_medium_5': -72695040.0, 'fund_rate_medium_5': -0.02, 'fund_amount_small_5': 7118027264.0, 'fund_rate_small_5': 2.33, 'stock_name_5': '中航机载', 'change_rate_10': -6.18, 'fund_amount_10': -20225384064.0, 'fund_rate_10': -3.26, 'fund_amount_super_10': -6738372224.0, 'fund_rate_super_10': -1.09, 'fund_amount_large_10': -13487011840.0, 'fund_rate_large_10': -2.18, 'fund_amount_medium_10': -907120896.0, 'fund_rate_medium_10': -0.15, 'fund_amount_small_10': 21000667136.0, 'fund_rate_small_10': 3.39, 'stock_name_10': '云南锗业'}, {'date': '2024-07-03', 'name': '煤化工', 'change_rate': -0.31, 'fund_amount': -167920848.0, 'fund_rate': -1.94, 'fund_amount_super': -100015712.0, 'fund_rate_super': -1.16, 'fund_amount_large': -67905136.0, 'fund_rate_large': -0.79, 'fund_amount_medium': -2466448.0, 'fund_rate_medium': -0.03, 'fund_amount_small': 169975952.0, 'fund_rate_small': 1.97, 'stock_name': '湖北宜化', 'change_rate_5': 0.5, 'fund_amount_5': -503010672.0, 'fund_rate_5': -0.9, 'fund_amount_super_5': -143912112.0, 'fund_rate_super_5': -0.26, 'fund_amount_large_5': -359098560.0, 'fund_rate_large_5': -0.65, 'fund_amount_medium_5': -71389520.0, 'fund_rate_medium_5': -0.13, 'fund_amount_small_5': 572998288.0, 'fund_rate_small_5': 1.03, 'stock_name_5': '华阳股份', 'change_rate_10': -2.19, 'fund_amount_10': -2853942512.0, 'fund_rate_10': -2.59, 'fund_amount_super_10': -1096229328.0, 'fund_rate_super_10': -0.99, 'fund_amount_large_10': -1757713184.0, 'fund_rate_large_10': -1.59, 'fund_amount_medium_10': 204841584.0, 'fund_rate_medium_10': 0.19, 'fund_amount_small_10': 2647358912.0, 'fund_rate_small_10': 2.4, 'stock_name_10': '甘肃能化'}, {'date': '2024-07-03', 'name': '新能源', 'change_rate': -0.86, 'fund_amount': -1676425760.0, 'fund_rate': -6.38, 'fund_amount_super': -802658336.0, 'fund_rate_super': -3.05, 'fund_amount_large': -873767424.0, 'fund_rate_large': -3.32, 'fund_amount_medium': 75484160.0, 'fund_rate_medium': 0.29, 'fund_amount_small': 1598296320.0, 'fund_rate_small': 6.08, 'stock_name': '德赛电池', 'change_rate_5': -0.08, 'fund_amount_5': -3235925936.0, 'fund_rate_5': -2.18, 'fund_amount_super_5': -1061926576.0, 'fund_rate_super_5': -0.71, 'fund_amount_large_5': -2173999360.0, 'fund_rate_large_5': -1.46, 'fund_amount_medium_5': -503792128.0, 'fund_rate_medium_5': -0.34, 'fund_amount_small_5': 3733753856.0, 'fund_rate_small_5': 2.51, 'stock_name_5': '德赛电池', 'change_rate_10': -3.98, 'fund_amount_10': -8669730352.0, 'fund_rate_10': -2.92, 'fund_amount_super_10': -3476548400.0, 'fund_rate_super_10': -1.17, 'fund_amount_large_10': -5193181952.0, 'fund_rate_large_10': -1.75, 'fund_amount_medium_10': -734217728.0, 'fund_rate_medium_10': -0.25, 'fund_amount_small_10': 9388365056.0, 'fund_rate_small_10': 3.16, 'stock_name_10': '德赛电池'}, {'date': '2024-07-03', 'name': '节能环保', 'change_rate': -0.85, 'fund_amount': -1197990192.0, 'fund_rate': -4.47, 'fund_amount_super': -405659952.0, 'fund_rate_super': -1.51, 'fund_amount_large': -792330240.0, 'fund_rate_large': -2.96, 'fund_amount_medium': 45986560.0, 'fund_rate_medium': 0.17, 'fund_amount_small': 1140491264.0, 'fund_rate_small': 4.26, 'stock_name': '航天晨光', 'change_rate_5': -0.48, 'fund_amount_5': -2722790544.0, 'fund_rate_5': -1.72, 'fund_amount_super_5': -1063439504.0, 'fund_rate_super_5': -0.67, 'fund_amount_large_5': -1659351040.0, 'fund_rate_large_5': -1.05, 'fund_amount_medium_5': 148787712.0, 'fund_rate_medium_5': 0.09, 'fund_amount_small_5': 2533848320.0, 'fund_rate_small_5': 1.6, 'stock_name_5': '中际旭创', 'change_rate_10': -3.33, 'fund_amount_10': -8440357936.0, 'fund_rate_10': -2.6, 'fund_amount_super_10': -2917287984.0, 'fund_rate_super_10': -0.9, 'fund_amount_large_10': -5523069952.0, 'fund_rate_large_10': -1.7, 'fund_amount_medium_10': 161202432.0, 'fund_rate_medium_10': 0.05, 'fund_amount_small_10': 8230530560.0, 'fund_rate_small_10': 2.53, 'stock_name_10': '中际旭创'}, {'date': '2024-07-03', 'name': 'AB股', 'change_rate': -0.17, 'fund_amount': 123164896.0, 'fund_rate': 1.69, 'fund_amount_super': 152611264.0, 'fund_rate_super': 2.09, 'fund_amount_large': -29446368.0, 'fund_rate_large': -0.4, 'fund_amount_medium': -60014880.0, 'fund_rate_medium': -0.82, 'fund_amount_small': -63150016.0, 'fund_rate_small': -0.87, 'stock_name': '长安汽车', 'change_rate_5': -0.19, 'fund_amount_5': -360235248.0, 'fund_rate_5': -0.94, 'fund_amount_super_5': -130911952.0, 'fund_rate_super_5': -0.34, 'fund_amount_large_5': -229323296.0, 'fund_rate_large_5': -0.6, 'fund_amount_medium_5': -252891536.0, 'fund_rate_medium_5': -0.66, 'fund_amount_small_5': 613126768.0, 'fund_rate_small_5': 1.61, 'stock_name_5': '长安汽车', 'change_rate_10': -3.3, 'fund_amount_10': -2061547616.0, 'fund_rate_10': -2.61, 'fund_amount_super_10': -767225696.0, 'fund_rate_super_10': -0.97, 'fund_amount_large_10': -1294321920.0, 'fund_rate_large_10': -1.64, 'fund_amount_medium_10': -329001856.0, 'fund_rate_medium_10': -0.42, 'fund_amount_small_10': 2390549488.0, 'fund_rate_small_10': 3.02, 'stock_name_10': '招商港口'}, {'date': '2024-07-03', 'name': 'AH股', 'change_rate': -0.26, 'fund_amount': -515586048.0, 'fund_rate': -0.86, 'fund_amount_super': -283654656.0, 'fund_rate_super': -0.47, 'fund_amount_large': -231931392.0, 'fund_rate_large': -0.39, 'fund_amount_medium': -454189056.0, 'fund_rate_medium': -0.76, 'fund_amount_small': 969775104.0, 'fund_rate_small': 1.62, 'stock_name': '**中免', 'change_rate_5': 0.24, 'fund_amount_5': -2945278976.0, 'fund_rate_5': -0.92, 'fund_amount_super_5': -1426550016.0, 'fund_rate_super_5': -0.45, 'fund_amount_large_5': -1518728960.0, 'fund_rate_large_5': -0.48, 'fund_amount_medium_5': -2167983872.0, 'fund_rate_medium_5': -0.68, 'fund_amount_small_5': 5113262592.0, 'fund_rate_small_5': 1.6, 'stock_name_5': '**中免', 'change_rate_10': -1.39, 'fund_amount_10': -13383012352.0, 'fund_rate_10': -2.14, 'fund_amount_super_10': -7304363264.0, 'fund_rate_super_10': -1.17, 'fund_amount_large_10': -6078649088.0, 'fund_rate_large_10': -0.97, 'fund_amount_medium_10': -1227927040.0, 'fund_rate_medium_10': -0.2, 'fund_amount_small_10': 14610939136.0, 'fund_rate_small_10': 2.34, 'stock_name_10': '交通银行'}, {'date': '2024-07-03', 'name': 'HS300_', 'change_rate': -0.39, 'fund_amount': -1211651328.0, 'fund_rate': -0.74, 'fund_amount_super': -1267101440.0, 'fund_rate_super': -0.78, 'fund_amount_large': 55450112.0, 'fund_rate_large': 0.03, 'fund_amount_medium': -1622973440.0, 'fund_rate_medium': -1.0, 'fund_amount_small': 2834625024.0, 'fund_rate_small': 1.74, 'stock_name': '**中免', 'change_rate_5': -1.23, 'fund_amount_5': -12798488832.0, 'fund_rate_5': -1.4, 'fund_amount_super_5': -7841052928.0, 'fund_rate_super_5': -0.86, 'fund_amount_large_5': -4957435904.0, 'fund_rate_large_5': -0.54, 'fund_amount_medium_5': -2375019008.0, 'fund_rate_medium_5': -0.26, 'fund_amount_small_5': 15173508352.0, 'fund_rate_small_5': 1.66, 'stock_name_5': '贵州茅台', 'change_rate_10': -3.15, 'fund_amount_10': -45950195968.0, 'fund_rate_10': -2.49, 'fund_amount_super_10': -24155422976.0, 'fund_rate_super_10': -1.31, 'fund_amount_large_10': -21794772992.0, 'fund_rate_large_10': -1.18, 'fund_amount_medium_10': -338352896.0, 'fund_rate_medium_10': -0.02, 'fund_amount_small_10': 46288548864.0, 'fund_rate_small_10': 2.51, 'stock_name_10': '贵州茅台'}, {'date': '2024-07-03', 'name': '次新股', 'change_rate': -1.3, 'fund_amount': -315019600.0, 'fund_rate': -2.93, 'fund_amount_super': -56447952.0, 'fund_rate_super': -0.52, 'fund_amount_large': -258571648.0, 'fund_rate_large': -2.4, 'fund_amount_medium': -29662192.0, 'fund_rate_medium': -0.28, 'fund_amount_small': 338724848.0, 'fund_rate_small': 3.15, 'stock_name': '艾罗能源', 'change_rate_5': -4.05, 'fund_amount_5': -1978962969.0, 'fund_rate_5': -3.35, 'fund_amount_super_5': -245267897.0, 'fund_rate_super_5': -0.42, 'fund_amount_large_5': -1733695072.0, 'fund_rate_large_5': -2.94, 'fund_amount_medium_5': -302285552.0, 'fund_rate_medium_5': -0.51, 'fund_amount_small_5': 2256108912.0, 'fund_rate_small_5': 3.82, 'stock_name_5': '智迪科技', 'change_rate_10': -8.46, 'fund_amount_10': -4774792409.0, 'fund_rate_10': -3.54, 'fund_amount_super_10': -650618857.0, 'fund_rate_super_10': -0.48, 'fund_amount_large_10': -4124173552.0, 'fund_rate_large_10': -3.06, 'fund_amount_medium_10': -374841840.0, 'fund_rate_medium_10': -0.28, 'fund_amount_small_10': 5090970992.0, 'fund_rate_small_10': 3.78, 'stock_name_10': '爱迪特'} ... displaying 10 of 457 total bound parameter sets ... {'date': '2024-07-03', 'name': '玻璃基板', 'change_rate': -0.73, 'fund_amount': -71323008.0, 'fund_rate': -1.15, 'fund_amount_super': 24512752.0, 'fund_rate_super': 0.39, 'fund_amount_large': -95835760.0, 'fund_rate_large': -1.54, 'fund_amount_medium': -73556768.0, 'fund_rate_medium': -1.18, 'fund_amount_small': 144549184.0, 'fund_rate_small': 2.33, 'stock_name': '通富微电', 'change_rate_5': -2.22, 'fund_amount_5': -638104352.0, 'fund_rate_5': -1.87, 'fund_amount_super_5': -314611904.0, 'fund_rate_super_5': -0.92, 'fund_amount_large_5': -323492448.0, 'fund_rate_large_5': -0.95, 'fund_amount_medium_5': -115241200.0, 'fund_rate_medium_5': -0.34, 'fund_amount_small_5': 747684128.0, 'fund_rate_small_5': 2.19, 'stock_name_5': '京东方A', 'change_rate_10': -8.42, 'fund_amount_10': -2564349760.0, 'fund_rate_10': -3.32, 'fund_amount_super_10': -903467024.0, 'fund_rate_super_10': -1.17, 'fund_amount_large_10': -1660882736.0, 'fund_rate_large_10': -2.15, 'fund_amount_medium_10': -134552464.0, 'fund_rate_medium_10': -0.17, 'fund_amount_small_10': 2688762464.0, 'fund_rate_small_10': 3.48, 'stock_name_10': '芯瑞达'}, {'date': '2024-07-03', 'name': '财税数字化', 'change_rate': -3.04, 'fund_amount': -1125318848.0, 'fund_rate': -9.1, 'fund_amount_super': -514310336.0, 'fund_rate_super': -4.16, 'fund_amount_large': -611008512.0, 'fund_rate_large': -4.94, 'fund_amount_medium': 275627888.0, 'fund_rate_medium': 2.23, 'fund_amount_small': 862874016.0, 'fund_rate_small': 6.98, 'stock_name': '久其软件', 'change_rate_5': -3.04, 'fund_amount_5': -1125318848.0, 'fund_rate_5': -9.1, 'fund_amount_super_5': -514310336.0, 'fund_rate_super_5': -4.16, 'fund_amount_large_5': -611008512.0, 'fund_rate_large_5': -4.94, 'fund_amount_medium_5': 275627888.0, 'fund_rate_medium_5': 2.23, 'fund_amount_small_5': 862874016.0, 'fund_rate_small_5': 6.98, 'stock_name_5': '久其软件', 'change_rate_10': -3.04, 'fund_amount_10': -1125318848.0, 'fund_rate_10': -9.1, 'fund_amount_super_10': -514310336.0, 'fund_rate_super_10': -4.16, 'fund_amount_large_10': -611008512.0, 'fund_rate_large_10': -4.94, 'fund_amount_medium_10': 275627888.0, 'fund_rate_medium_10': 2.23, 'fund_amount_small_10': 862874016.0, 'fund_rate_small_10': 6.98, 'stock_name_10': '久其软件'}]]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
from stock.
信息提示,对应的数据库字段不存在。
这种情况不是系统本身问题,只能建议把数据库删除试试。
from stock.
Related Issues (20)
- 大佬也没建个群,我牵个头吧,有意向的可以加我,我去建个群 zhangwuge11011 HOT 2
- 大佬,能否增加一个“回封板”的选股策略?
- docker: Error response from daemon: Cannot link to a non running container: /InStockDbService AS /InStock/InStockDbService HOT 2
- 请问下有mac版本的安装教程吗? HOT 1
- 具体个股页面无法显示 HOT 2
- hello 初始化的挂载数据可以哪里得到呀 HOT 1
- 有计划支持美股吗
- 跑不了bat文件是怎么回事 HOT 1
- 区间作业跑不通,仔细看了下区间作业before参数默认为true,入口处就返回。 HOT 3
- 缺少2张表是怎么回事 HOT 1
- 每日股票能实时更新么
- bat文件死活跑不动,全是乱码 HOT 1
- 下载以前的数据不成功
- 11111 HOT 1
- spreadjs 怎么弄呢?求教,感谢! HOT 7
- 怎么按照30分钟K线数据来做分析呢? HOT 3
- 每日etf数据填写错误 HOT 2
- 有么有计算因子的部分 HOT 1
- 请问为什么不能获取历史“每日股票数据”,只能获取昨日1天的“每日股票数据” HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from stock.