Quote from igrimsley:
OK, this is my first post after 2 years of lurking. I have attached an excel summary of 5 stocks 15 min data including volume by time of day.
The columns are as follows:
Time in 15 min segments
15 min volume
15 min volume as % of 20 day average volume
HOD: when that 15 min period includes the high of the day
LOD: when that 15 min period includes the low of the day
HOD%: % of time the high falls in that time segment
HOD Cum %: % of time high has been set by that time segment
LOD%: % of time the low falls in that segment
LOD Cum %: % of time the low has been set by that time segment
Combined: % of time that the high,, low or both has been set by that time segment. Note the calculation for this is 1-((1-HODcum%)*(1-LODCum%)).
Range15: 15 min range in $
Range15%: 15 min range as a % of the 20 day average range
STDEV: standard deviation of the range for each 15 min segment compared to that time segment on all days.
Cum Range: cumulative range in $
Cum range as % of 20 day average range
Lose Zone: this is a cumulative total of whther the opposite "stretch" has been reached by that time segment. If you were to go long at a predetermined point above the open, this field shows whether the same point below the open would have been reached - in other words, if you play an ORB, this shows which time periods provide your losses.
Cum Vol: Cumulative volume by time segment.
There are some interesting things in here. For example, by 11:00, about 70% of the day's range has been eaten up.
The high or low has been set by 10:00 between 48% and 63% of the time.
33% of the day's volume has been traded by 11:00.
The stats are pretty consistent among the stocks.