crn_transform.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "944fd2ca-925d-4a71-93a8-72d0576f610a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import glob\n",
    "import os\n",
    "from os import listdir\n",
    "from tqdm import tqdm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6dfbea82-4a08-4b4c-b441-467966962af1",
   "metadata": {},
   "outputs": [],
   "source": [
    "headers='WBANNO UTC_DATE UTC_TIME LST_DATE LST_TIME CRX_VN LONGITUDE LATITUDE AIR_TEMPERATURE PRECIPITATION SOLAR_RADIATION SR_FLAG SURFACE_TEMPERATURE ST_TYPE ST_FLAG RELATIVE_HUMIDITY RH_FLAG SOIL_MOISTURE_5 SOIL_TEMPERATURE_5 WETNESS WET_FLAG WIND_1_5 WIND_FLAG'\n",
    "headers = headers.split(' ')\n",
    "\n",
    "agg= []\n",
    "dir_path = 'CRNS0101-05-202309180550/2023'\n",
    "start_date = pd.Timestamp('2023-09-11T15:10:00')\n",
    "for fname in tqdm(listdir(dir_path)):\n",
    "    df = pd.read_fwf(dir_path + '/' + fname, names= headers)\n",
    "    df['UTC_DATE'] = pd.to_numeric(df['UTC_DATE'], downcast='integer', errors='coerce')\n",
    "    df.dropna(inplace=True)\n",
    "    df['UTC_DATE'] = df['UTC_DATE'].astype(int)\n",
    "    df['UTC_TIME'] = df['UTC_TIME'].astype(float)\n",
    "    df['UTC_TIME'] = df['UTC_TIME'].astype(int)\n",
    "    df['UTC_TIME'] = df['UTC_TIME'].apply('{0:0>4}'.format)\n",
    "    df['DATETIME'] = pd.to_datetime(df['UTC_DATE'].astype(str)  + df['UTC_TIME'].astype(str), format='%Y%m%d%H%M')\n",
    "    df = df[df['DATETIME'] >= start_date]\n",
    "    cols_to_order = ['DATETIME']\n",
    "    new_columns = cols_to_order + (df.columns.drop(cols_to_order).tolist())\n",
    "    df = df[new_columns]\n",
    "    agg.append(df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 193,
   "id": "a1371512-f5f0-4f76-9d14-fa73d2b2fae8",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|████████████████████████████████████| 1883/1883 [00:00<00:00, 21255.47it/s]"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2023-09-11 15:10:00\n",
      "2023-09-11 15:15:00\n",
      "2023-09-11 15:20:00\n",
      "2023-09-11 15:25:00\n",
      "2023-09-11 15:30:00\n",
      "2023-09-11 15:35:00\n",
      "2023-09-11 15:40:00\n",
      "2023-09-11 15:45:00\n",
      "2023-09-11 15:50:00\n",
      "2023-09-11 15:55:00\n",
      "2023-09-11 16:00:00\n",
      "2023-09-11 16:05:00\n",
      "2023-09-11 16:10:00\n",
      "2023-09-11 16:15:00\n",
      "2023-09-11 16:20:00\n",
      "2023-09-11 16:25:00\n",
      "2023-09-11 16:30:00\n",
      "2023-09-11 16:35:00\n",
      "2023-09-11 16:40:00\n",
      "2023-09-11 16:45:00\n",
      "2023-09-11 16:50:00\n",
      "2023-09-11 16:55:00\n",
      "2023-09-11 17:00:00\n",
      "2023-09-11 17:05:00\n",
      "2023-09-11 17:10:00\n",
      "2023-09-11 17:15:00\n",
      "2023-09-11 17:20:00\n",
      "2023-09-11 17:25:00\n",
      "2023-09-11 17:30:00\n",
      "2023-09-11 17:35:00\n",
      "2023-09-11 17:40:00\n",
      "2023-09-11 17:45:00\n",
      "2023-09-11 17:50:00\n",
      "2023-09-11 17:55:00\n",
      "2023-09-11 18:00:00\n",
      "2023-09-11 18:05:00\n",
      "2023-09-11 18:10:00\n",
      "2023-09-11 18:15:00\n",
      "2023-09-11 18:20:00\n",
      "2023-09-11 18:25:00\n",
      "2023-09-11 18:30:00\n",
      "2023-09-11 18:35:00\n",
      "2023-09-11 18:40:00\n",
      "2023-09-11 18:45:00\n",
      "2023-09-11 18:50:00\n",
      "2023-09-11 18:55:00\n",
      "2023-09-11 19:00:00\n",
      "2023-09-11 19:05:00\n",
      "2023-09-11 19:10:00\n",
      "2023-09-11 19:15:00\n",
      "2023-09-11 19:20:00\n",
      "2023-09-11 19:25:00\n",
      "2023-09-11 19:30:00\n",
      "2023-09-11 19:35:00\n",
      "2023-09-11 19:40:00\n",
      "2023-09-11 19:45:00\n",
      "2023-09-11 19:50:00\n",
      "2023-09-11 19:55:00\n",
      "2023-09-11 20:00:00\n",
      "2023-09-11 20:05:00\n",
      "2023-09-11 20:10:00\n",
      "2023-09-11 20:15:00\n",
      "2023-09-11 20:20:00\n",
      "2023-09-11 20:25:00\n",
      "2023-09-11 20:30:00\n",
      "2023-09-11 20:35:00\n",
      "2023-09-11 20:40:00\n",
      "2023-09-11 20:45:00\n",
      "2023-09-11 20:50:00\n",
      "2023-09-11 20:55:00\n",
      "2023-09-11 21:00:00\n",
      "2023-09-11 21:05:00\n",
      "2023-09-11 21:10:00\n",
      "2023-09-11 21:15:00\n",
      "2023-09-11 21:20:00\n",
      "2023-09-11 21:25:00\n",
      "2023-09-11 21:30:00\n",
      "2023-09-11 21:35:00\n",
      "2023-09-11 21:40:00\n",
      "2023-09-11 21:45:00\n",
      "2023-09-11 21:50:00\n",
      "2023-09-11 21:55:00\n",
      "2023-09-11 22:00:00\n",
      "2023-09-11 22:05:00\n",
      "2023-09-11 22:10:00\n",
      "2023-09-11 22:15:00\n",
      "2023-09-11 22:20:00\n",
      "2023-09-11 22:25:00\n",
      "2023-09-11 22:30:00\n",
      "2023-09-11 22:35:00\n",
      "2023-09-11 22:40:00\n",
      "2023-09-11 22:45:00\n",
      "2023-09-11 22:50:00\n",
      "2023-09-11 22:55:00\n",
      "2023-09-11 23:00:00\n",
      "2023-09-11 23:05:00\n",
      "2023-09-11 23:10:00\n",
      "2023-09-11 23:15:00\n",
      "2023-09-11 23:20:00\n",
      "2023-09-11 23:25:00\n",
      "2023-09-11 23:30:00\n",
      "2023-09-11 23:35:00\n",
      "2023-09-11 23:40:00\n",
      "2023-09-11 23:45:00\n",
      "2023-09-11 23:50:00\n",
      "2023-09-11 23:55:00\n",
      "2023-09-12 00:00:00\n",
      "2023-09-12 00:05:00\n",
      "2023-09-12 00:10:00\n",
      "2023-09-12 00:15:00\n",
      "2023-09-12 00:20:00\n",
      "2023-09-12 00:25:00\n",
      "2023-09-12 00:30:00\n",
      "2023-09-12 00:35:00\n",
      "2023-09-12 00:40:00\n",
      "2023-09-12 00:45:00\n",
      "2023-09-12 00:50:00\n",
      "2023-09-12 00:55:00\n",
      "2023-09-12 01:00:00\n",
      "2023-09-12 01:05:00\n",
      "2023-09-12 01:10:00\n",
      "2023-09-12 01:15:00\n",
      "2023-09-12 01:20:00\n",
      "2023-09-12 01:25:00\n",
      "2023-09-12 01:30:00\n",
      "2023-09-12 01:35:00\n",
      "2023-09-12 01:40:00\n",
      "2023-09-12 01:45:00\n",
      "2023-09-12 01:50:00\n",
      "2023-09-12 01:55:00\n",
      "2023-09-12 02:00:00\n",
      "2023-09-12 02:05:00\n",
      "2023-09-12 02:10:00\n",
      "2023-09-12 02:15:00\n",
      "2023-09-12 02:20:00\n",
      "2023-09-12 02:25:00\n",
      "2023-09-12 02:30:00\n",
      "2023-09-12 02:35:00\n",
      "2023-09-12 02:40:00\n",
      "2023-09-12 02:45:00\n",
      "2023-09-12 02:50:00\n",
      "2023-09-12 02:55:00\n",
      "2023-09-12 03:00:00\n",
      "2023-09-12 03:05:00\n",
      "2023-09-12 03:10:00\n",
      "2023-09-12 03:15:00\n",
      "2023-09-12 03:20:00\n",
      "2023-09-12 03:25:00\n",
      "2023-09-12 03:30:00\n",
      "2023-09-12 03:35:00\n",
      "2023-09-12 03:40:00\n",
      "2023-09-12 03:45:00\n",
      "2023-09-12 03:50:00\n",
      "2023-09-12 03:55:00\n",
      "2023-09-12 04:00:00\n",
      "2023-09-12 04:05:00\n",
      "2023-09-12 04:10:00\n",
      "2023-09-12 04:15:00\n",
      "2023-09-12 04:20:00\n",
      "2023-09-12 04:25:00\n",
      "2023-09-12 04:30:00\n",
      "2023-09-12 04:35:00\n",
      "2023-09-12 04:40:00\n",
      "2023-09-12 04:45:00\n",
      "2023-09-12 04:50:00\n",
      "2023-09-12 04:55:00\n",
      "2023-09-12 05:00:00\n",
      "2023-09-12 05:05:00\n",
      "2023-09-12 05:10:00\n",
      "2023-09-12 05:15:00\n",
      "2023-09-12 05:20:00\n",
      "2023-09-12 05:25:00\n",
      "2023-09-12 05:30:00\n",
      "2023-09-12 05:35:00\n",
      "2023-09-12 05:40:00\n",
      "2023-09-12 05:45:00\n",
      "2023-09-12 05:50:00\n",
      "2023-09-12 05:55:00\n",
      "2023-09-12 06:00:00\n",
      "2023-09-12 06:05:00\n",
      "2023-09-12 06:10:00\n",
      "2023-09-12 06:15:00\n",
      "2023-09-12 06:20:00\n",
      "2023-09-12 06:25:00\n",
      "2023-09-12 06:30:00\n",
      "2023-09-12 06:35:00\n",
      "2023-09-12 06:40:00\n",
      "2023-09-12 06:45:00\n",
      "2023-09-12 06:50:00\n",
      "2023-09-12 06:55:00\n",
      "2023-09-12 07:00:00\n",
      "2023-09-12 07:05:00\n",
      "2023-09-12 07:10:00\n",
      "2023-09-12 07:15:00\n",
      "2023-09-12 07:20:00\n",
      "2023-09-12 07:25:00\n",
      "2023-09-12 07:30:00\n",
      "2023-09-12 07:35:00\n",
      "2023-09-12 07:40:00\n",
      "2023-09-12 07:45:00\n",
      "2023-09-12 07:50:00\n",
      "2023-09-12 07:55:00\n",
      "2023-09-12 08:00:00\n",
      "2023-09-12 08:05:00\n",
      "2023-09-12 08:10:00\n",
      "2023-09-12 08:15:00\n",
      "2023-09-12 08:20:00\n",
      "2023-09-12 08:25:00\n",
      "2023-09-12 08:30:00\n",
      "2023-09-12 08:35:00\n",
      "2023-09-12 08:40:00\n",
      "2023-09-12 08:45:00\n",
      "2023-09-12 08:50:00\n",
      "2023-09-12 08:55:00\n",
      "2023-09-12 09:00:00\n",
      "2023-09-12 09:05:00\n",
      "2023-09-12 09:10:00\n",
      "2023-09-12 09:15:00\n",
      "2023-09-12 09:20:00\n",
      "2023-09-12 09:25:00\n",
      "2023-09-12 09:30:00\n",
      "2023-09-12 09:35:00\n",
      "2023-09-12 09:40:00\n",
      "2023-09-12 09:45:00\n",
      "2023-09-12 09:50:00\n",
      "2023-09-12 09:55:00\n",
      "2023-09-12 10:00:00\n",
      "2023-09-12 10:05:00\n",
      "2023-09-12 10:10:00\n",
      "2023-09-12 10:15:00\n",
      "2023-09-12 10:20:00\n",
      "2023-09-12 10:25:00\n",
      "2023-09-12 10:30:00\n",
      "2023-09-12 10:35:00\n",
      "2023-09-12 10:40:00\n",
      "2023-09-12 10:45:00\n",
      "2023-09-12 10:50:00\n",
      "2023-09-12 10:55:00\n",
      "2023-09-12 11:00:00\n",
      "2023-09-12 11:05:00\n",
      "2023-09-12 11:10:00\n",
      "2023-09-12 11:15:00\n",
      "2023-09-12 11:20:00\n",
      "2023-09-12 11:25:00\n",
      "2023-09-12 11:30:00\n",
      "2023-09-12 11:35:00\n",
      "2023-09-12 11:40:00\n",
      "2023-09-12 11:45:00\n",
      "2023-09-12 11:50:00\n",
      "2023-09-12 11:55:00\n",
      "2023-09-12 12:00:00\n",
      "2023-09-12 12:05:00\n",
      "2023-09-12 12:10:00\n",
      "2023-09-12 12:15:00\n",
      "2023-09-12 12:20:00\n",
      "2023-09-12 12:25:00\n",
      "2023-09-12 12:30:00\n",
      "2023-09-12 12:35:00\n",
      "2023-09-12 12:40:00\n",
      "2023-09-12 12:45:00\n",
      "2023-09-12 12:50:00\n",
      "2023-09-12 12:55:00\n",
      "2023-09-12 13:00:00\n",
      "2023-09-12 13:05:00\n",
      "2023-09-12 13:10:00\n",
      "2023-09-12 13:15:00\n",
      "2023-09-12 13:20:00\n",
      "2023-09-12 13:25:00\n",
      "2023-09-12 13:30:00\n",
      "2023-09-12 13:35:00\n",
      "2023-09-12 13:40:00\n",
      "2023-09-12 13:45:00\n",
      "2023-09-12 13:50:00\n",
      "2023-09-12 13:55:00\n",
      "2023-09-12 14:00:00\n",
      "2023-09-12 14:05:00\n",
      "2023-09-12 14:10:00\n",
      "2023-09-12 14:15:00\n",
      "2023-09-12 14:20:00\n",
      "2023-09-12 14:25:00\n",
      "2023-09-12 14:30:00\n",
      "2023-09-12 14:35:00\n",
      "2023-09-12 14:40:00\n",
      "2023-09-12 14:45:00\n",
      "2023-09-12 14:50:00\n",
      "2023-09-12 14:55:00\n",
      "2023-09-12 15:00:00\n",
      "2023-09-12 15:05:00\n",
      "2023-09-12 15:10:00\n",
      "2023-09-12 15:15:00\n",
      "2023-09-12 15:20:00\n",
      "2023-09-12 15:25:00\n",
      "2023-09-12 15:30:00\n",
      "2023-09-12 15:35:00\n",
      "2023-09-12 15:40:00\n",
      "2023-09-12 15:45:00\n",
      "2023-09-12 15:50:00\n",
      "2023-09-12 15:55:00\n",
      "2023-09-12 16:00:00\n",
      "2023-09-12 16:05:00\n",
      "2023-09-12 16:10:00\n",
      "2023-09-12 16:15:00\n",
      "2023-09-12 16:20:00\n",
      "2023-09-12 16:25:00\n",
      "2023-09-12 16:30:00\n",
      "2023-09-12 16:35:00\n",
      "2023-09-12 16:40:00\n",
      "2023-09-12 16:45:00\n",
      "2023-09-12 16:50:00\n",
      "2023-09-12 16:55:00\n",
      "2023-09-12 17:00:00\n",
      "2023-09-12 17:05:00\n",
      "2023-09-12 17:10:00\n",
      "2023-09-12 17:15:00\n",
      "2023-09-12 17:20:00\n",
      "2023-09-12 17:25:00\n",
      "2023-09-12 17:30:00\n",
      "2023-09-12 17:35:00\n",
      "2023-09-12 17:40:00\n",
      "2023-09-12 17:45:00\n",
      "2023-09-12 17:50:00\n",
      "2023-09-12 17:55:00\n",
      "2023-09-12 18:00:00\n",
      "2023-09-12 18:05:00\n",
      "2023-09-12 18:10:00\n",
      "2023-09-12 18:15:00\n",
      "2023-09-12 18:20:00\n",
      "2023-09-12 18:25:00\n",
      "2023-09-12 18:30:00\n",
      "2023-09-12 18:35:00\n",
      "2023-09-12 18:40:00\n",
      "2023-09-12 18:45:00\n",
      "2023-09-12 18:50:00\n",
      "2023-09-12 18:55:00\n",
      "2023-09-12 19:00:00\n",
      "2023-09-12 19:05:00\n",
      "2023-09-12 19:10:00\n",
      "2023-09-12 19:15:00\n",
      "2023-09-12 19:20:00\n",
      "2023-09-12 19:25:00\n",
      "2023-09-12 19:30:00\n",
      "2023-09-12 19:35:00\n",
      "2023-09-12 19:40:00\n",
      "2023-09-12 19:45:00\n",
      "2023-09-12 19:50:00\n",
      "2023-09-12 19:55:00\n",
      "2023-09-12 20:00:00\n",
      "2023-09-12 20:05:00\n",
      "2023-09-12 20:10:00\n",
      "2023-09-12 20:15:00\n",
      "2023-09-12 20:20:00\n",
      "2023-09-12 20:25:00\n",
      "2023-09-12 20:30:00\n",
      "2023-09-12 20:35:00\n",
      "2023-09-12 20:40:00\n",
      "2023-09-12 20:45:00\n",
      "2023-09-12 20:50:00\n",
      "2023-09-12 20:55:00\n",
      "2023-09-12 21:00:00\n",
      "2023-09-12 21:05:00\n",
      "2023-09-12 21:10:00\n",
      "2023-09-12 21:15:00\n",
      "2023-09-12 21:20:00\n",
      "2023-09-12 21:25:00\n",
      "2023-09-12 21:30:00\n",
      "2023-09-12 21:35:00\n",
      "2023-09-12 21:40:00\n",
      "2023-09-12 21:45:00\n",
      "2023-09-12 21:50:00\n",
      "2023-09-12 21:55:00\n",
      "2023-09-12 22:00:00\n",
      "2023-09-12 22:05:00\n",
      "2023-09-12 22:10:00\n",
      "2023-09-12 22:15:00\n",
      "2023-09-12 22:20:00\n",
      "2023-09-12 22:25:00\n",
      "2023-09-12 22:30:00\n",
      "2023-09-12 22:35:00\n",
      "2023-09-12 22:40:00\n",
      "2023-09-12 22:45:00\n",
      "2023-09-12 22:50:00\n",
      "2023-09-12 22:55:00\n",
      "2023-09-12 23:00:00\n",
      "2023-09-12 23:05:00\n",
      "2023-09-12 23:10:00\n",
      "2023-09-12 23:15:00\n",
      "2023-09-12 23:20:00\n",
      "2023-09-12 23:25:00\n",
      "2023-09-12 23:30:00\n",
      "2023-09-12 23:35:00\n",
      "2023-09-12 23:40:00\n",
      "2023-09-12 23:45:00\n",
      "2023-09-12 23:50:00\n",
      "2023-09-12 23:55:00\n",
      "2023-09-13 00:00:00\n",
      "2023-09-13 00:05:00\n",
      "2023-09-13 00:10:00\n",
      "2023-09-13 00:15:00\n",
      "2023-09-13 00:20:00\n",
      "2023-09-13 00:25:00\n",
      "2023-09-13 00:30:00\n",
      "2023-09-13 00:35:00\n",
      "2023-09-13 00:40:00\n",
      "2023-09-13 00:45:00\n",
      "2023-09-13 00:50:00\n",
      "2023-09-13 00:55:00\n",
      "2023-09-13 01:00:00\n",
      "2023-09-13 01:05:00\n",
      "2023-09-13 01:10:00\n",
      "2023-09-13 01:15:00\n",
      "2023-09-13 01:20:00\n",
      "2023-09-13 01:25:00\n",
      "2023-09-13 01:30:00\n",
      "2023-09-13 01:35:00\n",
      "2023-09-13 01:40:00\n",
      "2023-09-13 01:45:00\n",
      "2023-09-13 01:50:00\n",
      "2023-09-13 01:55:00\n",
      "2023-09-13 02:00:00\n",
      "2023-09-13 02:05:00\n",
      "2023-09-13 02:10:00\n",
      "2023-09-13 02:15:00\n",
      "2023-09-13 02:20:00\n",
      "2023-09-13 02:25:00\n",
      "2023-09-13 02:30:00\n",
      "2023-09-13 02:35:00\n",
      "2023-09-13 02:40:00\n",
      "2023-09-13 02:45:00\n",
      "2023-09-13 02:50:00\n",
      "2023-09-13 02:55:00\n",
      "2023-09-13 03:00:00\n",
      "2023-09-13 03:05:00\n",
      "2023-09-13 03:10:00\n",
      "2023-09-13 03:15:00\n",
      "2023-09-13 03:20:00\n",
      "2023-09-13 03:25:00\n",
      "2023-09-13 03:30:00\n",
      "2023-09-13 03:35:00\n",
      "2023-09-13 03:40:00\n",
      "2023-09-13 03:45:00\n",
      "2023-09-13 03:50:00\n",
      "2023-09-13 03:55:00\n",
      "2023-09-13 04:00:00\n",
      "2023-09-13 04:05:00\n",
      "2023-09-13 04:10:00\n",
      "2023-09-13 04:15:00\n",
      "2023-09-13 04:20:00\n",
      "2023-09-13 04:25:00\n",
      "2023-09-13 04:30:00\n",
      "2023-09-13 04:35:00\n",
      "2023-09-13 04:40:00\n",
      "2023-09-13 04:45:00\n",
      "2023-09-13 04:50:00\n",
      "2023-09-13 04:55:00\n",
      "2023-09-13 05:00:00\n",
      "2023-09-13 05:05:00\n",
      "2023-09-13 05:10:00\n",
      "2023-09-13 05:15:00\n",
      "2023-09-13 05:20:00\n",
      "2023-09-13 05:25:00\n",
      "2023-09-13 05:30:00\n",
      "2023-09-13 05:35:00\n",
      "2023-09-13 05:40:00\n",
      "2023-09-13 05:45:00\n",
      "2023-09-13 05:50:00\n",
      "2023-09-13 05:55:00\n",
      "2023-09-13 06:00:00\n",
      "2023-09-13 06:05:00\n",
      "2023-09-13 06:10:00\n",
      "2023-09-13 06:15:00\n",
      "2023-09-13 06:20:00\n",
      "2023-09-13 06:25:00\n",
      "2023-09-13 06:30:00\n",
      "2023-09-13 06:35:00\n",
      "2023-09-13 06:40:00\n",
      "2023-09-13 06:45:00\n",
      "2023-09-13 06:50:00\n",
      "2023-09-13 06:55:00\n",
      "2023-09-13 07:00:00\n",
      "2023-09-13 07:05:00\n",
      "2023-09-13 07:10:00\n",
      "2023-09-13 07:15:00\n",
      "2023-09-13 07:20:00\n",
      "2023-09-13 07:25:00\n",
      "2023-09-13 07:30:00\n",
      "2023-09-13 07:35:00\n",
      "2023-09-13 07:40:00\n",
      "2023-09-13 07:45:00\n",
      "2023-09-13 07:50:00\n",
      "2023-09-13 07:55:00\n",
      "2023-09-13 08:00:00\n",
      "2023-09-13 08:05:00\n",
      "2023-09-13 08:10:00\n",
      "2023-09-13 08:15:00\n",
      "2023-09-13 08:20:00\n",
      "2023-09-13 08:25:00\n",
      "2023-09-13 08:30:00\n",
      "2023-09-13 08:35:00\n",
      "2023-09-13 08:40:00\n",
      "2023-09-13 08:45:00\n",
      "2023-09-13 08:50:00\n",
      "2023-09-13 08:55:00\n",
      "2023-09-13 09:00:00\n",
      "2023-09-13 09:05:00\n",
      "2023-09-13 09:10:00\n",
      "2023-09-13 09:15:00\n",
      "2023-09-13 09:20:00\n",
      "2023-09-13 09:25:00\n",
      "2023-09-13 09:30:00\n",
      "2023-09-13 09:35:00\n",
      "2023-09-13 09:40:00\n",
      "2023-09-13 09:45:00\n",
      "2023-09-13 09:50:00\n",
      "2023-09-13 09:55:00\n",
      "2023-09-13 10:00:00\n",
      "2023-09-13 10:05:00\n",
      "2023-09-13 10:10:00\n",
      "2023-09-13 10:15:00\n",
      "2023-09-13 10:20:00\n",
      "2023-09-13 10:25:00\n",
      "2023-09-13 10:30:00\n",
      "2023-09-13 10:35:00\n",
      "2023-09-13 10:40:00\n",
      "2023-09-13 10:45:00\n",
      "2023-09-13 10:50:00\n",
      "2023-09-13 10:55:00\n",
      "2023-09-13 11:00:00\n",
      "2023-09-13 11:05:00\n",
      "2023-09-13 11:10:00\n",
      "2023-09-13 11:15:00\n",
      "2023-09-13 11:20:00\n",
      "2023-09-13 11:25:00\n",
      "2023-09-13 11:30:00\n",
      "2023-09-13 11:35:00\n",
      "2023-09-13 11:40:00\n",
      "2023-09-13 11:45:00\n",
      "2023-09-13 11:50:00\n",
      "2023-09-13 11:55:00\n",
      "2023-09-13 12:00:00\n",
      "2023-09-13 12:05:00\n",
      "2023-09-13 12:10:00\n",
      "2023-09-13 12:15:00\n",
      "2023-09-13 12:20:00\n",
      "2023-09-13 12:25:00\n",
      "2023-09-13 12:30:00\n",
      "2023-09-13 12:35:00\n",
      "2023-09-13 12:40:00\n",
      "2023-09-13 12:45:00\n",
      "2023-09-13 12:50:00\n",
      "2023-09-13 12:55:00\n",
      "2023-09-13 13:00:00\n",
      "2023-09-13 13:05:00\n",
      "2023-09-13 13:10:00\n",
      "2023-09-13 13:15:00\n",
      "2023-09-13 13:20:00\n",
      "2023-09-13 13:25:00\n",
      "2023-09-13 13:30:00\n",
      "2023-09-13 13:35:00\n",
      "2023-09-13 13:40:00\n",
      "2023-09-13 13:45:00\n",
      "2023-09-13 13:50:00\n",
      "2023-09-13 13:55:00\n",
      "2023-09-13 14:00:00\n",
      "2023-09-13 14:05:00\n",
      "2023-09-13 14:10:00\n",
      "2023-09-13 14:15:00\n",
      "2023-09-13 14:20:00\n",
      "2023-09-13 14:25:00\n",
      "2023-09-13 14:30:00\n",
      "2023-09-13 14:35:00\n",
      "2023-09-13 14:40:00\n",
      "2023-09-13 14:45:00\n",
      "2023-09-13 14:50:00\n",
      "2023-09-13 14:55:00\n",
      "2023-09-13 15:00:00\n",
      "2023-09-13 15:05:00\n",
      "2023-09-13 15:10:00\n",
      "2023-09-13 15:15:00\n",
      "2023-09-13 15:20:00\n",
      "2023-09-13 15:25:00\n",
      "2023-09-13 15:30:00\n",
      "2023-09-13 15:35:00\n",
      "2023-09-13 15:40:00\n",
      "2023-09-13 15:45:00\n",
      "2023-09-13 15:50:00\n",
      "2023-09-13 15:55:00\n",
      "2023-09-13 16:00:00\n",
      "2023-09-13 16:05:00\n",
      "2023-09-13 16:10:00\n",
      "2023-09-13 16:15:00\n",
      "2023-09-13 16:20:00\n",
      "2023-09-13 16:25:00\n",
      "2023-09-13 16:30:00\n",
      "2023-09-13 16:35:00\n",
      "2023-09-13 16:40:00\n",
      "2023-09-13 16:45:00\n",
      "2023-09-13 16:50:00\n",
      "2023-09-13 16:55:00\n",
      "2023-09-13 17:00:00\n",
      "2023-09-13 17:05:00\n",
      "2023-09-13 17:10:00\n",
      "2023-09-13 17:15:00\n",
      "2023-09-13 17:20:00\n",
      "2023-09-13 17:25:00\n",
      "2023-09-13 17:30:00\n",
      "2023-09-13 17:35:00\n",
      "2023-09-13 17:40:00\n",
      "2023-09-13 17:45:00\n",
      "2023-09-13 17:50:00\n",
      "2023-09-13 17:55:00\n",
      "2023-09-13 18:00:00\n",
      "2023-09-13 18:05:00\n",
      "2023-09-13 18:10:00\n",
      "2023-09-13 18:15:00\n",
      "2023-09-13 18:20:00\n",
      "2023-09-13 18:25:00\n",
      "2023-09-13 18:30:00\n",
      "2023-09-13 18:35:00\n",
      "2023-09-13 18:40:00\n",
      "2023-09-13 18:45:00\n",
      "2023-09-13 18:50:00\n",
      "2023-09-13 18:55:00\n",
      "2023-09-13 19:00:00\n",
      "2023-09-13 19:05:00\n",
      "2023-09-13 19:10:00\n",
      "2023-09-13 19:15:00\n",
      "2023-09-13 19:20:00\n",
      "2023-09-13 19:25:00\n",
      "2023-09-13 19:30:00\n",
      "2023-09-13 19:35:00\n",
      "2023-09-13 19:40:00\n",
      "2023-09-13 19:45:00\n",
      "2023-09-13 19:50:00\n",
      "2023-09-13 19:55:00\n",
      "2023-09-13 20:00:00\n",
      "2023-09-13 20:05:00\n",
      "2023-09-13 20:10:00\n",
      "2023-09-13 20:15:00\n",
      "2023-09-13 20:20:00\n",
      "2023-09-13 20:25:00\n",
      "2023-09-13 20:30:00\n",
      "2023-09-13 20:35:00\n",
      "2023-09-13 20:40:00\n",
      "2023-09-13 20:45:00\n",
      "2023-09-13 20:50:00\n",
      "2023-09-13 20:55:00\n",
      "2023-09-13 21:00:00\n",
      "2023-09-13 21:05:00\n",
      "2023-09-13 21:10:00\n",
      "2023-09-13 21:15:00\n",
      "2023-09-13 21:20:00\n",
      "2023-09-13 21:25:00\n",
      "2023-09-13 21:30:00\n",
      "2023-09-13 21:35:00\n",
      "2023-09-13 21:40:00\n",
      "2023-09-13 21:45:00\n",
      "2023-09-13 21:50:00\n",
      "2023-09-13 21:55:00\n",
      "2023-09-13 22:00:00\n",
      "2023-09-13 22:05:00\n",
      "2023-09-13 22:10:00\n",
      "2023-09-13 22:15:00\n",
      "2023-09-13 22:20:00\n",
      "2023-09-13 22:25:00\n",
      "2023-09-13 22:30:00\n",
      "2023-09-13 22:35:00\n",
      "2023-09-13 22:40:00\n",
      "2023-09-13 22:45:00\n",
      "2023-09-13 22:50:00\n",
      "2023-09-13 22:55:00\n",
      "2023-09-13 23:00:00\n",
      "2023-09-13 23:05:00\n",
      "2023-09-13 23:10:00\n",
      "2023-09-13 23:15:00\n",
      "2023-09-13 23:20:00\n",
      "2023-09-13 23:25:00\n",
      "2023-09-13 23:30:00\n",
      "2023-09-13 23:35:00\n",
      "2023-09-13 23:40:00\n",
      "2023-09-13 23:45:00\n",
      "2023-09-13 23:50:00\n",
      "2023-09-13 23:55:00\n",
      "2023-09-14 00:00:00\n",
      "2023-09-14 00:05:00\n",
      "2023-09-14 00:10:00\n",
      "2023-09-14 00:15:00\n",
      "2023-09-14 00:20:00\n",
      "2023-09-14 00:25:00\n",
      "2023-09-14 00:30:00\n",
      "2023-09-14 00:35:00\n",
      "2023-09-14 00:40:00\n",
      "2023-09-14 00:45:00\n",
      "2023-09-14 00:50:00\n",
      "2023-09-14 00:55:00\n",
      "2023-09-14 01:00:00\n",
      "2023-09-14 01:05:00\n",
      "2023-09-14 01:10:00\n",
      "2023-09-14 01:15:00\n",
      "2023-09-14 01:20:00\n",
      "2023-09-14 01:25:00\n",
      "2023-09-14 01:30:00\n",
      "2023-09-14 01:35:00\n",
      "2023-09-14 01:40:00\n",
      "2023-09-14 01:45:00\n",
      "2023-09-14 01:50:00\n",
      "2023-09-14 01:55:00\n",
      "2023-09-14 02:00:00\n",
      "2023-09-14 02:05:00\n",
      "2023-09-14 02:10:00\n",
      "2023-09-14 02:15:00\n",
      "2023-09-14 02:20:00\n",
      "2023-09-14 02:25:00\n",
      "2023-09-14 02:30:00\n",
      "2023-09-14 02:35:00\n",
      "2023-09-14 02:40:00\n",
      "2023-09-14 02:45:00\n",
      "2023-09-14 02:50:00\n",
      "2023-09-14 02:55:00\n",
      "2023-09-14 03:00:00\n",
      "2023-09-14 03:05:00\n",
      "2023-09-14 03:10:00\n",
      "2023-09-14 03:15:00\n",
      "2023-09-14 03:20:00\n",
      "2023-09-14 03:25:00\n",
      "2023-09-14 03:30:00\n",
      "2023-09-14 03:35:00\n",
      "2023-09-14 03:40:00\n",
      "2023-09-14 03:45:00\n",
      "2023-09-14 03:50:00\n",
      "2023-09-14 03:55:00\n",
      "2023-09-14 04:00:00\n",
      "2023-09-14 04:05:00\n",
      "2023-09-14 04:10:00\n",
      "2023-09-14 04:15:00\n",
      "2023-09-14 04:20:00\n",
      "2023-09-14 04:25:00\n",
      "2023-09-14 04:30:00\n",
      "2023-09-14 04:35:00\n",
      "2023-09-14 04:40:00\n",
      "2023-09-14 04:45:00\n",
      "2023-09-14 04:50:00\n",
      "2023-09-14 04:55:00\n",
      "2023-09-14 05:00:00\n",
      "2023-09-14 05:05:00\n",
      "2023-09-14 05:10:00\n",
      "2023-09-14 05:15:00\n",
      "2023-09-14 05:20:00\n",
      "2023-09-14 05:25:00\n",
      "2023-09-14 05:30:00\n",
      "2023-09-14 05:35:00\n",
      "2023-09-14 05:40:00\n",
      "2023-09-14 05:45:00\n",
      "2023-09-14 05:50:00\n",
      "2023-09-14 05:55:00\n",
      "2023-09-14 06:00:00\n",
      "2023-09-14 06:05:00\n",
      "2023-09-14 06:10:00\n",
      "2023-09-14 06:15:00\n",
      "2023-09-14 06:20:00\n",
      "2023-09-14 06:25:00\n",
      "2023-09-14 06:30:00\n",
      "2023-09-14 06:35:00\n",
      "2023-09-14 06:40:00\n",
      "2023-09-14 06:45:00\n",
      "2023-09-14 06:50:00\n",
      "2023-09-14 06:55:00\n",
      "2023-09-14 07:00:00\n",
      "2023-09-14 07:05:00\n",
      "2023-09-14 07:10:00\n",
      "2023-09-14 07:15:00\n",
      "2023-09-14 07:20:00\n",
      "2023-09-14 07:25:00\n",
      "2023-09-14 07:30:00\n",
      "2023-09-14 07:35:00\n",
      "2023-09-14 07:40:00\n",
      "2023-09-14 07:45:00\n",
      "2023-09-14 07:50:00\n",
      "2023-09-14 07:55:00\n",
      "2023-09-14 08:00:00\n",
      "2023-09-14 08:05:00\n",
      "2023-09-14 08:10:00\n",
      "2023-09-14 08:15:00\n",
      "2023-09-14 08:20:00\n",
      "2023-09-14 08:25:00\n",
      "2023-09-14 08:30:00\n",
      "2023-09-14 08:35:00\n",
      "2023-09-14 08:40:00\n",
      "2023-09-14 08:45:00\n",
      "2023-09-14 08:50:00\n",
      "2023-09-14 08:55:00\n",
      "2023-09-14 09:00:00\n",
      "2023-09-14 09:05:00\n",
      "2023-09-14 09:10:00\n",
      "2023-09-14 09:15:00\n",
      "2023-09-14 09:20:00\n",
      "2023-09-14 09:25:00\n",
      "2023-09-14 09:30:00\n",
      "2023-09-14 09:35:00\n",
      "2023-09-14 09:40:00\n",
      "2023-09-14 09:45:00\n",
      "2023-09-14 09:50:00\n",
      "2023-09-14 09:55:00\n",
      "2023-09-14 10:00:00\n",
      "2023-09-14 10:05:00\n",
      "2023-09-14 10:10:00\n",
      "2023-09-14 10:15:00\n",
      "2023-09-14 10:20:00\n",
      "2023-09-14 10:25:00\n",
      "2023-09-14 10:30:00\n",
      "2023-09-14 10:35:00\n",
      "2023-09-14 10:40:00\n",
      "2023-09-14 10:45:00\n",
      "2023-09-14 10:50:00\n",
      "2023-09-14 10:55:00\n",
      "2023-09-14 11:00:00\n",
      "2023-09-14 11:05:00\n",
      "2023-09-14 11:10:00\n",
      "2023-09-14 11:15:00\n",
      "2023-09-14 11:20:00\n",
      "2023-09-14 11:25:00\n",
      "2023-09-14 11:30:00\n",
      "2023-09-14 11:35:00\n",
      "2023-09-14 11:40:00\n",
      "2023-09-14 11:45:00\n",
      "2023-09-14 11:50:00\n",
      "2023-09-14 11:55:00\n",
      "2023-09-14 12:00:00\n",
      "2023-09-14 12:05:00\n",
      "2023-09-14 12:10:00\n",
      "2023-09-14 12:15:00\n",
      "2023-09-14 12:20:00\n",
      "2023-09-14 12:25:00\n",
      "2023-09-14 12:30:00\n",
      "2023-09-14 12:35:00\n",
      "2023-09-14 12:40:00\n",
      "2023-09-14 12:45:00\n",
      "2023-09-14 12:50:00\n",
      "2023-09-14 12:55:00\n",
      "2023-09-14 13:00:00\n",
      "2023-09-14 13:05:00\n",
      "2023-09-14 13:10:00\n",
      "2023-09-14 13:15:00\n",
      "2023-09-14 13:20:00\n",
      "2023-09-14 13:25:00\n",
      "2023-09-14 13:30:00\n",
      "2023-09-14 13:35:00\n",
      "2023-09-14 13:40:00\n",
      "2023-09-14 13:45:00\n",
      "2023-09-14 13:50:00\n",
      "2023-09-14 13:55:00\n",
      "2023-09-14 14:00:00\n",
      "2023-09-14 14:05:00\n",
      "2023-09-14 14:10:00\n",
      "2023-09-14 14:15:00\n",
      "2023-09-14 14:20:00\n",
      "2023-09-14 14:25:00\n",
      "2023-09-14 14:30:00\n",
      "2023-09-14 14:35:00\n",
      "2023-09-14 14:40:00\n",
      "2023-09-14 14:45:00\n",
      "2023-09-14 14:50:00\n",
      "2023-09-14 14:55:00\n",
      "2023-09-14 15:00:00\n",
      "2023-09-14 15:05:00\n",
      "2023-09-14 15:10:00\n",
      "2023-09-14 15:15:00\n",
      "2023-09-14 15:20:00\n",
      "2023-09-14 15:25:00\n",
      "2023-09-14 15:30:00\n",
      "2023-09-14 15:35:00\n",
      "2023-09-14 15:40:00\n",
      "2023-09-14 15:45:00\n",
      "2023-09-14 15:50:00\n",
      "2023-09-14 15:55:00\n",
      "2023-09-14 16:00:00\n",
      "2023-09-14 16:05:00\n",
      "2023-09-14 16:10:00\n",
      "2023-09-14 16:15:00\n",
      "2023-09-14 16:20:00\n",
      "2023-09-14 16:25:00\n",
      "2023-09-14 16:30:00\n",
      "2023-09-14 16:35:00\n",
      "2023-09-14 16:40:00\n",
      "2023-09-14 16:45:00\n",
      "2023-09-14 16:50:00\n",
      "2023-09-14 16:55:00\n",
      "2023-09-14 17:00:00\n",
      "2023-09-14 17:05:00\n",
      "2023-09-14 17:10:00\n",
      "2023-09-14 17:15:00\n",
      "2023-09-14 17:20:00\n",
      "2023-09-14 17:25:00\n",
      "2023-09-14 17:30:00\n",
      "2023-09-14 17:35:00\n",
      "2023-09-14 17:40:00\n",
      "2023-09-14 17:45:00\n",
      "2023-09-14 17:50:00\n",
      "2023-09-14 17:55:00\n",
      "2023-09-14 18:00:00\n",
      "2023-09-14 18:05:00\n",
      "2023-09-14 18:10:00\n",
      "2023-09-14 18:15:00\n",
      "2023-09-14 18:20:00\n",
      "2023-09-14 18:25:00\n",
      "2023-09-14 18:30:00\n",
      "2023-09-14 18:35:00\n",
      "2023-09-14 18:40:00\n",
      "2023-09-14 18:45:00\n",
      "2023-09-14 18:50:00\n",
      "2023-09-14 18:55:00\n",
      "2023-09-14 19:00:00\n",
      "2023-09-14 19:05:00\n",
      "2023-09-14 19:10:00\n",
      "2023-09-14 19:15:00\n",
      "2023-09-14 19:20:00\n",
      "2023-09-14 19:25:00\n",
      "2023-09-14 19:30:00\n",
      "2023-09-14 19:35:00\n",
      "2023-09-14 19:40:00\n",
      "2023-09-14 19:45:00\n",
      "2023-09-14 19:50:00\n",
      "2023-09-14 19:55:00\n",
      "2023-09-14 20:00:00\n",
      "2023-09-14 20:05:00\n",
      "2023-09-14 20:10:00\n",
      "2023-09-14 20:15:00\n",
      "2023-09-14 20:20:00\n",
      "2023-09-14 20:25:00\n",
      "2023-09-14 20:30:00\n",
      "2023-09-14 20:35:00\n",
      "2023-09-14 20:40:00\n",
      "2023-09-14 20:45:00\n",
      "2023-09-14 20:50:00\n",
      "2023-09-14 20:55:00\n",
      "2023-09-14 21:00:00\n",
      "2023-09-14 21:05:00\n",
      "2023-09-14 21:10:00\n",
      "2023-09-14 21:15:00\n",
      "2023-09-14 21:20:00\n",
      "2023-09-14 21:25:00\n",
      "2023-09-14 21:30:00\n",
      "2023-09-14 21:35:00\n",
      "2023-09-14 21:40:00\n",
      "2023-09-14 21:45:00\n",
      "2023-09-14 21:50:00\n",
      "2023-09-14 21:55:00\n",
      "2023-09-14 22:00:00\n",
      "2023-09-14 22:05:00\n",
      "2023-09-14 22:10:00\n",
      "2023-09-14 22:15:00\n",
      "2023-09-14 22:20:00\n",
      "2023-09-14 22:25:00\n",
      "2023-09-14 22:30:00\n",
      "2023-09-14 22:35:00\n",
      "2023-09-14 22:40:00\n",
      "2023-09-14 22:45:00\n",
      "2023-09-14 22:50:00\n",
      "2023-09-14 22:55:00\n",
      "2023-09-14 23:00:00\n",
      "2023-09-14 23:05:00\n",
      "2023-09-14 23:10:00\n",
      "2023-09-14 23:15:00\n",
      "2023-09-14 23:20:00\n",
      "2023-09-14 23:25:00\n",
      "2023-09-14 23:30:00\n",
      "2023-09-14 23:35:00\n",
      "2023-09-14 23:40:00\n",
      "2023-09-14 23:45:00\n",
      "2023-09-14 23:50:00\n",
      "2023-09-14 23:55:00\n",
      "2023-09-15 00:00:00\n",
      "2023-09-15 00:05:00\n",
      "2023-09-15 00:10:00\n",
      "2023-09-15 00:15:00\n",
      "2023-09-15 00:20:00\n",
      "2023-09-15 00:25:00\n",
      "2023-09-15 00:30:00\n",
      "2023-09-15 00:35:00\n",
      "2023-09-15 00:40:00\n",
      "2023-09-15 00:45:00\n",
      "2023-09-15 00:50:00\n",
      "2023-09-15 00:55:00\n",
      "2023-09-15 01:00:00\n",
      "2023-09-15 01:05:00\n",
      "2023-09-15 01:10:00\n",
      "2023-09-15 01:15:00\n",
      "2023-09-15 01:20:00\n",
      "2023-09-15 01:25:00\n",
      "2023-09-15 01:30:00\n",
      "2023-09-15 01:35:00\n",
      "2023-09-15 01:40:00\n",
      "2023-09-15 01:45:00\n",
      "2023-09-15 01:50:00\n",
      "2023-09-15 01:55:00\n",
      "2023-09-15 02:00:00\n",
      "2023-09-15 02:05:00\n",
      "2023-09-15 02:10:00\n",
      "2023-09-15 02:15:00\n",
      "2023-09-15 02:20:00\n",
      "2023-09-15 02:25:00\n",
      "2023-09-15 02:30:00\n",
      "2023-09-15 02:35:00\n",
      "2023-09-15 02:40:00\n",
      "2023-09-15 02:45:00\n",
      "2023-09-15 02:50:00\n",
      "2023-09-15 02:55:00\n",
      "2023-09-15 03:00:00\n",
      "2023-09-15 03:05:00\n",
      "2023-09-15 03:10:00\n",
      "2023-09-15 03:15:00\n",
      "2023-09-15 03:20:00\n",
      "2023-09-15 03:25:00\n",
      "2023-09-15 03:30:00\n",
      "2023-09-15 03:35:00\n",
      "2023-09-15 03:40:00\n",
      "2023-09-15 03:45:00\n",
      "2023-09-15 03:50:00\n",
      "2023-09-15 03:55:00\n",
      "2023-09-15 04:00:00\n",
      "2023-09-15 04:05:00\n",
      "2023-09-15 04:10:00\n",
      "2023-09-15 04:15:00\n",
      "2023-09-15 04:20:00\n",
      "2023-09-15 04:25:00\n",
      "2023-09-15 04:30:00\n",
      "2023-09-15 04:35:00\n",
      "2023-09-15 04:40:00\n",
      "2023-09-15 04:45:00\n",
      "2023-09-15 04:50:00\n",
      "2023-09-15 04:55:00\n",
      "2023-09-15 05:00:00\n",
      "2023-09-15 05:05:00\n",
      "2023-09-15 05:10:00\n",
      "2023-09-15 05:15:00\n",
      "2023-09-15 05:20:00\n",
      "2023-09-15 05:25:00\n",
      "2023-09-15 05:30:00\n",
      "2023-09-15 05:35:00\n",
      "2023-09-15 05:40:00\n",
      "2023-09-15 05:45:00\n",
      "2023-09-15 05:50:00\n",
      "2023-09-15 05:55:00\n",
      "2023-09-15 06:00:00\n",
      "2023-09-15 06:05:00\n",
      "2023-09-15 06:10:00\n",
      "2023-09-15 06:15:00\n",
      "2023-09-15 06:20:00\n",
      "2023-09-15 06:25:00\n",
      "2023-09-15 06:30:00\n",
      "2023-09-15 06:35:00\n",
      "2023-09-15 06:40:00\n",
      "2023-09-15 06:45:00\n",
      "2023-09-15 06:50:00\n",
      "2023-09-15 06:55:00\n",
      "2023-09-15 07:00:00\n",
      "2023-09-15 07:05:00\n",
      "2023-09-15 07:10:00\n",
      "2023-09-15 07:15:00\n",
      "2023-09-15 07:20:00\n",
      "2023-09-15 07:25:00\n",
      "2023-09-15 07:30:00\n",
      "2023-09-15 07:35:00\n",
      "2023-09-15 07:40:00\n",
      "2023-09-15 07:45:00\n",
      "2023-09-15 07:50:00\n",
      "2023-09-15 07:55:00\n",
      "2023-09-15 08:00:00\n",
      "2023-09-15 08:05:00\n",
      "2023-09-15 08:10:00\n",
      "2023-09-15 08:15:00\n",
      "2023-09-15 08:20:00\n",
      "2023-09-15 08:25:00\n",
      "2023-09-15 08:30:00\n",
      "2023-09-15 08:35:00\n",
      "2023-09-15 08:40:00\n",
      "2023-09-15 08:45:00\n",
      "2023-09-15 08:50:00\n",
      "2023-09-15 08:55:00\n",
      "2023-09-15 09:00:00\n",
      "2023-09-15 09:05:00\n",
      "2023-09-15 09:10:00\n",
      "2023-09-15 09:15:00\n",
      "2023-09-15 09:20:00\n",
      "2023-09-15 09:25:00\n",
      "2023-09-15 09:30:00\n",
      "2023-09-15 09:35:00\n",
      "2023-09-15 09:40:00\n",
      "2023-09-15 09:45:00\n",
      "2023-09-15 09:50:00\n",
      "2023-09-15 09:55:00\n",
      "2023-09-15 10:00:00\n",
      "2023-09-15 10:05:00\n",
      "2023-09-15 10:10:00\n",
      "2023-09-15 10:15:00\n",
      "2023-09-15 10:20:00\n",
      "2023-09-15 10:25:00\n",
      "2023-09-15 10:30:00\n",
      "2023-09-15 10:35:00\n",
      "2023-09-15 10:40:00\n",
      "2023-09-15 10:45:00\n",
      "2023-09-15 10:50:00\n",
      "2023-09-15 10:55:00\n",
      "2023-09-15 11:00:00\n",
      "2023-09-15 11:05:00\n",
      "2023-09-15 11:10:00\n",
      "2023-09-15 11:15:00\n",
      "2023-09-15 11:20:00\n",
      "2023-09-15 11:25:00\n",
      "2023-09-15 11:30:00\n",
      "2023-09-15 11:35:00\n",
      "2023-09-15 11:40:00\n",
      "2023-09-15 11:45:00\n",
      "2023-09-15 11:50:00\n",
      "2023-09-15 11:55:00\n",
      "2023-09-15 12:00:00\n",
      "2023-09-15 12:05:00\n",
      "2023-09-15 12:10:00\n",
      "2023-09-15 12:15:00\n",
      "2023-09-15 12:20:00\n",
      "2023-09-15 12:25:00\n",
      "2023-09-15 12:30:00\n",
      "2023-09-15 12:35:00\n",
      "2023-09-15 12:40:00\n",
      "2023-09-15 12:45:00\n",
      "2023-09-15 12:50:00\n",
      "2023-09-15 12:55:00\n",
      "2023-09-15 13:00:00\n",
      "2023-09-15 13:05:00\n",
      "2023-09-15 13:10:00\n",
      "2023-09-15 13:15:00\n",
      "2023-09-15 13:20:00\n",
      "2023-09-15 13:25:00\n",
      "2023-09-15 13:30:00\n",
      "2023-09-15 13:35:00\n",
      "2023-09-15 13:40:00\n",
      "2023-09-15 13:45:00\n",
      "2023-09-15 13:50:00\n",
      "2023-09-15 13:55:00\n",
      "2023-09-15 14:00:00\n",
      "2023-09-15 14:05:00\n",
      "2023-09-15 14:10:00\n",
      "2023-09-15 14:15:00\n",
      "2023-09-15 14:20:00\n",
      "2023-09-15 14:25:00\n",
      "2023-09-15 14:30:00\n",
      "2023-09-15 14:35:00\n",
      "2023-09-15 14:40:00\n",
      "2023-09-15 14:45:00\n",
      "2023-09-15 14:50:00\n",
      "2023-09-15 14:55:00\n",
      "2023-09-15 15:00:00\n",
      "2023-09-15 15:05:00\n",
      "2023-09-15 15:10:00\n",
      "2023-09-15 15:15:00\n",
      "2023-09-15 15:20:00\n",
      "2023-09-15 15:25:00\n",
      "2023-09-15 15:30:00\n",
      "2023-09-15 15:35:00\n",
      "2023-09-15 15:40:00\n",
      "2023-09-15 15:45:00\n",
      "2023-09-15 15:50:00\n",
      "2023-09-15 15:55:00\n",
      "2023-09-15 16:00:00\n",
      "2023-09-15 16:05:00\n",
      "2023-09-15 16:10:00\n",
      "2023-09-15 16:15:00\n",
      "2023-09-15 16:20:00\n",
      "2023-09-15 16:25:00\n",
      "2023-09-15 16:30:00\n",
      "2023-09-15 16:35:00\n",
      "2023-09-15 16:40:00\n",
      "2023-09-15 16:45:00\n",
      "2023-09-15 16:50:00\n",
      "2023-09-15 16:55:00\n",
      "2023-09-15 17:00:00\n",
      "2023-09-15 17:05:00\n",
      "2023-09-15 17:10:00\n",
      "2023-09-15 17:15:00\n",
      "2023-09-15 17:20:00\n",
      "2023-09-15 17:25:00\n",
      "2023-09-15 17:30:00\n",
      "2023-09-15 17:35:00\n",
      "2023-09-15 17:40:00\n",
      "2023-09-15 17:45:00\n",
      "2023-09-15 17:50:00\n",
      "2023-09-15 17:55:00\n",
      "2023-09-15 18:00:00\n",
      "2023-09-15 18:05:00\n",
      "2023-09-15 18:10:00\n",
      "2023-09-15 18:15:00\n",
      "2023-09-15 18:20:00\n",
      "2023-09-15 18:25:00\n",
      "2023-09-15 18:30:00\n",
      "2023-09-15 18:35:00\n",
      "2023-09-15 18:40:00\n",
      "2023-09-15 18:45:00\n",
      "2023-09-15 18:50:00\n",
      "2023-09-15 18:55:00\n",
      "2023-09-15 19:00:00\n",
      "2023-09-15 19:05:00\n",
      "2023-09-15 19:10:00\n",
      "2023-09-15 19:15:00\n",
      "2023-09-15 19:20:00\n",
      "2023-09-15 19:25:00\n",
      "2023-09-15 19:30:00\n",
      "2023-09-15 19:35:00\n",
      "2023-09-15 19:40:00\n",
      "2023-09-15 19:45:00\n",
      "2023-09-15 19:50:00\n",
      "2023-09-15 19:55:00\n",
      "2023-09-15 20:00:00\n",
      "2023-09-15 20:05:00\n",
      "2023-09-15 20:10:00\n",
      "2023-09-15 20:15:00\n",
      "2023-09-15 20:20:00\n",
      "2023-09-15 20:25:00\n",
      "2023-09-15 20:30:00\n",
      "2023-09-15 20:35:00\n",
      "2023-09-15 20:40:00\n",
      "2023-09-15 20:45:00\n",
      "2023-09-15 20:50:00\n",
      "2023-09-15 20:55:00\n",
      "2023-09-15 21:00:00\n",
      "2023-09-15 21:05:00\n",
      "2023-09-15 21:10:00\n",
      "2023-09-15 21:15:00\n",
      "2023-09-15 21:20:00\n",
      "2023-09-15 21:25:00\n",
      "2023-09-15 21:30:00\n",
      "2023-09-15 21:35:00\n",
      "2023-09-15 21:40:00\n",
      "2023-09-15 21:45:00\n",
      "2023-09-15 21:50:00\n",
      "2023-09-15 21:55:00\n",
      "2023-09-15 22:00:00\n",
      "2023-09-15 22:05:00\n",
      "2023-09-15 22:10:00\n",
      "2023-09-15 22:15:00\n",
      "2023-09-15 22:20:00\n",
      "2023-09-15 22:25:00\n",
      "2023-09-15 22:30:00\n",
      "2023-09-15 22:35:00\n",
      "2023-09-15 22:40:00\n",
      "2023-09-15 22:45:00\n",
      "2023-09-15 22:50:00\n",
      "2023-09-15 22:55:00\n",
      "2023-09-15 23:00:00\n",
      "2023-09-15 23:05:00\n",
      "2023-09-15 23:10:00\n",
      "2023-09-15 23:15:00\n",
      "2023-09-15 23:20:00\n",
      "2023-09-15 23:25:00\n",
      "2023-09-15 23:30:00\n",
      "2023-09-15 23:35:00\n",
      "2023-09-15 23:40:00\n",
      "2023-09-15 23:45:00\n",
      "2023-09-15 23:50:00\n",
      "2023-09-15 23:55:00\n",
      "2023-09-16 00:00:00\n",
      "2023-09-16 00:05:00\n",
      "2023-09-16 00:10:00\n",
      "2023-09-16 00:15:00\n",
      "2023-09-16 00:20:00\n",
      "2023-09-16 00:25:00\n",
      "2023-09-16 00:30:00\n",
      "2023-09-16 00:35:00\n",
      "2023-09-16 00:40:00\n",
      "2023-09-16 00:45:00\n",
      "2023-09-16 00:50:00\n",
      "2023-09-16 00:55:00\n",
      "2023-09-16 01:00:00\n",
      "2023-09-16 01:05:00\n",
      "2023-09-16 01:10:00\n",
      "2023-09-16 01:15:00\n",
      "2023-09-16 01:20:00\n",
      "2023-09-16 01:25:00\n",
      "2023-09-16 01:30:00\n",
      "2023-09-16 01:35:00\n",
      "2023-09-16 01:40:00\n",
      "2023-09-16 01:45:00\n",
      "2023-09-16 01:50:00\n",
      "2023-09-16 01:55:00\n",
      "2023-09-16 02:00:00\n",
      "2023-09-16 02:05:00\n",
      "2023-09-16 02:10:00\n",
      "2023-09-16 02:15:00\n",
      "2023-09-16 02:20:00\n",
      "2023-09-16 02:25:00\n",
      "2023-09-16 02:30:00\n",
      "2023-09-16 02:35:00\n",
      "2023-09-16 02:40:00\n",
      "2023-09-16 02:45:00\n",
      "2023-09-16 02:50:00\n",
      "2023-09-16 02:55:00\n",
      "2023-09-16 03:00:00\n",
      "2023-09-16 03:05:00\n",
      "2023-09-16 03:10:00\n",
      "2023-09-16 03:15:00\n",
      "2023-09-16 03:20:00\n",
      "2023-09-16 03:25:00\n",
      "2023-09-16 03:30:00\n",
      "2023-09-16 03:35:00\n",
      "2023-09-16 03:40:00\n",
      "2023-09-16 03:45:00\n",
      "2023-09-16 03:50:00\n",
      "2023-09-16 03:55:00\n",
      "2023-09-16 04:00:00\n",
      "2023-09-16 04:05:00\n",
      "2023-09-16 04:10:00\n",
      "2023-09-16 04:15:00\n",
      "2023-09-16 04:20:00\n",
      "2023-09-16 04:25:00\n",
      "2023-09-16 04:30:00\n",
      "2023-09-16 04:35:00\n",
      "2023-09-16 04:40:00\n",
      "2023-09-16 04:45:00\n",
      "2023-09-16 04:50:00\n",
      "2023-09-16 04:55:00\n",
      "2023-09-16 05:00:00\n",
      "2023-09-16 05:05:00\n",
      "2023-09-16 05:10:00\n",
      "2023-09-16 05:15:00\n",
      "2023-09-16 05:20:00\n",
      "2023-09-16 05:25:00\n",
      "2023-09-16 05:30:00\n",
      "2023-09-16 05:35:00\n",
      "2023-09-16 05:40:00\n",
      "2023-09-16 05:45:00\n",
      "2023-09-16 05:50:00\n",
      "2023-09-16 05:55:00\n",
      "2023-09-16 06:00:00\n",
      "2023-09-16 06:05:00\n",
      "2023-09-16 06:10:00\n",
      "2023-09-16 06:15:00\n",
      "2023-09-16 06:20:00\n",
      "2023-09-16 06:25:00\n",
      "2023-09-16 06:30:00\n",
      "2023-09-16 06:35:00\n",
      "2023-09-16 06:40:00\n",
      "2023-09-16 06:45:00\n",
      "2023-09-16 06:50:00\n",
      "2023-09-16 06:55:00\n",
      "2023-09-16 07:00:00\n",
      "2023-09-16 07:05:00\n",
      "2023-09-16 07:10:00\n",
      "2023-09-16 07:15:00\n",
      "2023-09-16 07:20:00\n",
      "2023-09-16 07:25:00\n",
      "2023-09-16 07:30:00\n",
      "2023-09-16 07:35:00\n",
      "2023-09-16 07:40:00\n",
      "2023-09-16 07:45:00\n",
      "2023-09-16 07:50:00\n",
      "2023-09-16 07:55:00\n",
      "2023-09-16 08:00:00\n",
      "2023-09-16 08:05:00\n",
      "2023-09-16 08:10:00\n",
      "2023-09-16 08:15:00\n",
      "2023-09-16 08:20:00\n",
      "2023-09-16 08:25:00\n",
      "2023-09-16 08:30:00\n",
      "2023-09-16 08:35:00\n",
      "2023-09-16 08:40:00\n",
      "2023-09-16 08:45:00\n",
      "2023-09-16 08:50:00\n",
      "2023-09-16 08:55:00\n",
      "2023-09-16 09:00:00\n",
      "2023-09-16 09:05:00\n",
      "2023-09-16 09:10:00\n",
      "2023-09-16 09:15:00\n",
      "2023-09-16 09:20:00\n",
      "2023-09-16 09:25:00\n",
      "2023-09-16 09:30:00\n",
      "2023-09-16 09:35:00\n",
      "2023-09-16 09:40:00\n",
      "2023-09-16 09:45:00\n",
      "2023-09-16 09:50:00\n",
      "2023-09-16 09:55:00\n",
      "2023-09-16 10:00:00\n",
      "2023-09-16 10:05:00\n",
      "2023-09-16 10:10:00\n",
      "2023-09-16 10:15:00\n",
      "2023-09-16 10:20:00\n",
      "2023-09-16 10:25:00\n",
      "2023-09-16 10:30:00\n",
      "2023-09-16 10:35:00\n",
      "2023-09-16 10:40:00\n",
      "2023-09-16 10:45:00\n",
      "2023-09-16 10:50:00\n",
      "2023-09-16 10:55:00\n",
      "2023-09-16 11:00:00\n",
      "2023-09-16 11:05:00\n",
      "2023-09-16 11:10:00\n",
      "2023-09-16 11:15:00\n",
      "2023-09-16 11:20:00\n",
      "2023-09-16 11:25:00\n",
      "2023-09-16 11:30:00\n",
      "2023-09-16 11:35:00\n",
      "2023-09-16 11:40:00\n",
      "2023-09-16 11:45:00\n",
      "2023-09-16 11:50:00\n",
      "2023-09-16 11:55:00\n",
      "2023-09-16 12:00:00\n",
      "2023-09-16 12:05:00\n",
      "2023-09-16 12:10:00\n",
      "2023-09-16 12:15:00\n",
      "2023-09-16 12:20:00\n",
      "2023-09-16 12:25:00\n",
      "2023-09-16 12:30:00\n",
      "2023-09-16 12:35:00\n",
      "2023-09-16 12:40:00\n",
      "2023-09-16 12:45:00\n",
      "2023-09-16 12:50:00\n",
      "2023-09-16 12:55:00\n",
      "2023-09-16 13:00:00\n",
      "2023-09-16 13:05:00\n",
      "2023-09-16 13:10:00\n",
      "2023-09-16 13:15:00\n",
      "2023-09-16 13:20:00\n",
      "2023-09-16 13:25:00\n",
      "2023-09-16 13:30:00\n",
      "2023-09-16 13:35:00\n",
      "2023-09-16 13:40:00\n",
      "2023-09-16 13:45:00\n",
      "2023-09-16 13:50:00\n",
      "2023-09-16 13:55:00\n",
      "2023-09-16 14:00:00\n",
      "2023-09-16 14:05:00\n",
      "2023-09-16 14:10:00\n",
      "2023-09-16 14:15:00\n",
      "2023-09-16 14:20:00\n",
      "2023-09-16 14:25:00\n",
      "2023-09-16 14:30:00\n",
      "2023-09-16 14:35:00\n",
      "2023-09-16 14:40:00\n",
      "2023-09-16 14:45:00\n",
      "2023-09-16 14:50:00\n",
      "2023-09-16 14:55:00\n",
      "2023-09-16 15:00:00\n",
      "2023-09-16 15:05:00\n",
      "2023-09-16 15:10:00\n",
      "2023-09-16 15:15:00\n",
      "2023-09-16 15:20:00\n",
      "2023-09-16 15:25:00\n",
      "2023-09-16 15:30:00\n",
      "2023-09-16 15:35:00\n",
      "2023-09-16 15:40:00\n",
      "2023-09-16 15:45:00\n",
      "2023-09-16 15:50:00\n",
      "2023-09-16 15:55:00\n",
      "2023-09-16 16:00:00\n",
      "2023-09-16 16:05:00\n",
      "2023-09-16 16:10:00\n",
      "2023-09-16 16:15:00\n",
      "2023-09-16 16:20:00\n",
      "2023-09-16 16:25:00\n",
      "2023-09-16 16:30:00\n",
      "2023-09-16 16:35:00\n",
      "2023-09-16 16:40:00\n",
      "2023-09-16 16:45:00\n",
      "2023-09-16 16:50:00\n",
      "2023-09-16 16:55:00\n",
      "2023-09-16 17:00:00\n",
      "2023-09-16 17:05:00\n",
      "2023-09-16 17:10:00\n",
      "2023-09-16 17:15:00\n",
      "2023-09-16 17:20:00\n",
      "2023-09-16 17:25:00\n",
      "2023-09-16 17:30:00\n",
      "2023-09-16 17:35:00\n",
      "2023-09-16 17:40:00\n",
      "2023-09-16 17:45:00\n",
      "2023-09-16 17:50:00\n",
      "2023-09-16 17:55:00\n",
      "2023-09-16 18:00:00\n",
      "2023-09-16 18:05:00\n",
      "2023-09-16 18:10:00\n",
      "2023-09-16 18:15:00\n",
      "2023-09-16 18:20:00\n",
      "2023-09-16 18:25:00\n",
      "2023-09-16 18:30:00\n",
      "2023-09-16 18:35:00\n",
      "2023-09-16 18:40:00\n",
      "2023-09-16 18:45:00\n",
      "2023-09-16 18:50:00\n",
      "2023-09-16 18:55:00\n",
      "2023-09-16 19:00:00\n",
      "2023-09-16 19:05:00\n",
      "2023-09-16 19:10:00\n",
      "2023-09-16 19:15:00\n",
      "2023-09-16 19:20:00\n",
      "2023-09-16 19:25:00\n",
      "2023-09-16 19:30:00\n",
      "2023-09-16 19:35:00\n",
      "2023-09-16 19:40:00\n",
      "2023-09-16 19:45:00\n",
      "2023-09-16 19:50:00\n",
      "2023-09-16 19:55:00\n",
      "2023-09-16 20:00:00\n",
      "2023-09-16 20:05:00\n",
      "2023-09-16 20:10:00\n",
      "2023-09-16 20:15:00\n",
      "2023-09-16 20:20:00\n",
      "2023-09-16 20:25:00\n",
      "2023-09-16 20:30:00\n",
      "2023-09-16 20:35:00\n",
      "2023-09-16 20:40:00\n",
      "2023-09-16 20:45:00\n",
      "2023-09-16 20:50:00\n",
      "2023-09-16 20:55:00\n",
      "2023-09-16 21:00:00\n",
      "2023-09-16 21:05:00\n",
      "2023-09-16 21:10:00\n",
      "2023-09-16 21:15:00\n",
      "2023-09-16 21:20:00\n",
      "2023-09-16 21:25:00\n",
      "2023-09-16 21:30:00\n",
      "2023-09-16 21:35:00\n",
      "2023-09-16 21:40:00\n",
      "2023-09-16 21:45:00\n",
      "2023-09-16 21:50:00\n",
      "2023-09-16 21:55:00\n",
      "2023-09-16 22:00:00\n",
      "2023-09-16 22:05:00\n",
      "2023-09-16 22:10:00\n",
      "2023-09-16 22:15:00\n",
      "2023-09-16 22:20:00\n",
      "2023-09-16 22:25:00\n",
      "2023-09-16 22:30:00\n",
      "2023-09-16 22:35:00\n",
      "2023-09-16 22:40:00\n",
      "2023-09-16 22:45:00\n",
      "2023-09-16 22:50:00\n",
      "2023-09-16 22:55:00\n",
      "2023-09-16 23:00:00\n",
      "2023-09-16 23:05:00\n",
      "2023-09-16 23:10:00\n",
      "2023-09-16 23:15:00\n",
      "2023-09-16 23:20:00\n",
      "2023-09-16 23:25:00\n",
      "2023-09-16 23:30:00\n",
      "2023-09-16 23:35:00\n",
      "2023-09-16 23:40:00\n",
      "2023-09-16 23:45:00\n",
      "2023-09-16 23:50:00\n",
      "2023-09-16 23:55:00\n",
      "2023-09-17 00:00:00\n",
      "2023-09-17 00:05:00\n",
      "2023-09-17 00:10:00\n",
      "2023-09-17 00:15:00\n",
      "2023-09-17 00:20:00\n",
      "2023-09-17 00:25:00\n",
      "2023-09-17 00:30:00\n",
      "2023-09-17 00:35:00\n",
      "2023-09-17 00:40:00\n",
      "2023-09-17 00:45:00\n",
      "2023-09-17 00:50:00\n",
      "2023-09-17 00:55:00\n",
      "2023-09-17 01:00:00\n",
      "2023-09-17 01:05:00\n",
      "2023-09-17 01:10:00\n",
      "2023-09-17 01:15:00\n",
      "2023-09-17 01:20:00\n",
      "2023-09-17 01:25:00\n",
      "2023-09-17 01:30:00\n",
      "2023-09-17 01:35:00\n",
      "2023-09-17 01:40:00\n",
      "2023-09-17 01:45:00\n",
      "2023-09-17 01:50:00\n",
      "2023-09-17 01:55:00\n",
      "2023-09-17 02:00:00\n",
      "2023-09-17 02:05:00\n",
      "2023-09-17 02:10:00\n",
      "2023-09-17 02:15:00\n",
      "2023-09-17 02:20:00\n",
      "2023-09-17 02:25:00\n",
      "2023-09-17 02:30:00\n",
      "2023-09-17 02:35:00\n",
      "2023-09-17 02:40:00\n",
      "2023-09-17 02:45:00\n",
      "2023-09-17 02:50:00\n",
      "2023-09-17 02:55:00\n",
      "2023-09-17 03:00:00\n",
      "2023-09-17 03:05:00\n",
      "2023-09-17 03:10:00\n",
      "2023-09-17 03:15:00\n",
      "2023-09-17 03:20:00\n",
      "2023-09-17 03:25:00\n",
      "2023-09-17 03:30:00\n",
      "2023-09-17 03:35:00\n",
      "2023-09-17 03:40:00\n",
      "2023-09-17 03:45:00\n",
      "2023-09-17 03:50:00\n",
      "2023-09-17 03:55:00\n",
      "2023-09-17 04:00:00\n",
      "2023-09-17 04:05:00\n",
      "2023-09-17 04:10:00\n",
      "2023-09-17 04:15:00\n",
      "2023-09-17 04:20:00\n",
      "2023-09-17 04:25:00\n",
      "2023-09-17 04:30:00\n",
      "2023-09-17 04:35:00\n",
      "2023-09-17 04:40:00\n",
      "2023-09-17 04:45:00\n",
      "2023-09-17 04:50:00\n",
      "2023-09-17 04:55:00\n",
      "2023-09-17 05:00:00\n",
      "2023-09-17 05:05:00\n",
      "2023-09-17 05:10:00\n",
      "2023-09-17 05:15:00\n",
      "2023-09-17 05:20:00\n",
      "2023-09-17 05:25:00\n",
      "2023-09-17 05:30:00\n",
      "2023-09-17 05:35:00\n",
      "2023-09-17 05:40:00\n",
      "2023-09-17 05:45:00\n",
      "2023-09-17 05:50:00\n",
      "2023-09-17 05:55:00\n",
      "2023-09-17 06:00:00\n",
      "2023-09-17 06:05:00\n",
      "2023-09-17 06:10:00\n",
      "2023-09-17 06:15:00\n",
      "2023-09-17 06:20:00\n",
      "2023-09-17 06:25:00\n",
      "2023-09-17 06:30:00\n",
      "2023-09-17 06:35:00\n",
      "2023-09-17 06:40:00\n",
      "2023-09-17 06:45:00\n",
      "2023-09-17 06:50:00\n",
      "2023-09-17 06:55:00\n",
      "2023-09-17 07:00:00\n",
      "2023-09-17 07:05:00\n",
      "2023-09-17 07:10:00\n",
      "2023-09-17 07:15:00\n",
      "2023-09-17 07:20:00\n",
      "2023-09-17 07:25:00\n",
      "2023-09-17 07:30:00\n",
      "2023-09-17 07:35:00\n",
      "2023-09-17 07:40:00\n",
      "2023-09-17 07:45:00\n",
      "2023-09-17 07:50:00\n",
      "2023-09-17 07:55:00\n",
      "2023-09-17 08:00:00\n",
      "2023-09-17 08:05:00\n",
      "2023-09-17 08:10:00\n",
      "2023-09-17 08:15:00\n",
      "2023-09-17 08:20:00\n",
      "2023-09-17 08:25:00\n",
      "2023-09-17 08:30:00\n",
      "2023-09-17 08:35:00\n",
      "2023-09-17 08:40:00\n",
      "2023-09-17 08:45:00\n",
      "2023-09-17 08:50:00\n",
      "2023-09-17 08:55:00\n",
      "2023-09-17 09:00:00\n",
      "2023-09-17 09:05:00\n",
      "2023-09-17 09:10:00\n",
      "2023-09-17 09:15:00\n",
      "2023-09-17 09:20:00\n",
      "2023-09-17 09:25:00\n",
      "2023-09-17 09:30:00\n",
      "2023-09-17 09:35:00\n",
      "2023-09-17 09:40:00\n",
      "2023-09-17 09:45:00\n",
      "2023-09-17 09:50:00\n",
      "2023-09-17 09:55:00\n",
      "2023-09-17 10:00:00\n",
      "2023-09-17 10:05:00\n",
      "2023-09-17 10:10:00\n",
      "2023-09-17 10:15:00\n",
      "2023-09-17 10:20:00\n",
      "2023-09-17 10:25:00\n",
      "2023-09-17 10:30:00\n",
      "2023-09-17 10:35:00\n",
      "2023-09-17 10:40:00\n",
      "2023-09-17 10:45:00\n",
      "2023-09-17 10:50:00\n",
      "2023-09-17 10:55:00\n",
      "2023-09-17 11:00:00\n",
      "2023-09-17 11:05:00\n",
      "2023-09-17 11:10:00\n",
      "2023-09-17 11:15:00\n",
      "2023-09-17 11:20:00\n",
      "2023-09-17 11:25:00\n",
      "2023-09-17 11:30:00\n",
      "2023-09-17 11:35:00\n",
      "2023-09-17 11:40:00\n",
      "2023-09-17 11:45:00\n",
      "2023-09-17 11:50:00\n",
      "2023-09-17 11:55:00\n",
      "2023-09-17 12:00:00\n",
      "2023-09-17 12:05:00\n",
      "2023-09-17 12:10:00\n",
      "2023-09-17 12:15:00\n",
      "2023-09-17 12:20:00\n",
      "2023-09-17 12:25:00\n",
      "2023-09-17 12:30:00\n",
      "2023-09-17 12:35:00\n",
      "2023-09-17 12:40:00\n",
      "2023-09-17 12:45:00\n",
      "2023-09-17 12:50:00\n",
      "2023-09-17 12:55:00\n",
      "2023-09-17 13:00:00\n",
      "2023-09-17 13:05:00\n",
      "2023-09-17 13:10:00\n",
      "2023-09-17 13:15:00\n",
      "2023-09-17 13:20:00\n",
      "2023-09-17 13:25:00\n",
      "2023-09-17 13:30:00\n",
      "2023-09-17 13:35:00\n",
      "2023-09-17 13:40:00\n",
      "2023-09-17 13:45:00\n",
      "2023-09-17 13:50:00\n",
      "2023-09-17 13:55:00\n",
      "2023-09-17 14:00:00\n",
      "2023-09-17 14:05:00\n",
      "2023-09-17 14:10:00\n",
      "2023-09-17 14:15:00\n",
      "2023-09-17 14:20:00\n",
      "2023-09-17 14:25:00\n",
      "2023-09-17 14:30:00\n",
      "2023-09-17 14:35:00\n",
      "2023-09-17 14:40:00\n",
      "2023-09-17 14:45:00\n",
      "2023-09-17 14:50:00\n",
      "2023-09-17 14:55:00\n",
      "2023-09-17 15:00:00\n",
      "2023-09-17 15:05:00\n",
      "2023-09-17 15:10:00\n",
      "2023-09-17 15:15:00\n",
      "2023-09-17 15:20:00\n",
      "2023-09-17 15:25:00\n",
      "2023-09-17 15:30:00\n",
      "2023-09-17 15:35:00\n",
      "2023-09-17 15:40:00\n",
      "2023-09-17 15:45:00\n",
      "2023-09-17 15:50:00\n",
      "2023-09-17 15:55:00\n",
      "2023-09-17 16:00:00\n",
      "2023-09-17 16:05:00\n",
      "2023-09-17 16:10:00\n",
      "2023-09-17 16:15:00\n",
      "2023-09-17 16:20:00\n",
      "2023-09-17 16:25:00\n",
      "2023-09-17 16:30:00\n",
      "2023-09-17 16:35:00\n",
      "2023-09-17 16:40:00\n",
      "2023-09-17 16:45:00\n",
      "2023-09-17 16:50:00\n",
      "2023-09-17 16:55:00\n",
      "2023-09-17 17:00:00\n",
      "2023-09-17 17:05:00\n",
      "2023-09-17 17:10:00\n",
      "2023-09-17 17:15:00\n",
      "2023-09-17 17:20:00\n",
      "2023-09-17 17:25:00\n",
      "2023-09-17 17:30:00\n",
      "2023-09-17 17:35:00\n",
      "2023-09-17 17:40:00\n",
      "2023-09-17 17:45:00\n",
      "2023-09-17 17:50:00\n",
      "2023-09-17 17:55:00\n",
      "2023-09-17 18:00:00\n",
      "2023-09-17 18:05:00\n",
      "2023-09-17 18:10:00\n",
      "2023-09-17 18:15:00\n",
      "2023-09-17 18:20:00\n",
      "2023-09-17 18:25:00\n",
      "2023-09-17 18:30:00\n",
      "2023-09-17 18:35:00\n",
      "2023-09-17 18:40:00\n",
      "2023-09-17 18:45:00\n",
      "2023-09-17 18:50:00\n",
      "2023-09-17 18:55:00\n",
      "2023-09-17 19:00:00\n",
      "2023-09-17 19:05:00\n",
      "2023-09-17 19:10:00\n",
      "2023-09-17 19:15:00\n",
      "2023-09-17 19:20:00\n",
      "2023-09-17 19:25:00\n",
      "2023-09-17 19:30:00\n",
      "2023-09-17 19:35:00\n",
      "2023-09-17 19:40:00\n",
      "2023-09-17 19:45:00\n",
      "2023-09-17 19:50:00\n",
      "2023-09-17 19:55:00\n",
      "2023-09-17 20:00:00\n",
      "2023-09-17 20:05:00\n",
      "2023-09-17 20:10:00\n",
      "2023-09-17 20:15:00\n",
      "2023-09-17 20:20:00\n",
      "2023-09-17 20:25:00\n",
      "2023-09-17 20:30:00\n",
      "2023-09-17 20:35:00\n",
      "2023-09-17 20:40:00\n",
      "2023-09-17 20:45:00\n",
      "2023-09-17 20:50:00\n",
      "2023-09-17 20:55:00\n",
      "2023-09-17 21:00:00\n",
      "2023-09-17 21:05:00\n",
      "2023-09-17 21:10:00\n",
      "2023-09-17 21:15:00\n",
      "2023-09-17 21:20:00\n",
      "2023-09-17 21:25:00\n",
      "2023-09-17 21:30:00\n",
      "2023-09-17 21:35:00\n",
      "2023-09-17 21:40:00\n",
      "2023-09-17 21:45:00\n",
      "2023-09-17 21:50:00\n",
      "2023-09-17 21:55:00\n",
      "2023-09-17 22:00:00\n",
      "2023-09-17 22:05:00\n",
      "2023-09-17 22:10:00\n",
      "2023-09-17 22:15:00\n",
      "2023-09-17 22:20:00\n",
      "2023-09-17 22:25:00\n",
      "2023-09-17 22:30:00\n",
      "2023-09-17 22:35:00\n",
      "2023-09-17 22:40:00\n",
      "2023-09-17 22:45:00\n",
      "2023-09-17 22:50:00\n",
      "2023-09-17 22:55:00\n",
      "2023-09-17 23:00:00\n",
      "2023-09-17 23:05:00\n",
      "2023-09-17 23:10:00\n",
      "2023-09-17 23:15:00\n",
      "2023-09-17 23:20:00\n",
      "2023-09-17 23:25:00\n",
      "2023-09-17 23:30:00\n",
      "2023-09-17 23:35:00\n",
      "2023-09-17 23:40:00\n",
      "2023-09-17 23:45:00\n",
      "2023-09-17 23:50:00\n",
      "2023-09-17 23:55:00\n",
      "2023-09-18 00:00:00\n",
      "2023-09-18 00:05:00\n",
      "2023-09-18 00:10:00\n",
      "2023-09-18 00:15:00\n",
      "2023-09-18 00:20:00\n",
      "2023-09-18 00:25:00\n",
      "2023-09-18 00:30:00\n",
      "2023-09-18 00:35:00\n",
      "2023-09-18 00:40:00\n",
      "2023-09-18 00:45:00\n",
      "2023-09-18 00:50:00\n",
      "2023-09-18 00:55:00\n",
      "2023-09-18 01:00:00\n",
      "2023-09-18 01:05:00\n",
      "2023-09-18 01:10:00\n",
      "2023-09-18 01:15:00\n",
      "2023-09-18 01:20:00\n",
      "2023-09-18 01:25:00\n",
      "2023-09-18 01:30:00\n",
      "2023-09-18 01:35:00\n",
      "2023-09-18 01:40:00\n",
      "2023-09-18 01:45:00\n",
      "2023-09-18 01:50:00\n",
      "2023-09-18 01:55:00\n",
      "2023-09-18 02:00:00\n",
      "2023-09-18 02:05:00\n",
      "2023-09-18 02:10:00\n",
      "2023-09-18 02:15:00\n",
      "2023-09-18 02:20:00\n",
      "2023-09-18 02:25:00\n",
      "2023-09-18 02:30:00\n",
      "2023-09-18 02:35:00\n",
      "2023-09-18 02:40:00\n",
      "2023-09-18 02:45:00\n",
      "2023-09-18 02:50:00\n",
      "2023-09-18 02:55:00\n",
      "2023-09-18 03:00:00\n",
      "2023-09-18 03:05:00\n",
      "2023-09-18 03:10:00\n",
      "2023-09-18 03:15:00\n",
      "2023-09-18 03:20:00\n",
      "2023-09-18 03:25:00\n",
      "2023-09-18 03:30:00\n",
      "2023-09-18 03:35:00\n",
      "2023-09-18 03:40:00\n",
      "2023-09-18 03:45:00\n",
      "2023-09-18 03:50:00\n",
      "2023-09-18 03:55:00\n",
      "2023-09-18 04:00:00\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    }
   ],
   "source": [
    "df = pd.concat(agg)\n",
    "df.head(10)\n",
    "dfs = [x for _, x in df.groupby('DATETIME')]\n",
    "for df in tqdm(dfs):\n",
    "    dt = str(df.iloc[0]['DATETIME'].split[' '])\n",
    "    # print(dt)\n",
    "    df.to_csv('CRN/'+dt+'.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7655b5fe-2623-4d8b-b77e-72cb68f63b29",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}