Thanks for the reply, Lynn. I actually meant 2 folders, not 2 files. It's almost like it's not reading all the files in the 2nd folder.
It's a simple count aggregation by date and another column. It works fine if I do a single date, but once I comment out the date filter, the result is skewed. Very puzzling.