Over the past 5, 10, and 15 years, does the high or low of the day happen in the beginning or ending of the day
Interesting questions. I want to know also. So, just did a quick test using minute data since 2009 on SPY and QQQ. See the attached PDF for the detailed summary that also breaks down to per-year, high or low, 10 minutes, 30 minutes, and 60 minutes distribution including frequency and distribution percentage.
For example on SPY,
===============================================
low distribution and percentage
Days low: 20090101 to 20180710
Minutes Frm To Freq %
0 to 29 : 697 30.70
30 to 59 : 256 11.30
60 to 89 : 171 7.50
90 to 119 : 131 5.80
120 to 149 : 111 4.90
150 to 179 : 87 3.80
180 to 209 : 59 2.60
210 to 239 : 69 3.00
240 to 269 : 75 3.30
270 to 299 : 103 4.50
300 to 329 : 90 4.00
330 to 359 : 118 5.20
360 to 390 : 302 13.30
Total days : 2269 100
===============================================
low distribution and percentage
Days low: 20090101 to 20180710
Minutes Frm To Freq %
0 to 59 : 953 42.00
60 to 119 : 302 13.30
120 to 179 : 198 8.70
180 to 239 : 128 5.60
240 to 299 : 178 7.80
300 to 359 : 208 9.20
360 to 419 : 302 13.30
Total days : 2269 100
===============================================
high distribution and percentage
Days high: 20090101 to 20180710
Minutes Frm To Freq %
0 to 29 : 587 25.90
30 to 59 : 232 10.20
60 to 89 : 143 6.30
90 to 119 : 125 5.50
120 to 149 : 74 3.30
150 to 179 : 83 3.70
180 to 209 : 63 2.80
210 to 239 : 63 2.80
240 to 269 : 86 3.80
270 to 299 : 94 4.10
300 to 329 : 127 5.60
330 to 359 : 156 6.90
360 to 390 : 436 19.20
Total days : 2269 100
===============================================
high distribution and percentage
Days high: 20090101 to 20180710
Minutes Frm To Freq %
0 to 59 : 819 36.10
60 to 119 : 268 11.80
120 to 179 : 157 6.90
180 to 239 : 126 5.60
240 to 299 : 180 7.90
300 to 359 : 283 12.50
360 to 419 : 436 19.20
Total days : 2269 100