メモリストページ

メモ：メモ一覧

下がりそうなパターンなので色々試してみたい
-- 株
SELECT A.*
FROM EveryDay4Data A
INNER JOIN EveryDay4Data B ON
    B.TIME_NUM = A.TIME_NUM - 1
AND B.BRAND_CODE = A.BRAND_CODE
INNER JOIN EveryDay4Data C ON
    C.TIME_NUM = B.TIME_NUM - 1
AND C.BRAND_CODE = A.BRAND_CODE
INNER JOIN EveryDay4Data D ON
    D.TIME_NUM = C.TIME_NUM - 1
AND D.BRAND_CODE = A.BRAND_CODE

WHERE 
    A.YMD = '20210323'
AND A.END_AMT > A.START_AMT
AND B.END_AMT < B.START_AMT
AND C.END_AMT < C.START_AMT
AND D.END_AMT > D.START_AMT
AND D.END_AMT > D.BEFORE_AMT * 1.05
AND D.START_AMT < D.move25
AND D.START_AMT < D.move75

-- BF(QUO)
SELECT A.*
FROM EveryDay1mData A
INNER JOIN EveryDay1mData B ON
    B.TIME_NUM = A.TIME_NUM - 1
AND B.BRAND_CODE = A.BRAND_CODE
INNER JOIN EveryDay1mData C ON
    C.TIME_NUM = B.TIME_NUM - 1
AND C.BRAND_CODE = A.BRAND_CODE
INNER JOIN EveryDay1mData D ON
    D.TIME_NUM = C.TIME_NUM - 1
AND D.BRAND_CODE = A.BRAND_CODE

WHERE 
    A.YMD = '20210401'
AND A.BRAND_CODE = 'BIT_QUO'
AND
(
    A.END_AMT > A.START_AMT
AND B.END_AMT < B.START_AMT
AND C.END_AMT < C.START_AMT
AND D.END_AMT > D.START_AMT
)
AND A.HIGH_AMT > C.START_AMT