メモ：メモ一覧
更新

-- 前日陽線の場合買い、逆は売り (SELECT A.YMD ,IFNULL(B.END_AMT, BB.END_AMT) AS END_AMT ,IFNULL(C.START_AMT, D.START_AMT) AS START_AMT ,MAX(A.HIGH_AMT) AS HIGH_AMT ,MIN(A.LOW_AMT) AS LOW_AMT FROM EveryDay1mData A LEFT JOIN EveryDay1mData B ON B.YMD = A.YMD AND B.BRAND_CODE = A.BRAND_CODE AND B.TIME = '23:10' LEFT JOIN EveryDay1mData BB ON BB.YMD = A.YMD AND BB.BRAND_CODE = A.BRAND_CODE AND BB.TIME = '23:11' LEFT JOIN EveryDay1mData C ON C.YMD = A.YMD AND C.BRAND_CODE = A.BRAND_CODE AND C.TIME = '00:05' LEFT JOIN EveryDay1mData D ON D.YMD = A.YMD AND D.BRAND_CODE = A.BRAND_CODE AND D.TIME = '00:06' WHERE A.YMD LIKE '2020%' AND A.BRAND_CODE = 'BIT_FX' AND A.TIME BETWEEN '00:10' AND '23:10' AND IFNULL(B.END_AMT, BB.END_AMT) IS NOT NULL AND IFNULL(C.START_AMT, D.START_AMT) IS NOT NULL GROUP BY A.YMD ,IFNULL(B.END_AMT, BB.END_AMT) ,IFNULL(C.START_AMT, D.START_AMT) )