nvda_1min_dwnld_refine_space.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import json\n",
    "import mysql.connector\n",
    "from datetime import datetime, timedelta, timezone\n",
    "import time\n",
    "import nvda_config\n",
    "import twelvedata as td\n",
    "from twelvedata import TDClient\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# set up login\n",
    "Cpassword = nvda_config.mysql_password\n",
    "td = TDClient(apikey=nvda_config.twelve_api_nvda) \n",
    "base_url = 'https://api.twelvedata.com'\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Estab;ish MySQL object\n",
    "mydb = mysql.connector.connect(\n",
    "    host=\"localhost\",   \n",
    "    user=\"root\",         \n",
    "    password=Cpassword,  \n",
    "    database=\"nvdav1\"   \n",
    ")\n",
    "\n",
    "mycursor = mydb.cursor()\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requests elapsed:  1  at time: 2024-08-07 06:39:15.096636\n",
      "Requests elapsed:  2  at time: 2024-08-07 06:40:15.333265\n",
      "Requests elapsed:  3  at time: 2024-08-07 06:41:15.564956\n",
      "Requests elapsed:  4  at time: 2024-08-07 06:42:15.810862\n",
      "Requests elapsed:  5  at time: 2024-08-07 06:43:16.074925\n",
      "Requests elapsed:  6  at time: 2024-08-07 06:44:16.326217\n",
      "Requests elapsed:  7  at time: 2024-08-07 06:45:16.635438\n",
      "Requests elapsed:  8  at time: 2024-08-07 06:46:16.869411\n",
      "Requests elapsed:  9  at time: 2024-08-07 06:47:17.146361\n",
      "Requests elapsed:  10  at time: 2024-08-07 06:48:17.400895\n",
      "Requests elapsed:  11  at time: 2024-08-07 06:49:17.657995\n",
      "Requests elapsed:  12  at time: 2024-08-07 06:50:17.898012\n",
      "Requests elapsed:  13  at time: 2024-08-07 06:51:18.144186\n",
      "Requests elapsed:  14  at time: 2024-08-07 06:52:18.406276\n",
      "Requests elapsed:  15  at time: 2024-08-07 06:53:18.642544\n",
      "Requests elapsed:  16  at time: 2024-08-07 06:54:18.895384\n",
      "Requests elapsed:  17  at time: 2024-08-07 06:55:19.128995\n",
      "Requests elapsed:  18  at time: 2024-08-07 06:56:19.383285\n",
      "Requests elapsed:  19  at time: 2024-08-07 06:57:19.622165\n",
      "Requests elapsed:  20  at time: 2024-08-07 06:58:19.868390\n",
      "Requests elapsed:  21  at time: 2024-08-07 06:59:20.113744\n",
      "Requests elapsed:  22  at time: 2024-08-07 07:00:20.377810\n",
      "Requests elapsed:  23  at time: 2024-08-07 07:01:20.624187\n",
      "Requests elapsed:  24  at time: 2024-08-07 07:02:20.871786\n",
      "Requests elapsed:  25  at time: 2024-08-07 07:03:21.115706\n",
      "Requests elapsed:  26  at time: 2024-08-07 07:04:21.378278\n",
      "Requests elapsed:  27  at time: 2024-08-07 07:05:21.607894\n",
      "Requests elapsed:  28  at time: 2024-08-07 07:06:21.844476\n",
      "Requests elapsed:  29  at time: 2024-08-07 07:07:22.100459\n",
      "Requests elapsed:  30  at time: 2024-08-07 07:08:22.369110\n",
      "Requests elapsed:  31  at time: 2024-08-07 07:09:22.669638\n",
      "Requests elapsed:  32  at time: 2024-08-07 07:10:22.909682\n",
      "Requests elapsed:  33  at time: 2024-08-07 07:11:23.152472\n",
      "Requests elapsed:  34  at time: 2024-08-07 07:12:23.399953\n",
      "Requests elapsed:  35  at time: 2024-08-07 07:13:23.646160\n",
      "Requests elapsed:  36  at time: 2024-08-07 07:14:23.919514\n",
      "Requests elapsed:  37  at time: 2024-08-07 07:15:24.154705\n",
      "Requests elapsed:  38  at time: 2024-08-07 07:16:24.399037\n",
      "Requests elapsed:  39  at time: 2024-08-07 07:17:24.646857\n",
      "Requests elapsed:  40  at time: 2024-08-07 07:18:24.877341\n",
      "Requests elapsed:  41  at time: 2024-08-07 07:19:25.123895\n",
      "Requests elapsed:  42  at time: 2024-08-07 07:20:25.370116\n",
      "Requests elapsed:  43  at time: 2024-08-07 07:21:25.617061\n",
      "Requests elapsed:  44  at time: 2024-08-07 07:22:25.863573\n",
      "Requests elapsed:  45  at time: 2024-08-07 07:23:26.073613\n",
      "Requests elapsed:  46  at time: 2024-08-07 07:24:26.327805\n",
      "Requests elapsed:  47  at time: 2024-08-07 07:25:26.553454\n",
      "Requests elapsed:  48  at time: 2024-08-07 07:26:26.764656\n",
      "Requests elapsed:  49  at time: 2024-08-07 07:27:27.036847\n",
      "Requests elapsed:  50  at time: 2024-08-07 07:28:27.331106\n",
      "Requests elapsed:  51  at time: 2024-08-07 07:29:27.586712\n",
      "Requests elapsed:  52  at time: 2024-08-07 07:30:27.849354\n",
      "Requests elapsed:  53  at time: 2024-08-07 07:31:28.095849\n",
      "Requests elapsed:  54  at time: 2024-08-07 07:32:28.358469\n",
      "Requests elapsed:  55  at time: 2024-08-07 07:33:28.588071\n",
      "Requests elapsed:  56  at time: 2024-08-07 07:34:28.867121\n",
      "Requests elapsed:  57  at time: 2024-08-07 07:35:29.230458\n",
      "Requests elapsed:  58  at time: 2024-08-07 07:36:29.527170\n",
      "Requests elapsed:  59  at time: 2024-08-07 07:37:29.798538\n",
      "Requests elapsed:  60  at time: 2024-08-07 07:38:30.019613\n",
      "Requests elapsed:  61  at time: 2024-08-07 07:39:30.284737\n",
      "Requests elapsed:  62  at time: 2024-08-07 07:40:30.529288\n",
      "Requests elapsed:  63  at time: 2024-08-07 07:41:30.802179\n",
      "Requests elapsed:  64  at time: 2024-08-07 07:42:31.046964\n",
      "Requests elapsed:  65  at time: 2024-08-07 07:43:31.284529\n",
      "Requests elapsed:  66  at time: 2024-08-07 07:44:31.536711\n",
      "Requests elapsed:  67  at time: 2024-08-07 07:45:31.760340\n",
      "Requests elapsed:  68  at time: 2024-08-07 07:46:32.405117\n",
      "Requests elapsed:  69  at time: 2024-08-07 07:47:32.636148\n",
      "Requests elapsed:  70  at time: 2024-08-07 07:48:32.899902\n",
      "Requests elapsed:  71  at time: 2024-08-07 07:49:33.139101\n",
      "Requests elapsed:  72  at time: 2024-08-07 07:50:33.462163\n",
      "Requests elapsed:  73  at time: 2024-08-07 07:51:33.696791\n",
      "Requests elapsed:  74  at time: 2024-08-07 07:52:33.933630\n",
      "Requests elapsed:  75  at time: 2024-08-07 07:53:34.166011\n",
      "Requests elapsed:  76  at time: 2024-08-07 07:54:34.384969\n",
      "Requests elapsed:  77  at time: 2024-08-07 07:55:34.790489\n",
      "Requests elapsed:  78  at time: 2024-08-07 07:56:35.035644\n",
      "Requests elapsed:  79  at time: 2024-08-07 07:57:35.365163\n",
      "Requests elapsed:  80  at time: 2024-08-07 07:58:35.610760\n",
      "Requests elapsed:  81  at time: 2024-08-07 07:59:35.841363\n",
      "Requests elapsed:  82  at time: 2024-08-07 08:00:36.103904\n",
      "Requests elapsed:  83  at time: 2024-08-07 08:01:36.351029\n",
      "Requests elapsed:  84  at time: 2024-08-07 08:02:36.596951\n",
      "Requests elapsed:  85  at time: 2024-08-07 08:03:36.861091\n",
      "Requests elapsed:  86  at time: 2024-08-07 08:04:37.088925\n",
      "Requests elapsed:  87  at time: 2024-08-07 08:05:37.336330\n",
      "Requests elapsed:  88  at time: 2024-08-07 08:06:37.599481\n",
      "Requests elapsed:  89  at time: 2024-08-07 08:07:37.845417\n",
      "Requests elapsed:  90  at time: 2024-08-07 08:08:39.022060\n",
      "Requests elapsed:  91  at time: 2024-08-07 08:09:39.288144\n",
      "Requests elapsed:  92  at time: 2024-08-07 08:10:39.516040\n",
      "Requests elapsed:  93  at time: 2024-08-07 08:11:39.755673\n",
      "Requests elapsed:  94  at time: 2024-08-07 08:12:40.007040\n",
      "Requests elapsed:  95  at time: 2024-08-07 08:13:40.244076\n",
      "Requests elapsed:  96  at time: 2024-08-07 08:14:40.464444\n",
      "Requests elapsed:  97  at time: 2024-08-07 08:15:40.707530\n",
      "Requests elapsed:  98  at time: 2024-08-07 08:16:40.933881\n",
      "Requests elapsed:  99  at time: 2024-08-07 08:17:41.205452\n",
      "Requests elapsed:  100  at time: 2024-08-07 08:18:41.459592\n",
      "Requests elapsed:  101  at time: 2024-08-07 08:19:41.684034\n",
      "Requests elapsed:  102  at time: 2024-08-07 08:20:41.940240\n",
      "Requests elapsed:  103  at time: 2024-08-07 08:21:42.185446\n",
      "Requests elapsed:  104  at time: 2024-08-07 08:22:42.419411\n",
      "Requests elapsed:  105  at time: 2024-08-07 08:23:42.684337\n",
      "Requests elapsed:  106  at time: 2024-08-07 08:24:42.947428\n",
      "Requests elapsed:  107  at time: 2024-08-07 08:25:43.198419\n",
      "Requests elapsed:  108  at time: 2024-08-07 08:26:43.433529\n",
      "Requests elapsed:  109  at time: 2024-08-07 08:27:43.682865\n",
      "Requests elapsed:  110  at time: 2024-08-07 08:28:43.911893\n",
      "Requests elapsed:  111  at time: 2024-08-07 08:29:44.148504\n",
      "Requests elapsed:  112  at time: 2024-08-07 08:30:44.399245\n",
      "Requests elapsed:  113  at time: 2024-08-07 08:31:44.631610\n",
      "Requests elapsed:  114  at time: 2024-08-07 08:32:44.885498\n",
      "Requests elapsed:  115  at time: 2024-08-07 08:33:45.113356\n",
      "Requests elapsed:  116  at time: 2024-08-07 08:34:45.360131\n",
      "Requests elapsed:  117  at time: 2024-08-07 08:35:45.587456\n",
      "Requests elapsed:  118  at time: 2024-08-07 08:36:45.825534\n",
      "Requests elapsed:  119  at time: 2024-08-07 08:37:46.069127\n",
      "Requests elapsed:  120  at time: 2024-08-07 08:38:46.341002\n",
      "Requests elapsed:  121  at time: 2024-08-07 08:39:46.560320\n",
      "Requests elapsed:  122  at time: 2024-08-07 08:40:46.805799\n",
      "Requests elapsed:  123  at time: 2024-08-07 08:41:47.048900\n",
      "Requests elapsed:  124  at time: 2024-08-07 08:42:47.304868\n",
      "Requests elapsed:  125  at time: 2024-08-07 08:43:47.995854\n",
      "Requests elapsed:  126  at time: 2024-08-07 08:44:48.224645\n",
      "Requests elapsed:  127  at time: 2024-08-07 08:45:48.462796\n",
      "Requests elapsed:  128  at time: 2024-08-07 08:46:49.130678\n",
      "Requests elapsed:  129  at time: 2024-08-07 08:47:49.361877\n",
      "Requests elapsed:  130  at time: 2024-08-07 08:48:49.592064\n",
      "Requests elapsed:  131  at time: 2024-08-07 08:49:49.836419\n",
      "Requests elapsed:  132  at time: 2024-08-07 08:50:50.078019\n",
      "Requests elapsed:  133  at time: 2024-08-07 08:51:50.313518\n",
      "Requests elapsed:  134  at time: 2024-08-07 08:52:50.555255\n",
      "Requests elapsed:  135  at time: 2024-08-07 08:53:50.830971\n",
      "Requests elapsed:  136  at time: 2024-08-07 08:54:51.173113\n",
      "Requests elapsed:  137  at time: 2024-08-07 08:55:51.456959\n",
      "Requests elapsed:  138  at time: 2024-08-07 08:56:51.728510\n",
      "Requests elapsed:  139  at time: 2024-08-07 08:57:52.003519\n",
      "Requests elapsed:  140  at time: 2024-08-07 08:58:52.277592\n",
      "Requests elapsed:  141  at time: 2024-08-07 08:59:52.519569\n",
      "Requests elapsed:  142  at time: 2024-08-07 09:00:53.323727\n",
      "Requests elapsed:  143  at time: 2024-08-07 09:01:53.743414\n",
      "Requests elapsed:  144  at time: 2024-08-07 09:02:53.985823\n",
      "Requests elapsed:  145  at time: 2024-08-07 09:03:54.260013\n",
      "Requests elapsed:  146  at time: 2024-08-07 09:04:54.518430\n",
      "Requests elapsed:  147  at time: 2024-08-07 09:05:54.788970\n",
      "Requests elapsed:  148  at time: 2024-08-07 09:06:55.075040\n",
      "Requests elapsed:  149  at time: 2024-08-07 09:07:55.320950\n",
      "Requests elapsed:  150  at time: 2024-08-07 09:08:55.569914\n",
      "Requests elapsed:  151  at time: 2024-08-07 09:09:55.880601\n",
      "Requests elapsed:  152  at time: 2024-08-07 09:10:56.176097\n",
      "Requests elapsed:  153  at time: 2024-08-07 09:11:56.425952\n",
      "Requests elapsed:  154  at time: 2024-08-07 09:12:56.704067\n",
      "Requests elapsed:  155  at time: 2024-08-07 09:13:56.988268\n",
      "Requests elapsed:  156  at time: 2024-08-07 09:14:57.252827\n",
      "Requests elapsed:  157  at time: 2024-08-07 09:15:57.543808\n",
      "Requests elapsed:  158  at time: 2024-08-07 09:16:57.839070\n",
      "Requests elapsed:  159  at time: 2024-08-07 09:17:58.110587\n",
      "Requests elapsed:  160  at time: 2024-08-07 09:18:58.380338\n",
      "Requests elapsed:  161  at time: 2024-08-07 09:19:58.667117\n",
      "Requests elapsed:  162  at time: 2024-08-07 09:20:58.922762\n",
      "Requests elapsed:  163  at time: 2024-08-07 09:21:59.192641\n",
      "Requests elapsed:  164  at time: 2024-08-07 09:22:59.465812\n",
      "Requests elapsed:  165  at time: 2024-08-07 09:23:59.750218\n",
      "Requests elapsed:  166  at time: 2024-08-07 09:25:00.007590\n",
      "Requests elapsed:  167  at time: 2024-08-07 09:26:00.280525\n",
      "Requests elapsed:  168  at time: 2024-08-07 09:27:00.584122\n",
      "Requests elapsed:  169  at time: 2024-08-07 09:28:00.849274\n",
      "Requests elapsed:  170  at time: 2024-08-07 09:29:01.107266\n",
      "Requests elapsed:  171  at time: 2024-08-07 09:30:01.374470\n",
      "Requests elapsed:  172  at time: 2024-08-07 09:31:02.154658\n",
      "Requests elapsed:  173  at time: 2024-08-07 09:32:02.419710\n",
      "Requests elapsed:  174  at time: 2024-08-07 09:33:02.980612\n",
      "Requests elapsed:  175  at time: 2024-08-07 09:34:03.303278\n",
      "Requests elapsed:  176  at time: 2024-08-07 09:35:03.572553\n",
      "Requests elapsed:  177  at time: 2024-08-07 09:36:03.852847\n",
      "Requests elapsed:  178  at time: 2024-08-07 09:37:04.098274\n",
      "Requests elapsed:  179  at time: 2024-08-07 09:38:04.359125\n",
      "Requests elapsed:  180  at time: 2024-08-07 09:39:04.638668\n",
      "Requests elapsed:  181  at time: 2024-08-07 09:40:04.897858\n",
      "Requests elapsed:  182  at time: 2024-08-07 09:41:05.176919\n",
      "Requests elapsed:  183  at time: 2024-08-07 09:42:05.437396\n",
      "Requests elapsed:  184  at time: 2024-08-07 09:43:05.690681\n",
      "Requests elapsed:  185  at time: 2024-08-07 09:44:05.986715\n",
      "Requests elapsed:  186  at time: 2024-08-07 09:45:06.266804\n",
      "Requests elapsed:  187  at time: 2024-08-07 09:46:06.548834\n",
      "Requests elapsed:  188  at time: 2024-08-07 09:47:06.830313\n",
      "Requests elapsed:  189  at time: 2024-08-07 09:48:07.121826\n",
      "Requests elapsed:  190  at time: 2024-08-07 09:49:07.390460\n",
      "Requests elapsed:  191  at time: 2024-08-07 09:50:07.676451\n",
      "Requests elapsed:  192  at time: 2024-08-07 09:51:07.952279\n",
      "Requests elapsed:  193  at time: 2024-08-07 09:52:08.232345\n",
      "Requests elapsed:  194  at time: 2024-08-07 09:53:08.494688\n",
      "Requests elapsed:  195  at time: 2024-08-07 09:54:08.733230\n",
      "Requests elapsed:  196  at time: 2024-08-07 09:55:09.040979\n",
      "Requests elapsed:  197  at time: 2024-08-07 09:56:09.292174\n",
      "Requests elapsed:  198  at time: 2024-08-07 09:57:09.526027\n",
      "Requests elapsed:  199  at time: 2024-08-07 09:58:09.811398\n",
      "Requests elapsed:  200  at time: 2024-08-07 09:59:10.090834\n",
      "Requests elapsed:  201  at time: 2024-08-07 10:00:10.351525\n",
      "Requests elapsed:  202  at time: 2024-08-07 10:01:10.644332\n",
      "Requests elapsed:  203  at time: 2024-08-07 10:02:10.904790\n",
      "Requests elapsed:  204  at time: 2024-08-07 10:03:11.183645\n",
      "Requests elapsed:  205  at time: 2024-08-07 10:04:11.477520\n",
      "Requests elapsed:  206  at time: 2024-08-07 10:05:11.750203\n",
      "Requests elapsed:  207  at time: 2024-08-07 10:06:12.049104\n",
      "Requests elapsed:  208  at time: 2024-08-07 10:07:12.305410\n",
      "Requests elapsed:  209  at time: 2024-08-07 10:08:12.582888\n",
      "Requests elapsed:  210  at time: 2024-08-07 10:09:12.830071\n",
      "Requests elapsed:  211  at time: 2024-08-07 10:10:13.123288\n",
      "Requests elapsed:  212  at time: 2024-08-07 10:11:13.410273\n",
      "Requests elapsed:  213  at time: 2024-08-07 10:12:13.708034\n",
      "Requests elapsed:  214  at time: 2024-08-07 10:13:13.979930\n",
      "Requests elapsed:  215  at time: 2024-08-07 10:14:14.248438\n",
      "Requests elapsed:  216  at time: 2024-08-07 10:15:14.506915\n",
      "Requests elapsed:  217  at time: 2024-08-07 10:16:14.768079\n",
      "Requests elapsed:  218  at time: 2024-08-07 10:17:15.061627\n",
      "Requests elapsed:  219  at time: 2024-08-07 10:18:15.311741\n",
      "Requests elapsed:  220  at time: 2024-08-07 10:19:15.556590\n",
      "Requests elapsed:  221  at time: 2024-08-07 10:20:15.852897\n",
      "Requests elapsed:  222  at time: 2024-08-07 10:21:16.128656\n",
      "Requests elapsed:  223  at time: 2024-08-07 10:22:16.478825\n",
      "Requests elapsed:  224  at time: 2024-08-07 10:23:16.765810\n",
      "Requests elapsed:  225  at time: 2024-08-07 10:24:17.016740\n",
      "Requests elapsed:  226  at time: 2024-08-07 10:25:17.306338\n",
      "Requests elapsed:  227  at time: 2024-08-07 10:26:17.588366\n",
      "Requests elapsed:  228  at time: 2024-08-07 10:27:17.864322\n",
      "Requests elapsed:  229  at time: 2024-08-07 10:28:18.157998\n",
      "Requests elapsed:  230  at time: 2024-08-07 10:29:18.408070\n",
      "Requests elapsed:  231  at time: 2024-08-07 10:30:18.673583\n",
      "Requests elapsed:  232  at time: 2024-08-07 10:31:18.951873\n",
      "Requests elapsed:  233  at time: 2024-08-07 10:32:19.226204\n",
      "Requests elapsed:  234  at time: 2024-08-07 10:33:19.513387\n",
      "Requests elapsed:  235  at time: 2024-08-07 10:34:19.767532\n",
      "Requests elapsed:  236  at time: 2024-08-07 10:35:20.033597\n",
      "Requests elapsed:  237  at time: 2024-08-07 10:36:20.300289\n",
      "Requests elapsed:  238  at time: 2024-08-07 10:37:20.560379\n",
      "Requests elapsed:  239  at time: 2024-08-07 10:38:20.822946\n",
      "Requests elapsed:  240  at time: 2024-08-07 10:39:21.101798\n",
      "Requests elapsed:  241  at time: 2024-08-07 10:40:21.904205\n",
      "Requests elapsed:  242  at time: 2024-08-07 10:41:22.175768\n",
      "Requests elapsed:  243  at time: 2024-08-07 10:42:22.449857\n",
      "Requests elapsed:  244  at time: 2024-08-07 10:43:22.757566\n",
      "Requests elapsed:  245  at time: 2024-08-07 10:44:23.023095\n",
      "Requests elapsed:  246  at time: 2024-08-07 10:45:23.285771\n",
      "Requests elapsed:  247  at time: 2024-08-07 10:46:23.569338\n",
      "Requests elapsed:  248  at time: 2024-08-07 10:47:23.811556\n",
      "Requests elapsed:  249  at time: 2024-08-07 10:48:24.126654\n",
      "Requests elapsed:  250  at time: 2024-08-07 10:49:24.393556\n",
      "Requests elapsed:  251  at time: 2024-08-07 10:50:24.660449\n",
      "Requests elapsed:  252  at time: 2024-08-07 10:51:24.937893\n",
      "Requests elapsed:  253  at time: 2024-08-07 10:52:25.208470\n",
      "Requests elapsed:  254  at time: 2024-08-07 10:53:25.477637\n",
      "Requests elapsed:  255  at time: 2024-08-07 10:54:25.721782\n",
      "Requests elapsed:  256  at time: 2024-08-07 10:55:25.999231\n",
      "Requests elapsed:  257  at time: 2024-08-07 10:56:26.275441\n",
      "Requests elapsed:  258  at time: 2024-08-07 10:57:26.532283\n",
      "Requests elapsed:  259  at time: 2024-08-07 10:58:26.782650\n",
      "Requests elapsed:  260  at time: 2024-08-07 10:59:27.043208\n",
      "Requests elapsed:  261  at time: 2024-08-07 11:00:27.324505\n",
      "Requests elapsed:  262  at time: 2024-08-07 11:01:27.613203\n",
      "Requests elapsed:  263  at time: 2024-08-07 11:02:27.893090\n",
      "Requests elapsed:  264  at time: 2024-08-07 11:03:28.194280\n",
      "Requests elapsed:  265  at time: 2024-08-07 11:04:28.447581\n",
      "Requests elapsed:  266  at time: 2024-08-07 11:05:28.724216\n",
      "Requests elapsed:  267  at time: 2024-08-07 11:06:29.023549\n",
      "Requests elapsed:  268  at time: 2024-08-07 11:07:29.289348\n",
      "Requests elapsed:  269  at time: 2024-08-07 11:08:29.575716\n",
      "Requests elapsed:  270  at time: 2024-08-07 11:09:29.853990\n",
      "Requests elapsed:  271  at time: 2024-08-07 11:10:30.152272\n",
      "Requests elapsed:  272  at time: 2024-08-07 11:11:30.431050\n",
      "Requests elapsed:  273  at time: 2024-08-07 11:12:30.702789\n",
      "Requests elapsed:  274  at time: 2024-08-07 11:13:30.979088\n",
      "Requests elapsed:  275  at time: 2024-08-07 11:14:31.285102\n",
      "Requests elapsed:  276  at time: 2024-08-07 11:15:31.532741\n",
      "Requests elapsed:  277  at time: 2024-08-07 11:16:31.812698\n",
      "Requests elapsed:  278  at time: 2024-08-07 11:17:32.090591\n",
      "Requests elapsed:  279  at time: 2024-08-07 11:18:32.343041\n",
      "Requests elapsed:  280  at time: 2024-08-07 11:19:32.611356\n",
      "Requests elapsed:  281  at time: 2024-08-07 11:20:32.879180\n",
      "Requests elapsed:  282  at time: 2024-08-07 11:21:33.141691\n",
      "Requests elapsed:  283  at time: 2024-08-07 11:22:33.456348\n",
      "Requests elapsed:  284  at time: 2024-08-07 11:23:33.732266\n",
      "Requests elapsed:  285  at time: 2024-08-07 11:24:34.031139\n",
      "Requests elapsed:  286  at time: 2024-08-07 11:25:34.327590\n",
      "Requests elapsed:  287  at time: 2024-08-07 11:26:34.608359\n",
      "Requests elapsed:  288  at time: 2024-08-07 11:27:34.842176\n",
      "Requests elapsed:  289  at time: 2024-08-07 11:28:35.132454\n",
      "Requests elapsed:  290  at time: 2024-08-07 11:29:35.895950\n",
      "Requests elapsed:  291  at time: 2024-08-07 11:30:36.186260\n",
      "Requests elapsed:  292  at time: 2024-08-07 11:31:36.471595\n",
      "Requests elapsed:  293  at time: 2024-08-07 11:32:36.763729\n",
      "Requests elapsed:  294  at time: 2024-08-07 11:33:37.055604\n",
      "Requests elapsed:  295  at time: 2024-08-07 11:34:37.326885\n",
      "Requests elapsed:  296  at time: 2024-08-07 11:35:37.587047\n",
      "Requests elapsed:  297  at time: 2024-08-07 11:36:37.854438\n",
      "Requests elapsed:  298  at time: 2024-08-07 11:37:38.118251\n",
      "Requests elapsed:  299  at time: 2024-08-07 11:38:38.413687\n",
      "Requests elapsed:  300  at time: 2024-08-07 11:39:38.651338\n",
      "Requests elapsed:  301  at time: 2024-08-07 11:40:38.931402\n",
      "Requests elapsed:  302  at time: 2024-08-07 11:41:39.202405\n",
      "Requests elapsed:  303  at time: 2024-08-07 11:42:39.501366\n",
      "Requests elapsed:  304  at time: 2024-08-07 11:43:39.755355\n",
      "Requests elapsed:  305  at time: 2024-08-07 11:44:39.996685\n",
      "Requests elapsed:  306  at time: 2024-08-07 11:45:40.258701\n",
      "Requests elapsed:  307  at time: 2024-08-07 11:46:40.522780\n",
      "Requests elapsed:  308  at time: 2024-08-07 11:47:40.779468\n",
      "Requests elapsed:  309  at time: 2024-08-07 11:48:41.092652\n",
      "Requests elapsed:  310  at time: 2024-08-07 11:49:41.323907\n",
      "Requests elapsed:  311  at time: 2024-08-07 11:50:41.573486\n",
      "Requests elapsed:  312  at time: 2024-08-07 11:51:41.810042\n",
      "Requests elapsed:  313  at time: 2024-08-07 11:52:42.072192\n",
      "Requests elapsed:  314  at time: 2024-08-07 11:53:42.363609\n",
      "Requests elapsed:  315  at time: 2024-08-07 11:54:42.591947\n",
      "Requests elapsed:  316  at time: 2024-08-07 11:55:42.910926\n",
      "Requests elapsed:  317  at time: 2024-08-07 11:56:43.172057\n",
      "Requests elapsed:  318  at time: 2024-08-07 11:57:43.447092\n",
      "Requests elapsed:  319  at time: 2024-08-07 11:58:43.712232\n",
      "Requests elapsed:  320  at time: 2024-08-07 11:59:43.946435\n",
      "Requests elapsed:  321  at time: 2024-08-07 12:00:44.213379\n",
      "Requests elapsed:  322  at time: 2024-08-07 12:01:44.472134\n",
      "Requests elapsed:  323  at time: 2024-08-07 12:02:44.740733\n",
      "Requests elapsed:  324  at time: 2024-08-07 12:03:45.011275\n",
      "Requests elapsed:  325  at time: 2024-08-07 12:04:45.319551\n",
      "Requests elapsed:  326  at time: 2024-08-07 12:05:45.580762\n",
      "Requests elapsed:  327  at time: 2024-08-07 12:06:45.835645\n",
      "Requests elapsed:  328  at time: 2024-08-07 12:07:46.108384\n",
      "Requests elapsed:  329  at time: 2024-08-07 12:08:46.351551\n",
      "Requests elapsed:  330  at time: 2024-08-07 12:09:46.603415\n",
      "Requests elapsed:  331  at time: 2024-08-07 12:10:46.889523\n",
      "Requests elapsed:  332  at time: 2024-08-07 12:11:47.209725\n",
      "Requests elapsed:  333  at time: 2024-08-07 12:12:47.482583\n",
      "Requests elapsed:  334  at time: 2024-08-07 12:13:47.750711\n",
      "Requests elapsed:  335  at time: 2024-08-07 12:14:48.011373\n",
      "Requests elapsed:  336  at time: 2024-08-07 12:15:48.309420\n",
      "Requests elapsed:  337  at time: 2024-08-07 12:16:48.557869\n",
      "Requests elapsed:  338  at time: 2024-08-07 12:17:48.830313\n",
      "Requests elapsed:  339  at time: 2024-08-07 12:18:49.086856\n",
      "Requests elapsed:  340  at time: 2024-08-07 12:19:49.334216\n",
      "Requests elapsed:  341  at time: 2024-08-07 12:20:49.595596\n",
      "Requests elapsed:  342  at time: 2024-08-07 12:21:49.871618\n",
      "Requests elapsed:  343  at time: 2024-08-07 12:22:50.110759\n",
      "Requests elapsed:  344  at time: 2024-08-07 12:23:50.397339\n",
      "Requests elapsed:  345  at time: 2024-08-07 12:24:50.651761\n",
      "Requests elapsed:  346  at time: 2024-08-07 12:25:50.923656\n",
      "Requests elapsed:  347  at time: 2024-08-07 12:26:51.185789\n",
      "Requests elapsed:  348  at time: 2024-08-07 12:27:51.461635\n",
      "Requests elapsed:  349  at time: 2024-08-07 12:28:51.780268\n",
      "Requests elapsed:  350  at time: 2024-08-07 12:29:52.065177\n",
      "Requests elapsed:  351  at time: 2024-08-07 12:30:52.328754\n",
      "Requests elapsed:  352  at time: 2024-08-07 12:31:52.588656\n",
      "Requests elapsed:  353  at time: 2024-08-07 12:32:52.868658\n",
      "Requests elapsed:  354  at time: 2024-08-07 12:33:53.122446\n",
      "Requests elapsed:  355  at time: 2024-08-07 12:34:53.377742\n",
      "Requests elapsed:  356  at time: 2024-08-07 12:35:53.656464\n",
      "Requests elapsed:  357  at time: 2024-08-07 12:36:53.923777\n",
      "Requests elapsed:  358  at time: 2024-08-07 12:37:54.239525\n",
      "Requests elapsed:  359  at time: 2024-08-07 12:38:54.496223\n",
      "Requests elapsed:  360  at time: 2024-08-07 12:39:54.753915\n",
      "Requests elapsed:  361  at time: 2024-08-07 12:40:55.018151\n",
      "Requests elapsed:  362  at time: 2024-08-07 12:41:55.252623\n",
      "Requests elapsed:  363  at time: 2024-08-07 12:42:55.519339\n",
      "Requests elapsed:  364  at time: 2024-08-07 12:43:55.782234\n",
      "Requests elapsed:  365  at time: 2024-08-07 12:44:57.034333\n",
      "Requests elapsed:  366  at time: 2024-08-07 12:45:57.296060\n",
      "Requests elapsed:  367  at time: 2024-08-07 12:46:57.725675\n",
      "Requests elapsed:  368  at time: 2024-08-07 12:47:58.019272\n",
      "Requests elapsed:  369  at time: 2024-08-07 12:48:58.284579\n",
      "Requests elapsed:  370  at time: 2024-08-07 12:49:58.563384\n",
      "Requests elapsed:  371  at time: 2024-08-07 12:50:58.831293\n",
      "Requests elapsed:  372  at time: 2024-08-07 12:51:59.066329\n",
      "Requests elapsed:  373  at time: 2024-08-07 12:52:59.306093\n",
      "Requests elapsed:  374  at time: 2024-08-07 12:53:59.583790\n",
      "Requests elapsed:  375  at time: 2024-08-07 12:54:59.867846\n",
      "Requests elapsed:  376  at time: 2024-08-07 12:56:00.114479\n",
      "Requests elapsed:  377  at time: 2024-08-07 12:57:00.382460\n",
      "Requests elapsed:  378  at time: 2024-08-07 12:58:00.654043\n",
      "Requests elapsed:  379  at time: 2024-08-07 12:59:00.931084\n",
      "Requests elapsed:  380  at time: 2024-08-07 13:00:01.228293\n",
      "Requests elapsed:  381  at time: 2024-08-07 13:01:01.499006\n",
      "Requests elapsed:  382  at time: 2024-08-07 13:02:01.788879\n",
      "Requests elapsed:  383  at time: 2024-08-07 13:03:02.095361\n",
      "Requests elapsed:  384  at time: 2024-08-07 13:04:02.370178\n",
      "Requests elapsed:  385  at time: 2024-08-07 13:05:02.689916\n",
      "Requests elapsed:  386  at time: 2024-08-07 13:06:02.990164\n",
      "Requests elapsed:  387  at time: 2024-08-07 13:07:03.280982\n",
      "Requests elapsed:  388  at time: 2024-08-07 13:08:03.583904\n",
      "Requests elapsed:  389  at time: 2024-08-07 13:09:03.882943\n",
      "Requests elapsed:  390  at time: 2024-08-07 13:10:04.124270\n",
      "Program completed after 390 requests.\n"
     ]
    }
   ],
   "source": [
    "\n",
    "\n",
    "# Twelve Data API parameters\n",
    "symbol = \"NVDA\"\n",
    "interval = \"1min\"\n",
    "outputsize = 5000 \n",
    "\n",
    "# Initialize a counter for the number of requests\n",
    "request_count = 0\n",
    "\n",
    "while request_count < 390:\n",
    "    # Fetch time series data and indicators\n",
    "    price_pdf = td.price(\n",
    "        symbol=symbol\n",
    "    )\n",
    "    # Convert to pandas Dataframes\n",
    "    price_json = price_pdf.as_json()\n",
    "    price_df = pd.DataFrame(price_json, index=[\"price\"])\n",
    "\n",
    "    # Prepare for database insertion\n",
    "    time_series_data = []\n",
    "\n",
    "    # Process and align data\n",
    "    for index, row in price_df.iterrows():\n",
    "        # Generate the current datetime string\n",
    "        datetime_str = datetime.now().strftime(\"%Y-%m-%d %H:%M:%S\")\n",
    "\n",
    "        time_series_data.append(\n",
    "            (\n",
    "                symbol,\n",
    "                datetime_str,\n",
    "                row[\"price\"]\n",
    "            )\n",
    "        )\n",
    "\n",
    "    # Insert tick data into MySQL\n",
    "    sql_time_series = \"\"\"\n",
    "    INSERT INTO nvda_new (symbol, datetime, price)\n",
    "    VALUES (%s, %s, %s)\n",
    "    \"\"\"\n",
    "    mycursor.executemany(sql_time_series, time_series_data)\n",
    "    mydb.commit()\n",
    "\n",
    "    # Increment the request counter\n",
    "    request_count += 1\n",
    "    print(\"Requests elapsed: \", request_count, \" at time:\", datetime.now())\n",
    "    # Sleep for a short period before fetching the next data\n",
    "    time.sleep(60)  # Adjust the sleep time as needed\n",
    "\n",
    "print(\"Program completed after 390 requests.\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.12.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}