1. Sort the tick data in chronological order for subsequent processing.

2. According to the month grouping, take out the minute transaction point data of each month.

3. Calculate the opening price, closing price, highest price and lowest price of each month. You can choose to use the price of the first tick of each month as the opening price, the price of the last tick as the closing price, and the highest and lowest prices of all tick of that month.

4. To calculate the monthly turnover, you can choose to use the sum of all the turnover points of this month.

5. Organize the opening price, closing price, highest price, lowest price and volume of each month into a monthly data and save it in the corresponding data table.