Detailed Explanation of Question 6(Query 3)
The pattern window will try to search for each record's corresponding (stop date) pair where weighted price is 100 times,
e.g. if in record 1, weighted price is, 2(which considered as start date) then pattern window will try to search its corresponding (stop date) partner where weighted price will be, (2*100)->200 or more than that.
The start date will be the date, where weighted price is 2. And the resultant stop date is, the date where weighted price is 200.
(If this condition is not satisfied then record after weighted price 2, is taken to match the pattern and this continues till last record of the CSV file).
In next iteration pattern will start searching start and stop date, for physically exact next record after weighted price 2(in this case).