メモ：メモ一覧
更新

-- 暴騰・暴落感知考察 -- move25 より上が続いている、-1σ以上が多い -- 方向性的には -- ① 2分で3本ボリンジャーを超えた後、しばらくmove25を割らない -- ② しばらく1σ～2σの真ん中を割らない -- とりあえず② SELECT S.YMD ,LEFT(S.TIME, 2) AS TTTT ,MIN(S.TIME) AS TIME FROM EveryDay1mData S INNER JOIN ( SELECT A.YMD ,A.TIME ,COUNT(*) AS CNT FROM EveryDay1mData A INNER JOIN EveryDay1mData C ON C.TIME_NUM >= A.TIME_NUM - 10 AND C.TIME_NUM <= A.TIME_NUM INNER JOIN EveryDay1mBoriData B ON B.YMD = C.YMD AND B.TIME = C.TIME AND B.BRAND_CODE = C.BRAND_CODE WHERE A.YMD = '20180615' AND C.END_AMT > (B.SIGMA / 2) + B.move25 GROUP BY A.YMD, A.TIME HAVING COUNT(*) >= 10 ) T ON T.YMD = S.YMD AND T.TIME = S.TIME GROUP BY S.YMD, LEFT(S.TIME, 2) -- A.TIME_NUM = '14897' -- 20180617 02:00