Keep data available at high volumes sync option

Hi, I wanted to ask something related to this sync data in record types. As we know, after the record type exceeds 4 million rows, the record data will become unavailable. But we need more than 4 million rows of data from the database, and now I want to use source filters to divide up that large data source into multiple record types, based on timestamp.

And the question is how would you do this and what could be the best way so we can have only 4 million latest data synced, but others to be stored in another record type?

Thank you