Best Practices for Importing Historical Data from CSV Files

I’m planning to import a large number of CSV files containing historical data into our system. To ensure a smooth process, I’d like to understand the best practices for this import. Specifically, I want to ensure that the resulting HDB files do not exceed the 500MB threshold, that data is segregated by day, and that the system remains stable without crashing.

Please share your recommendations and any relevant guidelines to achieve these goals efficiently.