DownloadThePosts.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-06-26T22:03:08.407465800Z",
     "start_time": "2023-06-26T22:03:07.702881700Z"
    },
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import PyCrowdTangle as pct\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-06-26T22:03:09.385940300Z",
     "start_time": "2023-06-26T22:03:09.375926900Z"
    }
   },
   "outputs": [],
   "source": [
    "api_token = open(\"api.txt\",\"r\").readline().strip(\"\\n\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-06-26T22:13:11.037899500Z",
     "start_time": "2023-06-26T22:13:10.533474700Z"
    }
   },
   "outputs": [],
   "source": [
    "data = pct.ct_get_posts(api_token=api_token,count=100,start_date=\"2023-01-01\",end_date=\"2023-01-03\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-06-26T22:13:12.250905700Z",
     "start_time": "2023-06-26T22:13:12.231889200Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "30"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['result']['posts'].__len__()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-06-26T22:26:01.932131Z",
     "start_time": "2023-06-26T22:26:01.894099700Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'imageText', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'title', 'caption', 'description', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'postUrl', 'subscriberCount', 'score', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'videoLengthMS', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'imageText', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n",
      "dict_keys(['platformId', 'platform', 'date', 'updated', 'type', 'message', 'expandedLinks', 'link', 'postUrl', 'subscriberCount', 'score', 'media', 'statistics', 'account', 'languageCode', 'legacyId', 'id'])\n"
     ]
    }
   ],
   "source": [
    "for ele in data['result']['posts']:\n",
    "    print(ele.keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-06-27T01:22:43.766266Z",
     "start_time": "2023-06-26T23:01:16.734356Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2020-01-01 2020-01-03 200 28 28\n",
      "2020-01-03 2020-01-05 200 37 65\n",
      "2020-01-05 2020-01-07 200 46 111\n",
      "2020-01-07 2020-01-09 200 44 155\n",
      "2020-01-09 2020-01-11 200 29 184\n",
      "2020-01-11 2020-01-13 200 25 209\n",
      "2020-01-13 2020-01-15 200 28 237\n",
      "2020-01-15 2020-01-17 200 36 273\n",
      "2020-01-17 2020-01-19 200 32 305\n",
      "2020-01-19 2020-01-21 200 28 333\n",
      "2020-01-21 2020-01-23 200 35 368\n",
      "2020-01-23 2020-01-25 200 27 395\n",
      "2020-01-25 2020-01-27 200 20 415\n",
      "2020-01-27 2020-01-29 200 33 448\n",
      "2020-01-29 2020-01-31 200 37 485\n",
      "2020-01-31 2020-02-02 200 36 521\n",
      "2020-02-02 2020-02-04 200 31 552\n",
      "2020-02-04 2020-02-06 200 42 594\n",
      "2020-02-06 2020-02-08 200 44 638\n",
      "2020-02-08 2020-02-10 200 35 673\n",
      "2020-02-10 2020-02-12 200 36 709\n",
      "2020-02-12 2020-02-14 200 48 757\n",
      "2020-02-14 2020-02-16 200 31 788\n",
      "2020-02-16 2020-02-18 200 36 824\n",
      "2020-02-18 2020-02-20 200 33 857\n",
      "2020-02-20 2020-02-22 200 42 899\n",
      "2020-02-22 2020-02-24 200 23 922\n",
      "2020-02-24 2020-02-26 200 40 962\n",
      "2020-02-26 2020-02-28 200 30 992\n",
      "2020-02-28 2020-03-01 200 25 1017\n",
      "2020-03-01 2020-03-03 200 24 1041\n",
      "2020-03-03 2020-03-05 200 24 1065\n",
      "2020-03-05 2020-03-07 200 26 1091\n",
      "2020-03-07 2020-03-09 200 18 1109\n",
      "2020-03-09 2020-03-11 200 34 1143\n",
      "2020-03-11 2020-03-13 200 27 1170\n",
      "2020-03-13 2020-03-15 200 33 1203\n",
      "2020-03-15 2020-03-17 200 30 1233\n",
      "2020-03-17 2020-03-19 200 33 1266\n",
      "2020-03-19 2020-03-21 200 32 1298\n",
      "2020-03-21 2020-03-23 200 40 1338\n",
      "2020-03-23 2020-03-25 200 52 1390\n",
      "2020-03-25 2020-03-27 200 43 1433\n",
      "2020-03-27 2020-03-29 200 42 1475\n",
      "2020-03-29 2020-03-31 200 40 1515\n",
      "2020-03-31 2020-04-02 200 48 1563\n",
      "2020-04-02 2020-04-04 200 50 1613\n",
      "2020-04-04 2020-04-06 200 43 1656\n",
      "2020-04-06 2020-04-08 200 44 1700\n",
      "2020-04-08 2020-04-10 200 38 1738\n",
      "2020-04-10 2020-04-12 200 32 1770\n",
      "2020-04-12 2020-04-14 200 29 1799\n",
      "2020-04-14 2020-04-16 200 47 1846\n",
      "2020-04-16 2020-04-18 200 47 1893\n",
      "2020-04-18 2020-04-20 200 47 1940\n",
      "2020-04-20 2020-04-22 200 54 1994\n",
      "2020-04-22 2020-04-24 200 45 2039\n",
      "2020-04-24 2020-04-26 200 40 2079\n",
      "2020-04-26 2020-04-28 200 44 2123\n",
      "2020-04-28 2020-04-30 200 56 2179\n",
      "2020-04-30 2020-05-02 200 53 2232\n",
      "2020-05-02 2020-05-04 200 49 2281\n",
      "2020-05-04 2020-05-06 200 54 2335\n",
      "2020-05-06 2020-05-08 200 55 2390\n",
      "2020-05-08 2020-05-10 200 50 2440\n",
      "2020-05-10 2020-05-12 200 54 2494\n",
      "2020-05-12 2020-05-14 200 57 2551\n",
      "2020-05-14 2020-05-16 200 52 2603\n",
      "2020-05-16 2020-05-18 200 54 2657\n",
      "2020-05-18 2020-05-20 200 64 2721\n",
      "2020-05-20 2020-05-22 200 55 2776\n",
      "2020-05-22 2020-05-24 200 41 2817\n",
      "2020-05-24 2020-05-26 200 32 2849\n",
      "2020-05-26 2020-05-28 200 41 2890\n",
      "2020-05-28 2020-05-30 200 49 2939\n",
      "2020-05-30 2020-06-01 200 51 2990\n",
      "2020-06-01 2020-06-03 200 60 3050\n",
      "2020-06-03 2020-06-05 200 50 3100\n",
      "2020-06-05 2020-06-07 200 49 3149\n",
      "2020-06-07 2020-06-09 200 37 3186\n",
      "2020-06-09 2020-06-11 200 51 3237\n",
      "2020-06-11 2020-06-13 200 46 3283\n",
      "2020-06-13 2020-06-15 200 43 3326\n",
      "2020-06-15 2020-06-17 200 64 3390\n",
      "2020-06-17 2020-06-19 200 60 3450\n",
      "2020-06-19 2020-06-21 200 56 3506\n",
      "2020-06-21 2020-06-23 200 42 3548\n",
      "2020-06-23 2020-06-25 200 55 3603\n",
      "2020-06-25 2020-06-27 200 43 3646\n",
      "2020-06-27 2020-06-29 200 35 3681\n",
      "2020-06-29 2020-07-01 200 55 3736\n",
      "2020-07-01 2020-07-03 200 56 3792\n",
      "2020-07-03 2020-07-05 200 46 3838\n",
      "2020-07-05 2020-07-07 200 48 3886\n",
      "2020-07-07 2020-07-09 200 52 3938\n",
      "2020-07-09 2020-07-11 200 49 3987\n",
      "2020-07-11 2020-07-13 200 53 4040\n",
      "2020-07-13 2020-07-15 200 62 4102\n",
      "2020-07-15 2020-07-17 200 70 4172\n",
      "2020-07-17 2020-07-19 200 43 4215\n",
      "2020-07-19 2020-07-21 200 40 4255\n",
      "2020-07-21 2020-07-23 200 53 4308\n",
      "2020-07-23 2020-07-25 200 54 4362\n",
      "2020-07-25 2020-07-27 200 34 4396\n",
      "2020-07-27 2020-07-29 200 64 4460\n",
      "2020-07-29 2020-07-31 200 62 4522\n",
      "2020-07-31 2020-08-02 200 47 4569\n",
      "2020-08-02 2020-08-04 200 47 4616\n",
      "2020-08-04 2020-08-06 200 79 4695\n",
      "2020-08-06 2020-08-08 200 57 4752\n",
      "2020-08-08 2020-08-10 200 40 4792\n",
      "2020-08-10 2020-08-12 200 77 4869\n",
      "2020-08-12 2020-08-14 200 63 4932\n",
      "2020-08-14 2020-08-16 200 58 4990\n",
      "2020-08-16 2020-08-18 200 56 5046\n",
      "2020-08-18 2020-08-20 200 81 5127\n",
      "2020-08-20 2020-08-22 200 83 5210\n",
      "2020-08-22 2020-08-24 200 59 5269\n",
      "2020-08-24 2020-08-26 200 69 5338\n",
      "2020-08-26 2020-08-28 200 75 5413\n",
      "2020-08-28 2020-08-30 200 75 5488\n",
      "2020-08-30 2020-09-01 200 62 5550\n",
      "2020-09-01 2020-09-03 200 85 5635\n",
      "2020-09-03 2020-09-05 200 87 5722\n",
      "2020-09-05 2020-09-07 200 75 5797\n",
      "2020-09-07 2020-09-09 200 79 5876\n",
      "2020-09-09 2020-09-11 200 90 5966\n",
      "2020-09-11 2020-09-13 200 70 6036\n",
      "2020-09-13 2020-09-15 200 80 6116\n",
      "2020-09-15 2020-09-17 200 79 6195\n",
      "2020-09-17 2020-09-19 200 77 6272\n",
      "2020-09-19 2020-09-21 200 100 6372\n",
      "2020-09-21 2020-09-23 200 62 6434\n",
      "2020-09-23 2020-09-25 200 72 6506\n",
      "2020-09-25 2020-09-27 200 51 6557\n",
      "2020-09-27 2020-09-29 200 52 6609\n",
      "2020-09-29 2020-10-01 200 51 6660\n",
      "2020-10-01 2020-10-03 200 72 6732\n",
      "2020-10-03 2020-10-05 200 45 6777\n",
      "2020-10-05 2020-10-07 200 64 6841\n",
      "2020-10-07 2020-10-09 200 73 6914\n",
      "2020-10-09 2020-10-11 200 100 7014\n",
      "2020-10-11 2020-10-13 200 71 7085\n",
      "2020-10-13 2020-10-15 200 88 7173\n",
      "2020-10-15 2020-10-17 200 100 7273\n",
      "2020-10-17 2020-10-19 200 68 7341\n",
      "2020-10-19 2020-10-21 200 100 7441\n",
      "2020-10-21 2020-10-23 200 100 7541\n",
      "2020-10-23 2020-10-25 200 81 7622\n",
      "2020-10-25 2020-10-27 200 83 7705\n",
      "2020-10-27 2020-10-29 200 75 7780\n",
      "2020-10-29 2020-10-31 200 85 7865\n",
      "2020-10-31 2020-11-02 200 52 7917\n",
      "2020-11-02 2020-11-04 200 82 7999\n",
      "2020-11-04 2020-11-06 200 100 8099\n",
      "2020-11-06 2020-11-08 200 92 8191\n",
      "2020-11-08 2020-11-10 200 60 8251\n",
      "2020-11-10 2020-11-12 200 73 8324\n",
      "2020-11-12 2020-11-14 200 79 8403\n",
      "2020-11-14 2020-11-16 200 47 8450\n",
      "2020-11-16 2020-11-18 200 76 8526\n",
      "2020-11-18 2020-11-20 200 63 8589\n",
      "2020-11-20 2020-11-22 200 52 8641\n",
      "2020-11-22 2020-11-24 200 38 8679\n",
      "2020-11-24 2020-11-26 200 48 8727\n",
      "2020-11-26 2020-11-28 200 44 8771\n",
      "2020-11-28 2020-11-30 200 39 8810\n",
      "2020-11-30 2020-12-02 200 42 8852\n",
      "2020-12-02 2020-12-04 200 70 8922\n",
      "2020-12-04 2020-12-06 200 61 8983\n",
      "2020-12-06 2020-12-08 200 57 9040\n",
      "2020-12-08 2020-12-10 200 75 9115\n",
      "2020-12-10 2020-12-12 200 88 9203\n",
      "2020-12-12 2020-12-14 200 44 9247\n",
      "2020-12-14 2020-12-16 200 74 9321\n",
      "2020-12-16 2020-12-18 200 75 9396\n",
      "2020-12-18 2020-12-20 200 50 9446\n",
      "2020-12-20 2020-12-22 200 59 9505\n",
      "2020-12-22 2020-12-24 200 68 9573\n",
      "2020-12-24 2020-12-26 200 59 9632\n",
      "2020-12-26 2020-12-28 200 40 9672\n",
      "2020-12-28 2020-12-30 200 69 9741\n",
      "2020-12-30 2021-01-01 200 63 9804\n",
      "2021-01-01 2021-01-03 200 54 9858\n",
      "2021-01-03 2021-01-05 200 46 9904\n",
      "2021-01-05 2021-01-07 200 75 9979\n",
      "2021-01-07 2021-01-09 200 71 10050\n",
      "2021-01-09 2021-01-11 200 50 10100\n",
      "2021-01-11 2021-01-13 200 61 10161\n",
      "2021-01-13 2021-01-15 200 69 10230\n",
      "2021-01-15 2021-01-17 200 60 10290\n",
      "2021-01-17 2021-01-19 200 66 10356\n",
      "2021-01-19 2021-01-21 200 92 10448\n",
      "2021-01-21 2021-01-23 200 81 10529\n",
      "2021-01-23 2021-01-25 200 60 10589\n",
      "2021-01-25 2021-01-27 200 83 10672\n",
      "2021-01-27 2021-01-29 200 77 10749\n",
      "2021-01-29 2021-01-31 200 62 10811\n",
      "2021-01-31 2021-02-02 200 61 10872\n",
      "2021-02-02 2021-02-04 200 83 10955\n",
      "2021-02-04 2021-02-06 200 82 11037\n",
      "2021-02-06 2021-02-08 200 52 11089\n",
      "2021-02-08 2021-02-10 200 76 11165\n",
      "2021-02-10 2021-02-12 200 74 11239\n",
      "2021-02-12 2021-02-14 200 56 11295\n",
      "2021-02-14 2021-02-16 200 60 11355\n",
      "2021-02-16 2021-02-18 200 68 11423\n",
      "2021-02-18 2021-02-20 200 66 11489\n",
      "2021-02-20 2021-02-22 200 47 11536\n",
      "2021-02-22 2021-02-24 200 59 11595\n",
      "2021-02-24 2021-02-26 200 53 11648\n",
      "2021-02-26 2021-02-28 200 69 11717\n",
      "2021-02-28 2021-03-02 200 52 11769\n",
      "2021-03-02 2021-03-04 200 62 11831\n",
      "2021-03-04 2021-03-06 200 61 11892\n",
      "2021-03-06 2021-03-08 200 43 11935\n",
      "2021-03-08 2021-03-10 200 69 12004\n",
      "2021-03-10 2021-03-12 200 47 12051\n",
      "2021-03-12 2021-03-14 200 46 12097\n",
      "2021-03-14 2021-03-16 200 43 12140\n",
      "2021-03-16 2021-03-18 200 67 12207\n",
      "2021-03-18 2021-03-20 200 55 12262\n",
      "2021-03-20 2021-03-22 200 47 12309\n",
      "2021-03-22 2021-03-24 200 74 12383\n",
      "2021-03-24 2021-03-26 200 58 12441\n",
      "2021-03-26 2021-03-28 200 56 12497\n",
      "2021-03-28 2021-03-30 200 46 12543\n",
      "2021-03-30 2021-04-01 200 50 12593\n",
      "2021-04-01 2021-04-03 200 43 12636\n",
      "2021-04-03 2021-04-05 200 33 12669\n",
      "2021-04-05 2021-04-07 200 64 12733\n",
      "2021-04-07 2021-04-09 200 54 12787\n",
      "2021-04-09 2021-04-11 200 57 12844\n",
      "2021-04-11 2021-04-13 200 31 12875\n",
      "2021-04-13 2021-04-15 200 51 12926\n",
      "2021-04-15 2021-04-17 200 39 12965\n",
      "2021-04-17 2021-04-19 200 33 12998\n",
      "2021-04-19 2021-04-21 200 53 13051\n",
      "2021-04-21 2021-04-23 200 31 13082\n",
      "2021-04-23 2021-04-25 200 35 13117\n",
      "2021-04-25 2021-04-27 200 40 13157\n",
      "2021-04-27 2021-04-29 200 33 13190\n",
      "2021-04-29 2021-05-01 200 21 13211\n",
      "2021-05-01 2021-05-03 200 20 13231\n",
      "2021-05-03 2021-05-05 200 33 13264\n",
      "2021-05-05 2021-05-07 200 43 13307\n",
      "2021-05-07 2021-05-09 200 40 13347\n",
      "2021-05-09 2021-05-11 200 48 13395\n",
      "2021-05-11 2021-05-13 200 66 13461\n",
      "2021-05-13 2021-05-15 200 37 13498\n",
      "2021-05-15 2021-05-17 200 31 13529\n",
      "2021-05-17 2021-05-19 200 44 13573\n",
      "2021-05-19 2021-05-21 200 46 13619\n",
      "2021-05-21 2021-05-23 200 35 13654\n",
      "2021-05-23 2021-05-25 200 15 13669\n",
      "2021-05-25 2021-05-27 200 17 13686\n",
      "2021-05-27 2021-05-29 200 27 13713\n",
      "2021-05-29 2021-05-31 200 12 13725\n",
      "2021-05-31 2021-06-02 200 26 13751\n",
      "2021-06-02 2021-06-04 200 22 13773\n",
      "2021-06-04 2021-06-06 200 28 13801\n",
      "2021-06-06 2021-06-08 200 37 13838\n",
      "2021-06-08 2021-06-10 200 59 13897\n",
      "2021-06-10 2021-06-12 200 71 13968\n",
      "2021-06-12 2021-06-14 200 51 14019\n",
      "2021-06-14 2021-06-16 200 54 14073\n",
      "2021-06-16 2021-06-18 200 61 14134\n",
      "2021-06-18 2021-06-20 200 44 14178\n",
      "2021-06-20 2021-06-22 200 48 14226\n",
      "2021-06-22 2021-06-24 200 59 14285\n",
      "2021-06-24 2021-06-26 200 66 14351\n",
      "2021-06-26 2021-06-28 200 35 14386\n",
      "2021-06-28 2021-06-30 200 56 14442\n",
      "2021-06-30 2021-07-02 200 74 14516\n",
      "2021-07-02 2021-07-04 200 46 14562\n",
      "2021-07-04 2021-07-06 200 53 14615\n",
      "2021-07-06 2021-07-08 200 39 14654\n",
      "2021-07-08 2021-07-10 200 36 14690\n",
      "2021-07-10 2021-07-12 200 33 14723\n",
      "2021-07-12 2021-07-14 200 52 14775\n",
      "2021-07-14 2021-07-16 200 43 14818\n",
      "2021-07-16 2021-07-18 200 42 14860\n",
      "2021-07-18 2021-07-20 200 27 14887\n",
      "2021-07-20 2021-07-22 200 57 14944\n",
      "2021-07-22 2021-07-24 200 54 14998\n",
      "2021-07-24 2021-07-26 200 39 15037\n",
      "2021-07-26 2021-07-28 200 70 15107\n",
      "2021-07-28 2021-07-30 200 45 15152\n",
      "2021-07-30 2021-08-01 200 35 15187\n",
      "2021-08-01 2021-08-03 200 28 15215\n",
      "2021-08-03 2021-08-05 200 33 15248\n",
      "2021-08-05 2021-08-07 200 37 15285\n",
      "2021-08-07 2021-08-09 200 24 15309\n",
      "2021-08-09 2021-08-11 200 35 15344\n",
      "2021-08-11 2021-08-13 200 31 15375\n",
      "2021-08-13 2021-08-15 200 21 15396\n",
      "2021-08-15 2021-08-17 200 33 15429\n",
      "2021-08-17 2021-08-19 200 37 15466\n",
      "2021-08-19 2021-08-21 200 21 15487\n",
      "2021-08-21 2021-08-23 200 24 15511\n",
      "2021-08-23 2021-08-25 200 30 15541\n",
      "2021-08-25 2021-08-27 200 30 15571\n",
      "2021-08-27 2021-08-29 200 38 15609\n",
      "2021-08-29 2021-08-31 200 35 15644\n",
      "2021-08-31 2021-09-02 200 29 15673\n",
      "2021-09-02 2021-09-04 200 36 15709\n",
      "2021-09-04 2021-09-06 200 31 15740\n",
      "2021-09-06 2021-09-08 200 28 15768\n",
      "2021-09-08 2021-09-10 200 40 15808\n",
      "2021-09-10 2021-09-12 200 33 15841\n",
      "2021-09-12 2021-09-14 200 29 15870\n",
      "2021-09-14 2021-09-16 200 40 15910\n",
      "2021-09-16 2021-09-18 200 41 15951\n",
      "2021-09-18 2021-09-20 200 26 15977\n",
      "2021-09-20 2021-09-22 200 25 16002\n",
      "2021-09-22 2021-09-24 200 32 16034\n",
      "2021-09-24 2021-09-26 200 35 16069\n",
      "2021-09-26 2021-09-28 200 23 16092\n",
      "2021-09-28 2021-09-30 200 36 16128\n",
      "2021-09-30 2021-10-02 200 33 16161\n",
      "2021-10-02 2021-10-04 200 19 16180\n",
      "2021-10-04 2021-10-06 200 32 16212\n",
      "2021-10-06 2021-10-08 200 46 16258\n",
      "2021-10-08 2021-10-10 200 27 16285\n",
      "2021-10-10 2021-10-12 200 37 16322\n",
      "2021-10-12 2021-10-14 200 34 16356\n",
      "2021-10-14 2021-10-16 200 30 16386\n",
      "2021-10-16 2021-10-18 200 34 16420\n",
      "2021-10-18 2021-10-20 200 30 16450\n",
      "2021-10-20 2021-10-22 200 43 16493\n",
      "2021-10-22 2021-10-24 200 45 16538\n",
      "2021-10-24 2021-10-26 200 42 16580\n",
      "2021-10-26 2021-10-28 200 45 16625\n",
      "2021-10-28 2021-10-30 200 49 16674\n",
      "2021-10-30 2021-11-01 200 31 16705\n",
      "2021-11-01 2021-11-03 200 41 16746\n",
      "2021-11-03 2021-11-05 200 54 16800\n",
      "2021-11-05 2021-11-07 200 49 16849\n",
      "2021-11-07 2021-11-09 200 40 16889\n",
      "2021-11-09 2021-11-11 200 61 16950\n",
      "2021-11-11 2021-11-13 200 42 16992\n",
      "2021-11-13 2021-11-15 200 34 17026\n",
      "2021-11-15 2021-11-17 200 44 17070\n",
      "2021-11-17 2021-11-19 200 41 17111\n",
      "2021-11-19 2021-11-21 200 41 17152\n",
      "2021-11-21 2021-11-23 200 23 17175\n",
      "2021-11-23 2021-11-25 200 39 17214\n",
      "2021-11-25 2021-11-27 200 32 17246\n",
      "2021-11-27 2021-11-29 200 25 17271\n",
      "2021-11-29 2021-12-01 200 24 17295\n",
      "2021-12-01 2021-12-03 200 32 17327\n",
      "2021-12-03 2021-12-05 200 37 17364\n",
      "2021-12-05 2021-12-07 200 27 17391\n",
      "2021-12-07 2021-12-09 200 37 17428\n",
      "2021-12-09 2021-12-11 200 36 17464\n",
      "2021-12-11 2021-12-13 200 31 17495\n",
      "2021-12-13 2021-12-15 200 42 17537\n",
      "2021-12-15 2021-12-17 200 41 17578\n",
      "2021-12-17 2021-12-19 200 41 17619\n",
      "2021-12-19 2021-12-21 200 31 17650\n",
      "2021-12-21 2021-12-23 200 34 17684\n",
      "2021-12-23 2021-12-25 200 33 17717\n",
      "2021-12-25 2021-12-27 200 34 17751\n",
      "2021-12-27 2021-12-29 200 30 17781\n",
      "2021-12-29 2021-12-31 200 32 17813\n",
      "2021-12-31 2022-01-02 200 28 17841\n",
      "2022-01-02 2022-01-04 200 27 17868\n",
      "2022-01-04 2022-01-06 200 49 17917\n",
      "2022-01-06 2022-01-08 200 59 17976\n",
      "2022-01-08 2022-01-10 200 39 18015\n",
      "2022-01-10 2022-01-12 200 48 18063\n",
      "2022-01-12 2022-01-14 200 49 18112\n",
      "2022-01-14 2022-01-16 200 31 18143\n",
      "2022-01-16 2022-01-18 200 33 18176\n",
      "2022-01-18 2022-01-20 200 68 18244\n",
      "2022-01-20 2022-01-22 200 60 18304\n",
      "2022-01-22 2022-01-24 200 37 18341\n",
      "2022-01-24 2022-01-26 200 55 18396\n",
      "2022-01-26 2022-01-28 200 44 18440\n",
      "2022-01-28 2022-01-30 200 41 18481\n",
      "2022-01-30 2022-02-01 200 43 18524\n",
      "2022-02-01 2022-02-03 200 50 18574\n",
      "2022-02-03 2022-02-05 200 48 18622\n",
      "2022-02-05 2022-02-07 200 35 18657\n",
      "2022-02-07 2022-02-09 200 40 18697\n",
      "2022-02-09 2022-02-11 200 51 18748\n",
      "2022-02-11 2022-02-13 200 47 18795\n",
      "2022-02-13 2022-02-15 200 45 18840\n",
      "2022-02-15 2022-02-17 200 62 18902\n",
      "2022-02-17 2022-02-19 200 52 18954\n",
      "2022-02-19 2022-02-21 200 30 18984\n",
      "2022-02-21 2022-02-23 200 67 19051\n",
      "2022-02-23 2022-02-25 200 49 19100\n",
      "2022-02-25 2022-02-27 200 58 19158\n",
      "2022-02-27 2022-03-01 200 56 19214\n",
      "2022-03-01 2022-03-03 200 73 19287\n",
      "2022-03-03 2022-03-05 200 57 19344\n",
      "2022-03-05 2022-03-07 200 35 19379\n",
      "2022-03-07 2022-03-09 200 62 19441\n",
      "2022-03-09 2022-03-11 200 53 19494\n",
      "2022-03-11 2022-03-13 200 46 19540\n",
      "2022-03-13 2022-03-15 200 52 19592\n",
      "2022-03-15 2022-03-17 200 59 19651\n",
      "2022-03-17 2022-03-19 200 33 19684\n",
      "2022-03-19 2022-03-21 200 49 19733\n",
      "2022-03-21 2022-03-23 200 69 19802\n",
      "2022-03-23 2022-03-25 200 69 19871\n",
      "2022-03-25 2022-03-27 200 48 19919\n",
      "2022-03-27 2022-03-29 200 49 19968\n",
      "2022-03-29 2022-03-31 200 64 20032\n",
      "2022-03-31 2022-04-02 200 71 20103\n",
      "2022-04-02 2022-04-04 200 42 20145\n",
      "2022-04-04 2022-04-06 200 67 20212\n",
      "2022-04-06 2022-04-08 200 86 20298\n",
      "2022-04-08 2022-04-10 200 67 20365\n",
      "2022-04-10 2022-04-12 200 50 20415\n",
      "2022-04-12 2022-04-14 200 78 20493\n",
      "2022-04-14 2022-04-16 200 71 20564\n",
      "2022-04-16 2022-04-18 200 45 20609\n",
      "2022-04-18 2022-04-20 200 57 20666\n",
      "2022-04-20 2022-04-22 200 85 20751\n",
      "2022-04-22 2022-04-24 200 64 20815\n",
      "2022-04-24 2022-04-26 200 32 20847\n",
      "2022-04-26 2022-04-28 200 42 20889\n",
      "2022-04-28 2022-04-30 200 25 20914\n",
      "2022-04-30 2022-05-02 200 35 20949\n",
      "2022-05-02 2022-05-04 200 36 20985\n",
      "2022-05-04 2022-05-06 200 35 21020\n",
      "2022-05-06 2022-05-08 200 25 21045\n",
      "2022-05-08 2022-05-10 200 30 21075\n",
      "2022-05-10 2022-05-12 200 46 21121\n",
      "2022-05-12 2022-05-14 200 56 21177\n",
      "2022-05-14 2022-05-16 200 43 21220\n",
      "2022-05-16 2022-05-18 200 41 21261\n",
      "2022-05-18 2022-05-20 200 36 21297\n",
      "2022-05-20 2022-05-22 200 34 21331\n",
      "2022-05-22 2022-05-24 200 42 21373\n",
      "2022-05-24 2022-05-26 200 56 21429\n",
      "2022-05-26 2022-05-28 200 50 21479\n",
      "2022-05-28 2022-05-30 200 44 21523\n",
      "2022-05-30 2022-06-01 200 67 21590\n",
      "2022-06-01 2022-06-03 200 67 21657\n",
      "2022-06-03 2022-06-05 200 44 21701\n",
      "2022-06-05 2022-06-07 200 70 21771\n",
      "2022-06-07 2022-06-09 200 86 21857\n",
      "2022-06-09 2022-06-11 200 69 21926\n",
      "2022-06-11 2022-06-13 200 64 21990\n",
      "2022-06-13 2022-06-15 200 78 22068\n",
      "2022-06-15 2022-06-17 200 71 22139\n",
      "2022-06-17 2022-06-19 200 68 22207\n",
      "2022-06-19 2022-06-21 200 55 22262\n",
      "2022-06-21 2022-06-23 200 73 22335\n",
      "2022-06-23 2022-06-25 200 47 22382\n",
      "2022-06-25 2022-06-27 200 42 22424\n",
      "2022-06-27 2022-06-29 200 38 22462\n",
      "2022-06-29 2022-07-01 200 41 22503\n",
      "2022-07-01 2022-07-03 200 52 22555\n",
      "2022-07-03 2022-07-05 200 33 22588\n",
      "2022-07-05 2022-07-07 200 63 22651\n",
      "2022-07-07 2022-07-09 200 51 22702\n",
      "2022-07-09 2022-07-11 200 47 22749\n",
      "2022-07-11 2022-07-13 200 49 22798\n",
      "2022-07-13 2022-07-15 200 48 22846\n",
      "2022-07-15 2022-07-17 200 100 22946\n",
      "2022-07-17 2022-07-19 200 57 23003\n",
      "2022-07-19 2022-07-21 200 64 23067\n",
      "2022-07-21 2022-07-23 200 38 23105\n",
      "2022-07-23 2022-07-25 200 33 23138\n",
      "2022-07-25 2022-07-27 200 50 23188\n",
      "2022-07-27 2022-07-29 200 24 23212\n",
      "2022-07-29 2022-07-31 200 13 23225\n",
      "2022-07-31 2022-08-02 200 23 23248\n",
      "2022-08-02 2022-08-04 200 25 23273\n",
      "2022-08-04 2022-08-06 200 37 23310\n",
      "2022-08-06 2022-08-08 200 33 23343\n",
      "2022-08-08 2022-08-10 200 41 23384\n",
      "2022-08-10 2022-08-12 200 39 23423\n",
      "2022-08-12 2022-08-14 200 45 23468\n",
      "2022-08-14 2022-08-16 200 28 23496\n",
      "2022-08-16 2022-08-18 200 44 23540\n",
      "2022-08-18 2022-08-20 200 42 23582\n",
      "2022-08-20 2022-08-22 200 35 23617\n",
      "2022-08-22 2022-08-24 200 35 23652\n",
      "2022-08-24 2022-08-26 200 40 23692\n",
      "2022-08-26 2022-08-28 200 41 23733\n",
      "2022-08-28 2022-08-30 200 48 23781\n",
      "2022-08-30 2022-09-01 200 51 23832\n",
      "2022-09-01 2022-09-03 200 54 23886\n",
      "2022-09-03 2022-09-05 200 37 23923\n",
      "2022-09-05 2022-09-07 200 52 23975\n",
      "2022-09-07 2022-09-09 200 45 24020\n",
      "2022-09-09 2022-09-11 200 40 24060\n",
      "2022-09-11 2022-09-13 200 46 24106\n",
      "2022-09-13 2022-09-15 200 45 24151\n",
      "2022-09-15 2022-09-17 200 56 24207\n",
      "2022-09-17 2022-09-19 200 33 24240\n",
      "2022-09-19 2022-09-21 200 40 24280\n",
      "2022-09-21 2022-09-23 200 41 24321\n",
      "2022-09-23 2022-09-25 200 45 24366\n",
      "2022-09-25 2022-09-27 200 36 24402\n",
      "2022-09-27 2022-09-29 200 58 24460\n",
      "2022-09-29 2022-10-01 200 50 24510\n",
      "2022-10-01 2022-10-03 200 36 24546\n",
      "2022-10-03 2022-10-05 200 37 24583\n",
      "2022-10-05 2022-10-07 200 53 24636\n",
      "2022-10-07 2022-10-09 200 35 24671\n",
      "2022-10-09 2022-10-11 200 42 24713\n",
      "2022-10-11 2022-10-13 200 44 24757\n",
      "2022-10-13 2022-10-15 200 61 24818\n",
      "2022-10-15 2022-10-17 200 37 24855\n",
      "2022-10-17 2022-10-19 200 47 24902\n",
      "2022-10-19 2022-10-21 200 46 24948\n",
      "2022-10-21 2022-10-23 200 35 24983\n",
      "2022-10-23 2022-10-25 200 34 25017\n",
      "2022-10-25 2022-10-27 200 50 25067\n",
      "2022-10-27 2022-10-29 200 34 25101\n",
      "2022-10-29 2022-10-31 200 34 25135\n",
      "2022-10-31 2022-11-02 200 33 25168\n",
      "2022-11-02 2022-11-04 200 47 25215\n",
      "2022-11-04 2022-11-06 200 38 25253\n",
      "2022-11-06 2022-11-08 200 32 25285\n",
      "2022-11-08 2022-11-10 200 46 25331\n",
      "2022-11-10 2022-11-12 200 48 25379\n",
      "2022-11-12 2022-11-14 200 35 25414\n",
      "2022-11-14 2022-11-16 200 54 25468\n",
      "2022-11-16 2022-11-18 200 47 25515\n",
      "2022-11-18 2022-11-20 200 35 25550\n",
      "2022-11-20 2022-11-22 200 41 25591\n",
      "2022-11-22 2022-11-24 200 39 25630\n",
      "2022-11-24 2022-11-26 200 39 25669\n",
      "2022-11-26 2022-11-28 200 35 25704\n",
      "2022-11-28 2022-11-30 200 52 25756\n",
      "2022-11-30 2022-12-02 200 48 25804\n",
      "2022-12-02 2022-12-04 200 44 25848\n",
      "2022-12-04 2022-12-06 200 34 25882\n",
      "2022-12-06 2022-12-08 200 35 25917\n",
      "2022-12-08 2022-12-10 200 33 25950\n",
      "2022-12-10 2022-12-12 200 31 25981\n",
      "2022-12-12 2022-12-14 200 47 26028\n",
      "2022-12-14 2022-12-16 200 46 26074\n",
      "2022-12-16 2022-12-18 200 29 26103\n",
      "2022-12-18 2022-12-20 200 40 26143\n",
      "2022-12-20 2022-12-22 200 37 26180\n",
      "2022-12-22 2022-12-24 200 40 26220\n",
      "2022-12-24 2022-12-26 200 39 26259\n",
      "2022-12-26 2022-12-28 200 40 26299\n",
      "2022-12-28 2022-12-30 200 33 26332\n",
      "2022-12-30 2023-01-01 200 42 26374\n",
      "2023-01-01 2023-01-03 200 30 26404\n",
      "2023-01-03 2023-01-05 200 41 26445\n",
      "2023-01-05 2023-01-07 200 62 26507\n",
      "2023-01-07 2023-01-09 200 35 26542\n",
      "2023-01-09 2023-01-11 200 45 26587\n",
      "2023-01-11 2023-01-13 200 62 26649\n",
      "2023-01-13 2023-01-15 200 48 26697\n",
      "2023-01-15 2023-01-17 200 30 26727\n",
      "2023-01-17 2023-01-19 200 27 26754\n",
      "2023-01-19 2023-01-21 200 42 26796\n",
      "2023-01-21 2023-01-23 200 35 26831\n",
      "2023-01-23 2023-01-25 200 50 26881\n",
      "2023-01-25 2023-01-27 200 53 26934\n",
      "2023-01-27 2023-01-29 200 55 26989\n",
      "2023-01-29 2023-01-31 200 38 27027\n",
      "2023-01-31 2023-02-02 200 61 27088\n",
      "2023-02-02 2023-02-04 200 47 27135\n",
      "2023-02-04 2023-02-06 200 30 27165\n",
      "2023-02-06 2023-02-08 200 69 27234\n",
      "2023-02-08 2023-02-10 200 62 27296\n",
      "2023-02-10 2023-02-12 200 42 27338\n",
      "2023-02-12 2023-02-14 200 39 27377\n",
      "2023-02-14 2023-02-16 200 45 27422\n",
      "2023-02-16 2023-02-18 200 51 27473\n",
      "2023-02-18 2023-02-20 200 37 27510\n",
      "2023-02-20 2023-02-22 200 47 27557\n",
      "2023-02-22 2023-02-24 200 60 27617\n",
      "2023-02-24 2023-02-26 200 100 27717\n",
      "2023-02-26 2023-02-28 200 100 27817\n",
      "2023-02-28 2023-03-02 200 89 27906\n",
      "2023-03-02 2023-03-04 200 50 27956\n",
      "2023-03-04 2023-03-06 200 32 27988\n",
      "2023-03-06 2023-03-08 200 36 28024\n",
      "2023-03-08 2023-03-10 200 53 28077\n",
      "2023-03-10 2023-03-12 200 34 28111\n",
      "2023-03-12 2023-03-14 200 38 28149\n",
      "2023-03-14 2023-03-16 200 34 28183\n",
      "2023-03-16 2023-03-18 200 42 28225\n",
      "2023-03-18 2023-03-20 200 62 28287\n",
      "2023-03-20 2023-03-22 200 48 28335\n",
      "2023-03-22 2023-03-24 200 61 28396\n",
      "2023-03-24 2023-03-26 200 46 28442\n",
      "2023-03-26 2023-03-28 200 31 28473\n",
      "2023-03-28 2023-03-30 200 44 28517\n",
      "2023-03-30 2023-04-01 200 55 28572\n",
      "2023-04-01 2023-04-03 200 28 28600\n",
      "2023-04-03 2023-04-05 200 49 28649\n",
      "2023-04-05 2023-04-07 200 31 28680\n",
      "2023-04-07 2023-04-09 200 25 28705\n",
      "2023-04-09 2023-04-11 200 43 28748\n",
      "2023-04-11 2023-04-13 200 32 28780\n",
      "2023-04-13 2023-04-15 200 27 28807\n",
      "2023-04-15 2023-04-17 200 26 28833\n",
      "2023-04-17 2023-04-19 200 50 28883\n",
      "2023-04-19 2023-04-21 200 28 28911\n",
      "2023-04-21 2023-04-23 200 32 28943\n",
      "2023-04-23 2023-04-25 200 31 28974\n",
      "2023-04-25 2023-04-27 200 32 29006\n",
      "2023-04-27 2023-04-29 200 34 29040\n",
      "2023-04-29 2023-05-01 200 16 29056\n",
      "2023-05-01 2023-05-03 200 39 29095\n",
      "2023-05-03 2023-05-05 200 37 29132\n",
      "2023-05-05 2023-05-07 200 25 29157\n",
      "2023-05-07 2023-05-09 200 31 29188\n",
      "2023-05-09 2023-05-11 200 43 29231\n",
      "2023-05-11 2023-05-13 200 39 29270\n",
      "2023-05-13 2023-05-15 200 26 29296\n",
      "2023-05-15 2023-05-17 200 39 29335\n",
      "2023-05-17 2023-05-19 200 44 29379\n",
      "2023-05-19 2023-05-21 200 30 29409\n",
      "2023-05-21 2023-05-23 200 29 29438\n",
      "2023-05-23 2023-05-25 200 32 29470\n",
      "2023-05-25 2023-05-27 200 40 29510\n",
      "2023-05-27 2023-05-29 200 30 29540\n",
      "2023-05-29 2023-05-31 200 65 29605\n",
      "2023-05-31 2023-06-02 200 39 29644\n",
      "2023-06-02 2023-06-04 200 32 29676\n",
      "2023-06-04 2023-06-06 200 34 29710\n",
      "2023-06-06 2023-06-08 200 33 29743\n",
      "2023-06-08 2023-06-10 200 40 29783\n",
      "2023-06-10 2023-06-12 200 30 29813\n",
      "2023-06-12 2023-06-14 200 38 29851\n",
      "2023-06-14 2023-06-16 200 41 29892\n",
      "2023-06-16 2023-06-18 200 26 29918\n",
      "2023-06-18 2023-06-20 200 28 29946\n",
      "2023-06-20 2023-06-22 200 35 29981\n"
     ]
    }
   ],
   "source": [
    "import datetime\n",
    "import time\n",
    "\n",
    "begin = datetime.date(2020,1,1)\n",
    "end = datetime.date(2023,6,20)\n",
    "delta = datetime.timedelta(2)\n",
    "d = begin\n",
    "\n",
    "results_list = []\n",
    "\n",
    "while d<=end:\n",
    "    temp_start = d\n",
    "    temp_end = d + delta\n",
    "\n",
    "    data = pct.ct_get_posts(api_token=api_token,count=100,start_date=temp_start,end_date=temp_end)\n",
    "    temp_target = data['result']['posts']\n",
    "    results_list = results_list + temp_target\n",
    "    print(temp_start,temp_end,data['status'],len(temp_target),len(results_list))\n",
    "    time.sleep(12)\n",
    "    d = d + delta\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-06-27T01:41:04.792176900Z",
     "start_time": "2023-06-27T01:41:01.933172700Z"
    }
   },
   "outputs": [],
   "source": [
    "import json\n",
    "\n",
    "final = json.dumps(results_list,indent=2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2023-06-27T01:44:30.400991300Z",
     "start_time": "2023-06-27T01:44:29.466216300Z"
    }
   },
   "outputs": [],
   "source": [
    "with open(\"posts.json\", \"w\") as target:\n",
    "   json.dump(final, target)"
   ]
  }
 ],
 "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.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}