-- RUN: RUN-ANA-ROBOT-MARKET-GAP-001
-- SCAN: RUN-ANA-ROBOT-MARKET-GAP-001_RECOVERY_TRADING_XUNTOU_FRONT
-- Purpose: robot market reverse-gap execution against available remote MySQL data.
-- Boundary: remote DB has price/static tables but no industry/concept/main-business profile table; scope gate remains draft.
-- Source schema/table: trading_xuntou.cn_stock_instrument_static, trading_xuntou.cn_stock_kline_1d_front
-- Window: 2026-04-04 to 2026-07-04; lookback starts 2026-03-01
WITH robot_company_universe AS (
SELECT '002050.SZ' AS symbol, '三花智控' AS source_company_name, '公司档案/三花智控公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300354.SZ' AS symbol, '东华测试' AS source_company_name, '公司档案/东华测试公司信息梳理.md' AS source_rel
UNION ALL
SELECT '000708.SZ' AS symbol, '中信特钢' AS source_company_name, '公司档案/中信特钢公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688295.SH' AS symbol, '中复神鹰' AS source_company_name, '公司档案/中复神鹰公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002896.SZ' AS symbol, '中大力德' AS source_company_name, '公司档案/中大力德公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300684.SZ' AS symbol, '中石科技' AS source_company_name, '公司档案/中石科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688716.SH' AS symbol, '中研股份' AS source_company_name, '公司档案/中研股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300777.SZ' AS symbol, '中简科技' AS source_company_name, '公司档案/中简科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002179.SZ' AS symbol, '中航光电' AS source_company_name, '公司档案/中航光电公司信息梳理.md' AS source_rel
UNION ALL
SELECT '000887.SZ' AS symbol, '中鼎股份-星汇传感' AS source_company_name, '公司档案/中鼎股份-星汇传感公司信息梳理.md' AS source_rel
UNION ALL
SELECT '301368.SZ' AS symbol, '丰立智能' AS source_company_name, '公司档案/丰立智能公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603667.SH' AS symbol, '五洲新春' AS source_company_name, '公司档案/五洲新春公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300014.SZ' AS symbol, '亿纬锂能' AS source_company_name, '公司档案/亿纬锂能公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688698.SH' AS symbol, '伟创电气' AS source_company_name, '公司档案/伟创电气公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603416.SH' AS symbol, '信捷电气' AS source_company_name, '公司档案/信捷电气公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300695.SZ' AS symbol, '兆丰股份' AS source_company_name, '公司档案/兆丰股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '003021.SZ' AS symbol, '兆威机电' AS source_company_name, '公司档案/兆威机电公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300699.SZ' AS symbol, '光威复材' AS source_company_name, '公司档案/光威复材公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002708.SZ' AS symbol, '光洋股份' AS source_company_name, '公司档案/光洋股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688400.SH' AS symbol, '凌云光' AS source_company_name, '公司档案/凌云光公司信息梳理.md' AS source_rel
UNION ALL
SELECT '600480.SH' AS symbol, '凌云股份' AS source_company_name, '公司档案/凌云股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603009.SH' AS symbol, '北特科技' AS source_company_name, '公司档案/北特科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300809.SZ' AS symbol, '华辰装备' AS source_company_name, '公司档案/华辰装备公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300644.SZ' AS symbol, '南京聚隆' AS source_company_name, '公司档案/南京聚隆公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300863.SZ' AS symbol, '卡倍亿' AS source_company_name, '公司档案/卡倍亿公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300100.SZ' AS symbol, '双林股份' AS source_company_name, '公司档案/双林股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002472.SZ' AS symbol, '双环传动-环动科技' AS source_company_name, '公司档案/双环传动-环动科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '000420.SZ' AS symbol, '吉林化纤' AS source_company_name, '公司档案/吉林化纤公司信息梳理.md' AS source_rel
UNION ALL
SELECT '301510.SZ' AS symbol, '固高科技' AS source_company_name, '公司档案/固高科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603915.SH' AS symbol, '国茂股份' AS source_company_name, '公司档案/国茂股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002074.SZ' AS symbol, '国轩高科' AS source_company_name, '公司档案/国轩高科公司信息梳理.md' AS source_rel
UNION ALL
SELECT '600699.SH' AS symbol, '均胜电子' AS source_company_name, '公司档案/均胜电子公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002747.SZ' AS symbol, '埃斯顿' AS source_company_name, '公司档案/埃斯顿公司信息梳理.md' AS source_rel
UNION ALL
SELECT '001306.SZ' AS symbol, '夏厦精密' AS source_company_name, '公司档案/夏厦精密公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688003.SH' AS symbol, '天准科技' AS source_company_name, '公司档案/天准科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002338.SZ' AS symbol, '奥普光电-长春禹衡光学' AS source_company_name, '公司档案/奥普光电-长春禹衡光学公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688686.SH' AS symbol, '奥普特' AS source_company_name, '公司档案/奥普特公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300750.SZ' AS symbol, '宁德时代' AS source_company_name, '公司档案/宁德时代公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002048.SZ' AS symbol, '宁波华翔' AS source_company_name, '公司档案/宁波华翔公司信息梳理.md' AS source_rel
UNION ALL
SELECT '301413.SZ' AS symbol, '安培龙' AS source_company_name, '公司档案/安培龙公司信息梳理.md' AS source_rel
UNION ALL
SELECT '600885.SH' AS symbol, '宏发股份' AS source_company_name, '公司档案/宏发股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002182.SZ' AS symbol, '宝武镁业-云海金属' AS source_company_name, '公司档案/宝武镁业-云海金属公司信息梳理.md' AS source_rel
UNION ALL
SELECT '600019.SH' AS symbol, '宝钢股份' AS source_company_name, '公司档案/宝钢股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '605133.SH' AS symbol, '嵘泰股份' AS source_company_name, '公司档案/嵘泰股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688186.SH' AS symbol, '广大特材' AS source_company_name, '公司档案/广大特材公司信息梳理.md' AS source_rel
UNION ALL
SELECT '000049.SZ' AS symbol, '德赛电池' AS source_company_name, '公司档案/德赛电池公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688583.SH' AS symbol, '思看科技' AS source_company_name, '公司档案/思看科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '003025.SZ' AS symbol, '思进智能' AS source_company_name, '公司档案/思进智能公司信息梳理.md' AS source_rel
UNION ALL
SELECT '601100.SH' AS symbol, '恒立液压' AS source_company_name, '公司档案/恒立液压公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300488.SZ' AS symbol, '恒锋工具' AS source_company_name, '公司档案/恒锋工具公司信息梳理.md' AS source_rel
UNION ALL
SELECT '600399.SH' AS symbol, '抚顺特钢' AS source_company_name, '公司档案/抚顺特钢公司信息梳理.md' AS source_rel
UNION ALL
SELECT '601689.SH' AS symbol, '拓普集团' AS source_company_name, '公司档案/拓普集团公司信息梳理.md' AS source_rel
UNION ALL
SELECT '301550.SZ' AS symbol, '斯菱智驱' AS source_company_name, '公司档案/斯菱智驱公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603040.SH' AS symbol, '新坐标' AS source_company_name, '公司档案/新坐标公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002527.SZ' AS symbol, '新时达' AS source_company_name, '公司档案/新时达公司信息梳理.md' AS source_rel
UNION ALL
SELECT '301076.SZ' AS symbol, '新瀚新材' AS source_company_name, '公司档案/新瀚新材公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002520.SZ' AS symbol, '日发精机' AS source_company_name, '公司档案/日发精机公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603286.SH' AS symbol, '日盈电子' AS source_company_name, '公司档案/日盈电子公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002324.SZ' AS symbol, '普利特' AS source_company_name, '公司档案/普利特公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603662.SH' AS symbol, '柯力传感' AS source_company_name, '公司档案/柯力传感公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300207.SZ' AS symbol, '欣旺达' AS source_company_name, '公司档案/欣旺达公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688160.SH' AS symbol, '步科股份' AS source_company_name, '公司档案/步科股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300351.SZ' AS symbol, '永贵电器' AS source_company_name, '公司档案/永贵电器公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300124.SZ' AS symbol, '汇川技术' AS source_company_name, '公司档案/汇川技术公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300007.SZ' AS symbol, '汉威科技-苏州能斯达' AS source_company_name, '公司档案/汉威科技-苏州能斯达公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300660.SZ' AS symbol, '江苏雷利-鼎智科技' AS source_company_name, '公司档案/江苏雷利-鼎智科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688028.SH' AS symbol, '沃尔德' AS source_company_name, '公司档案/沃尔德公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002886.SZ' AS symbol, '沃特股份' AS source_company_name, '公司档案/沃特股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '605333.SH' AS symbol, '沪光股份' AS source_company_name, '公司档案/沪光股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688577.SH' AS symbol, '浙海德曼' AS source_company_name, '公司档案/浙海德曼公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002415.SZ' AS symbol, '海康威视-海康机器人' AS source_company_name, '公司档案/海康威视-海康机器人公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688167.SH' AS symbol, '炬光科技' AS source_company_name, '公司档案/炬光科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '600933.SH' AS symbol, '爱柯迪' AS source_company_name, '公司档案/爱柯迪公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688772.SH' AS symbol, '珠海冠宇' AS source_company_name, '公司档案/珠海冠宇公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688800.SH' AS symbol, '瑞可达' AS source_company_name, '公司档案/瑞可达公司信息梳理.md' AS source_rel
UNION ALL
SELECT '301596.SZ' AS symbol, '瑞迪智驱' AS source_company_name, '公司档案/瑞迪智驱公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002011.SZ' AS symbol, '盾安环境' AS source_company_name, '公司档案/盾安环境公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002222.SZ' AS symbol, '福晶科技' AS source_company_name, '公司档案/福晶科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '605488.SH' AS symbol, '福莱新材' AS source_company_name, '公司档案/福莱新材公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603166.SH' AS symbol, '福达股份' AS source_company_name, '公司档案/福达股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688320.SH' AS symbol, '禾川科技' AS source_company_name, '公司档案/禾川科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '000837.SZ' AS symbol, '秦川机床' AS source_company_name, '公司档案/秦川机床公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300428.SZ' AS symbol, '立中集团' AS source_company_name, '公司档案/立中集团公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002475.SZ' AS symbol, '立讯精密' AS source_company_name, '公司档案/立讯精密公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300258.SZ' AS symbol, '精锻科技' AS source_company_name, '公司档案/精锻科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688017.SH' AS symbol, '绿的谐波' AS source_company_name, '公司档案/绿的谐波公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300681.SZ' AS symbol, '英搏尔' AS source_company_name, '公司档案/英搏尔公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603809.SH' AS symbol, '豪能股份' AS source_company_name, '公司档案/豪能股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300580.SZ' AS symbol, '贝斯特' AS source_company_name, '公司档案/贝斯特公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002632.SZ' AS symbol, '道明光学' AS source_company_name, '公司档案/道明光学公司信息梳理.md' AS source_rel
UNION ALL
SELECT '600143.SH' AS symbol, '金发科技' AS source_company_name, '公司档案/金发科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002126.SZ' AS symbol, '银轮股份' AS source_company_name, '公司档案/银轮股份公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688048.SH' AS symbol, '长光华芯' AS source_company_name, '公司档案/长光华芯公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300718.SZ' AS symbol, '长盛轴承' AS source_company_name, '公司档案/长盛轴承公司信息梳理.md' AS source_rel
UNION ALL
SELECT '002979.SZ' AS symbol, '雷赛智能' AS source_company_name, '公司档案/雷赛智能公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300602.SZ' AS symbol, '飞荣达' AS source_company_name, '公司档案/飞荣达公司信息梳理.md' AS source_rel
UNION ALL
SELECT '603728.SH' AS symbol, '鸣志电器' AS source_company_name, '公司档案/鸣志电器公司信息梳理.md' AS source_rel
UNION ALL
SELECT '300438.SZ' AS symbol, '鹏辉能源' AS source_company_name, '公司档案/鹏辉能源公司信息梳理.md' AS source_rel
UNION ALL
SELECT '688668.SH' AS symbol, '鼎通科技' AS source_company_name, '公司档案/鼎通科技公司信息梳理.md' AS source_rel
UNION ALL
SELECT '600592.SH' AS symbol, '龙溪股份' AS source_company_name, '公司档案/龙溪股份公司信息梳理.md' AS source_rel
), price_rows AS (
  SELECT k.symbol, k.trade_date, k.open, k.high, k.low, k.close, k.volume, k.amount
  FROM trading_xuntou.cn_stock_kline_1d_front k
  JOIN (SELECT DISTINCT symbol FROM robot_company_universe WHERE symbol IS NOT NULL) u ON u.symbol = k.symbol
  WHERE k.trade_date BETWEEN '2026-03-01' AND '2026-07-04'
)
SELECT * FROM price_rows ORDER BY symbol, trade_date;