メモ：メモ一覧
更新

-- 信用倍率が持ち合いで低値に近づいている SELECT A.YMD ,A.BRAND_CODE ,B.YMD AS MIN_YMD ,B.HIGH_AMT AS MIN_AMT ,A.* FROM EveryDay4Data A INNER JOIN TestEveryDay4Data04 B ON B.BRAND_CODE = A.BRAND_CODE AND B.YMD = (select MAX(Z.YMD) from TestEveryDay4Data04 Z where Z.BRAND_CODE = A.BRAND_CODE AND Z.YMD < A.YMD) WHERE A.YMD = '20190307' AND A.SINYO_BUY <= A.SINYO_SELL * 1.1 AND A.SINYO_BUY >= A.SINYO_SELL * 0.9 AND A.VOLUME > 100000000 / A.END_AMT AND A.END_AMT > 300 AND A.LOW_AMT <= B.HIGH_AMT * 1.01