Merge 66 files in one CSV File - Small Task

The task consists of merging 66 individual historical price files (each representing a separate financial instrument) into unified CSV datasets.

Source data characteristics:

Timeframe: 1-minute bars

Historical range: from 2011-01-01 up to the most recent available data in 2025

Each source file contains OHLC data; only the Close price is required

All instruments share the same timestamp structure

Required Outputs
1) Unified 1-Minute CSV File

Create one large comma-delimited CSV file with the following structure:

Total columns: 67

Column 1: Date

Format: YYYY-MM-DD HH:MM:SS

Continuous 1-minute timestamps starting from 2011-01-01 00:00:00

Columns 2–67: one column per instrument (e.g., EURUSD, EURCHF, etc.)

Each column contains only the Close price


File format: comma-delimited CSV

Encoding: UTF-8



2) Unified Hourly CSV File

Using the 1-minute master CSV from step 1, generate a second file with hourly bars:

Column structure as the 1-minute file

Date column format: YYYY-MM-DD HH:MM:SS

One row per hour

Each price represents the Close price of the completed hour

Historical range starts from 2011-01-01

File format: comma-delimited CSV

Details are in attach.