That is a lot of data you have under the pivot table.

I like this post with "historical" data showing the pattern, and then you give us a detailed view (even if it's only the last several weeks for that Ticker).

Looking forward to seeing the Q3 summary.