Thanks a lot for all the replies.

I really like the idea of having the date column and using it as the partition column. The first idea was...