メモ：メモ一覧
更新

-- 高値 INSERT INTO EveryDay5mHLData SELECT A.YMD ,A.TIME ,A.BRAND_CODE ,'1' AS KBN ,A.HIGH_AMT AS AMT ,A.TIME_NUM FROM EveryDay5mData A LEFT JOIN EveryDay5mData B ON B.TIME_NUM BETWEEN A.TIME_NUM - 5 AND A.TIME_NUM + 5 AND B.TIME_NUM <> A.TIME_NUM AND B.BRAND_CODE = A.BRAND_CODE AND B.HIGH_AMT > A.HIGH_AMT WHERE B.BRAND_CODE IS NULL -- 安値 INSERT INTO EveryDay5mHLData SELECT A.YMD ,A.TIME ,A.BRAND_CODE ,'0' AS KBN ,A.LOW_AMT AS AMT ,A.TIME_NUM FROM EveryDay5mData A LEFT JOIN EveryDay5mData B ON B.TIME_NUM BETWEEN A.TIME_NUM - 5 AND A.TIME_NUM + 5 AND B.TIME_NUM <> A.TIME_NUM AND B.BRAND_CODE = A.BRAND_CODE AND B.LOW_AMT < A.LOW_AMT WHERE B.BRAND_CODE IS NULL