メモ：メモ一覧
更新

-- 直近の安値に接触 SELECT A.YMD ,A.BRAND_CODE ,A.YMD AS 安値後 ,B.YMD AS 安値前 ,C.YMD AS 高値中 FROM EveryDay4Data A INNER JOIN EigyoCalendar AA ON AA.YMD = A.YMD INNER JOIN MoveAverage AB ON AB.YMD = A.YMD AND AB.BRAND_CODE = A.BRAND_CODE -- 賃借銘柄 INNER JOIN RentalBrandList AX ON AX.BRAND_CODE = A.BRAND_CODE INNER JOIN TestEveryDay4Data04 B ON B.HIGH_AMT = ( select MIN(Z.HIGH_AMT) from TestEveryDay4Data04 Z where Z.YMD < AA.BEF_5YMD AND Z.YMD > AA.BEF_25YMD AND Z.BRAND_CODE = A.BRAND_CODE ) AND B.YMD > AA.BEF_75YMD AND B.BRAND_CODE = A.BRAND_CODE INNER JOIN TestEveryDay4Data03 C ON C.YMD BETWEEN B.YMD AND A.YMD AND C.BRAND_CODE = A.BRAND_CODE AND C.HIGH_AMT > A.HIGH_AMT * 1.07 INNER JOIN EigyoCalendar CC ON CC.YMD = C.YMD WHERE A.YMD = '20180410' AND B.HIGH_AMT BETWEEN A.LOW_AMT * 0.99 AND A.LOW_AMT * 1.01 AND AB.move5 < AB.move25 AND AB.move25 < AB.move75 AND A.VOLUME > 300000000 / A.END_AMT