Optimize large table design
I was able to split the table up as described above.  Since I did not know the data generation time a priori, the approach above did give a 6 to 10 times speed up on queries.