Yes, this is absolutely correct and I do understand it. This is also what my tests showed. 

The only problem I see is that when I end up with 300 files...

I think my abstraction with dates brought a bit of confusion. I just used it to see how it handles the file.

What I ultimately need to do is...

Many thanks for your reply.
I did some more tests and it only made it more intriguing.

1. I took a sample of 7 days of data
2. I created a table partitioned...