I have two data frame 1 with 15 min candle and second with EOD I need to compare 15 min candle high with eod candle of the same day/previous day

Viewed 35

so I have will have 24/25 candles roughly that I need to compare with one candle of EOD.

15 min candle dataframe:

    Unnamed: 0                date    open  ...        rsi     max            sma
0            0 2019-07-08 09:15:00  143.25  ...        NaN     NaN            NaN
1            1 2019-07-08 09:30:00  144.90  ...        NaN     NaN            NaN
2            2 2019-07-08 09:45:00  145.40  ...        NaN     NaN            NaN
3            3 2019-07-08 10:00:00  145.50  ...        NaN     NaN            NaN
4            4 2019-07-08 10:15:00  143.75  ...        NaN     NaN            NaN
5            5 2019-07-08 10:30:00  143.25  ...        NaN     NaN            NaN
6            6 2019-07-08 10:45:00  142.65  ...        NaN     NaN            NaN
7            7 2019-07-08 11:00:00  143.40  ...        NaN     NaN            NaN
8            8 2019-07-08 11:15:00  141.90  ...        NaN     NaN            NaN
9            9 2019-07-08 11:30:00  142.20  ...        NaN     NaN            NaN
10          10 2019-07-08 11:45:00  142.55  ...        NaN     NaN            NaN
11          11 2019-07-08 12:00:00  142.55  ...        NaN     NaN            NaN
12          12 2019-07-08 12:15:00  142.05  ...        NaN     NaN            NaN
13          13 2019-07-08 12:30:00  141.80  ...        NaN     NaN            NaN
14          14 2019-07-08 12:45:00  141.25  ...  31.736527  145.50            NaN
15          15 2019-07-08 13:00:00  141.85  ...  33.032083  145.50            NaN
16          16 2019-07-08 13:15:00  142.00  ...  33.932307  145.50            NaN
17          17 2019-07-08 13:30:00  142.00  ...  30.810114  143.75            NaN
18          18 2019-07-08 13:45:00  141.40  ...  30.810114  143.40            NaN
19          19 2019-07-08 14:00:00  141.40  ...  28.426663  143.40            NaN
20          20 2019-07-08 14:15:00  140.95  ...  32.993981  143.40  167673.857143
21          21 2019-07-08 14:30:00  141.25  ...  26.353441  142.55  182682.380952
22          22 2019-07-08 14:45:00  139.60  ...  26.011746  142.55  177937.190476
23          23 2019-07-08 15:00:00  139.55  ...  24.000959  142.55  204142.571429

DAY CANDLE:

 Unnamed: 0       time        o        h  ...   BBU_20_2.0  BBB_20_2.0    R-slope     m
1             1 2019-07-08   143.25   146.25  ...          NaN         NaN        NaN     Na
0 Answers
Related