In general, there is a base of 29 million lines. There is a permanent record in it, and you also need to constantly receive data from it.
Parting, it seems, is a way out, but I don’t see an example, so I doubt it more. There is an example - creating a table every day, another one suggests writing to different tables, but I just need to add an existing table for months and create a new table with data for the last week, that is, it will overlap from the data in the current table and the data for current month.