Hisorical_Data_Download of stocks.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Historical Data Download Code for any stock of Stock Market"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This code will download historical data of any stocks or multiple stocks in csv "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " \n",
      " \n",
      "  \t  \t \t  WELCOME ! DATA_DOWNLOAD PROGRAM - ZERODHA ! \n",
      "\n",
      "\n",
      " \t  \t \t  Please wait while we are installing library\n",
      " \n",
      " \n",
      "ENTER full link generated in URL :- https://kite.trade/?request_token=dGHSMlipgeR3kOKa3bPm9T4i8uG9pHIA&action=login&status=success\n",
      " \n",
      " \n",
      " \n",
      " \n",
      " \n",
      " \n",
      "Enter Symbols manually or full_list ? 'YES' for Manually and 'NO' to Pass Full_list :=yes\n",
      "\n",
      "\n",
      "ENTER SYMBOL''S ex:-'sunpharma,sbin':=SBIN\n",
      "ENTER EXCHANGE ex:-'NSE':=NSE\n",
      "ENTER TIME_FRAME of Data ex:-'5minute \n",
      "minute \\day etc' :=5minute\n",
      " \n",
      " \n",
      "DO you want to change Date? 'NO'for Default and'YES'to change date:=no\n",
      " \n",
      " \n",
      "Is All above Entered inputs are TRUE ? 'YES' to continute or 'NO' to enter again ? yes\n",
      " \n",
      " \n",
      "Processing.....\n",
      "Processing.....\n",
      "\n",
      "\n",
      "Download Complete\n"
     ]
    }
   ],
   "source": [
    "print(\" \\n \")\n",
    "print(\"  \\t  \\t \\t  WELCOME ! DATA_DOWNLOAD PROGRAM - ZERODHA ! \") \n",
    "print(\"\\n\")\n",
    "print(\" \\t  \\t \\t  Please wait while we are installing library\")\n",
    "\n",
    "import time\n",
    "import webbrowser\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from kiteconnect import KiteTicker \n",
    "from kiteconnect import KiteConnect\n",
    "\n",
    "# login to zerodha \n",
    "\n",
    "api_key='******************* @@enter your api key here@@@**************' \n",
    "api_secret='**********************@@enter your api key here****************'\n",
    "print(KiteConnect(api_key,api_secret).login_url())\n",
    "\n",
    "print(\" \\n \")\n",
    "\n",
    "kite = KiteConnect(api_key=api_key)\n",
    "data = kite.generate_session(((str(input(\"ENTER full link generated in URL :- \")).split(\"request_token=\")[1]).split(\"&action\"))[0],api_secret)\n",
    "kite.set_access_token(data[\"access_token\"])\n",
    "print(\" \\n \")\n",
    "print(\" \\n \")\n",
    "\n",
    "#  inputs \n",
    "\n",
    "while(True):\n",
    "    print(\" \\n \")\n",
    "    while(True):\n",
    "        zde=str(input(\"Enter Symbols manually or full_list ? 'YES' for Manually and 'NO' to Pass Full_list :=\")).upper()\n",
    "        if zde:\n",
    "            if \"YES\"==zde:\n",
    "                break\n",
    "            if \"NO\" in zde:\n",
    "                break\n",
    "    print(\"\\n\")\n",
    "    if \"YES\" in zde:\n",
    "        while(True):\n",
    "            k=str(input(\"ENTER SYMBOL''S ex:-'sunpharma,sbin':=\")).upper()\n",
    "            if k:\n",
    "                z=k.split(',')\n",
    "                break\n",
    "    if \"NO\" in zde:\n",
    "        while(True):\n",
    "            a=input( \"ENTER FULL LIST OF SYMBOL's ex:-'sunpharma,sbin,adani,ongc':=\").upper()\n",
    "            if a:\n",
    "                z=a.split(',')\n",
    "                break\n",
    "    while(True):\n",
    "        eexchange=str(input(\"ENTER EXCHANGE ex:-'NSE':=\")).upper()\n",
    "        if eexchange:\n",
    "            break\n",
    "    while(True):\n",
    "        time_frame=str(input(\"ENTER TIME_FRAME of Data ex:-'5minute \\15minute \\day etc' :=\")).lower()\n",
    "        if time_frame:\n",
    "            break\n",
    "    while(True):\n",
    "        print(\" \\n \")\n",
    "        zd=str(input(\"DO you want to change Date? 'NO'for Default and'YES'to change date:=\")).upper()\n",
    "        if zd:\n",
    "            if \"YES\"==zd:\n",
    "                break\n",
    "            if \"NO\"==zd:\n",
    "                break\n",
    "    if \"YES\" in zd:\n",
    "        while(True):\n",
    "            sdate =str(input(\"Starting Date in formatof '2019-07-23' :=\")).lower()\n",
    "            if sdate:\n",
    "                break\n",
    "        while(True):\n",
    "            todate =str(input(\"Ending Date in format of '2019-10-23' :=\")).lower()\n",
    "            if todate:\n",
    "                break\n",
    "    if \"NO\" in zd:\n",
    "        sdate =\"2019-07-23\"\n",
    "        todate=\"2019-10-23\"\n",
    "    print(\" \\n \")\n",
    "    while(True):\n",
    "        st=str(input(\"Is All above Entered inputs are TRUE ? 'YES' to continute or 'NO' to enter again ? \")).upper()\n",
    "        if st:\n",
    "            if \"YES\"==st:\n",
    "                break\n",
    "            else:\n",
    "                pass\n",
    "    if \"YES\"==st:\n",
    "                break\n",
    "tokenall=[]\n",
    "symbl=[]\n",
    "aa=0\n",
    "print(\" \\n \")\n",
    "print(\"Processing.....\")\n",
    "\n",
    "while(True):\n",
    "    ttoken=int(pd.DataFrame(kite.ltp(eexchange+\":\"+z[aa])).iloc[-2,0])\n",
    "    tokenall.append(ttoken) # fetching tokens\n",
    "    symbl.append(z[aa])\n",
    "    aa=aa+1\n",
    "    if aa==len(z):\n",
    "        break\n",
    "        \n",
    "print(\"Processing.....\")        \n",
    "ee=0\n",
    "\n",
    "# downloading data\n",
    "\n",
    "while(True):\n",
    "    dff=kite.historical_data(tokenall[ee],sdate,todate,time_frame,0)\n",
    "    time.sleep(1)\n",
    "    dfw=pd.DataFrame(dff)\n",
    "    s=f\"{ symbl[ee]}.csv\" # writing to csv\n",
    "    dfw.to_csv(s)\n",
    "    ee=ee+1\n",
    "    if ee==len(z):\n",
    "        print(\"\\n\")\n",
    "        print(\"Download Complete\")\n",
    "        break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-07-23 09:15:00+05:30</td>\n",
       "      <td>351.20</td>\n",
       "      <td>352.85</td>\n",
       "      <td>350.55</td>\n",
       "      <td>350.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019-07-23 09:20:00+05:30</td>\n",
       "      <td>350.80</td>\n",
       "      <td>350.80</td>\n",
       "      <td>348.95</td>\n",
       "      <td>349.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-07-23 09:25:00+05:30</td>\n",
       "      <td>349.00</td>\n",
       "      <td>350.00</td>\n",
       "      <td>348.80</td>\n",
       "      <td>349.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-07-23 09:30:00+05:30</td>\n",
       "      <td>349.10</td>\n",
       "      <td>349.20</td>\n",
       "      <td>347.80</td>\n",
       "      <td>348.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-07-23 09:35:00+05:30</td>\n",
       "      <td>348.15</td>\n",
       "      <td>348.25</td>\n",
       "      <td>347.50</td>\n",
       "      <td>347.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2019-07-23 09:40:00+05:30</td>\n",
       "      <td>347.80</td>\n",
       "      <td>348.30</td>\n",
       "      <td>347.50</td>\n",
       "      <td>347.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2019-07-23 09:45:00+05:30</td>\n",
       "      <td>347.50</td>\n",
       "      <td>349.00</td>\n",
       "      <td>347.50</td>\n",
       "      <td>348.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2019-07-23 09:50:00+05:30</td>\n",
       "      <td>348.95</td>\n",
       "      <td>350.00</td>\n",
       "      <td>348.85</td>\n",
       "      <td>349.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2019-07-23 09:55:00+05:30</td>\n",
       "      <td>349.30</td>\n",
       "      <td>350.30</td>\n",
       "      <td>349.05</td>\n",
       "      <td>349.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2019-07-23 10:00:00+05:30</td>\n",
       "      <td>349.85</td>\n",
       "      <td>350.15</td>\n",
       "      <td>349.10</td>\n",
       "      <td>349.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2019-07-23 10:05:00+05:30</td>\n",
       "      <td>349.10</td>\n",
       "      <td>349.10</td>\n",
       "      <td>348.30</td>\n",
       "      <td>348.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2019-07-23 10:10:00+05:30</td>\n",
       "      <td>348.75</td>\n",
       "      <td>349.80</td>\n",
       "      <td>348.70</td>\n",
       "      <td>349.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2019-07-23 10:15:00+05:30</td>\n",
       "      <td>349.70</td>\n",
       "      <td>350.00</td>\n",
       "      <td>349.10</td>\n",
       "      <td>349.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2019-07-23 10:20:00+05:30</td>\n",
       "      <td>349.20</td>\n",
       "      <td>349.40</td>\n",
       "      <td>348.70</td>\n",
       "      <td>349.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2019-07-23 10:25:00+05:30</td>\n",
       "      <td>349.00</td>\n",
       "      <td>349.35</td>\n",
       "      <td>348.85</td>\n",
       "      <td>349.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2019-07-23 10:30:00+05:30</td>\n",
       "      <td>349.15</td>\n",
       "      <td>349.20</td>\n",
       "      <td>348.85</td>\n",
       "      <td>349.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2019-07-23 10:35:00+05:30</td>\n",
       "      <td>349.05</td>\n",
       "      <td>349.50</td>\n",
       "      <td>348.90</td>\n",
       "      <td>349.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2019-07-23 10:40:00+05:30</td>\n",
       "      <td>349.40</td>\n",
       "      <td>349.95</td>\n",
       "      <td>349.25</td>\n",
       "      <td>349.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2019-07-23 10:45:00+05:30</td>\n",
       "      <td>349.90</td>\n",
       "      <td>350.80</td>\n",
       "      <td>349.65</td>\n",
       "      <td>350.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2019-07-23 10:50:00+05:30</td>\n",
       "      <td>350.45</td>\n",
       "      <td>350.45</td>\n",
       "      <td>349.75</td>\n",
       "      <td>349.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2019-07-23 10:55:00+05:30</td>\n",
       "      <td>349.80</td>\n",
       "      <td>349.85</td>\n",
       "      <td>349.40</td>\n",
       "      <td>349.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2019-07-23 11:00:00+05:30</td>\n",
       "      <td>349.70</td>\n",
       "      <td>349.80</td>\n",
       "      <td>349.10</td>\n",
       "      <td>349.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2019-07-23 11:05:00+05:30</td>\n",
       "      <td>349.20</td>\n",
       "      <td>349.30</td>\n",
       "      <td>348.60</td>\n",
       "      <td>348.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2019-07-23 11:10:00+05:30</td>\n",
       "      <td>348.60</td>\n",
       "      <td>349.00</td>\n",
       "      <td>348.55</td>\n",
       "      <td>348.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2019-07-23 11:15:00+05:30</td>\n",
       "      <td>348.80</td>\n",
       "      <td>349.30</td>\n",
       "      <td>348.60</td>\n",
       "      <td>349.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2019-07-23 11:20:00+05:30</td>\n",
       "      <td>349.15</td>\n",
       "      <td>349.85</td>\n",
       "      <td>348.80</td>\n",
       "      <td>349.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2019-07-23 11:25:00+05:30</td>\n",
       "      <td>349.75</td>\n",
       "      <td>349.80</td>\n",
       "      <td>349.25</td>\n",
       "      <td>349.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2019-07-23 11:30:00+05:30</td>\n",
       "      <td>349.25</td>\n",
       "      <td>349.30</td>\n",
       "      <td>348.60</td>\n",
       "      <td>348.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2019-07-23 11:35:00+05:30</td>\n",
       "      <td>348.65</td>\n",
       "      <td>349.10</td>\n",
       "      <td>348.05</td>\n",
       "      <td>348.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2019-07-23 11:40:00+05:30</td>\n",
       "      <td>348.10</td>\n",
       "      <td>348.35</td>\n",
       "      <td>347.80</td>\n",
       "      <td>348.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>2019-08-30 13:00:00+05:30</td>\n",
       "      <td>267.50</td>\n",
       "      <td>268.30</td>\n",
       "      <td>267.50</td>\n",
       "      <td>268.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>2019-08-30 13:05:00+05:30</td>\n",
       "      <td>268.15</td>\n",
       "      <td>269.10</td>\n",
       "      <td>267.70</td>\n",
       "      <td>268.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>2019-08-30 13:10:00+05:30</td>\n",
       "      <td>268.70</td>\n",
       "      <td>269.40</td>\n",
       "      <td>268.30</td>\n",
       "      <td>268.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>2019-08-30 13:15:00+05:30</td>\n",
       "      <td>268.50</td>\n",
       "      <td>269.30</td>\n",
       "      <td>268.40</td>\n",
       "      <td>268.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>2019-08-30 13:20:00+05:30</td>\n",
       "      <td>268.50</td>\n",
       "      <td>268.70</td>\n",
       "      <td>267.60</td>\n",
       "      <td>268.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000</th>\n",
       "      <td>2019-08-30 13:25:00+05:30</td>\n",
       "      <td>268.10</td>\n",
       "      <td>268.40</td>\n",
       "      <td>267.70</td>\n",
       "      <td>268.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001</th>\n",
       "      <td>2019-08-30 13:30:00+05:30</td>\n",
       "      <td>268.20</td>\n",
       "      <td>268.40</td>\n",
       "      <td>267.80</td>\n",
       "      <td>268.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2002</th>\n",
       "      <td>2019-08-30 13:35:00+05:30</td>\n",
       "      <td>268.10</td>\n",
       "      <td>268.85</td>\n",
       "      <td>268.10</td>\n",
       "      <td>268.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>2019-08-30 13:40:00+05:30</td>\n",
       "      <td>268.50</td>\n",
       "      <td>269.35</td>\n",
       "      <td>268.50</td>\n",
       "      <td>269.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004</th>\n",
       "      <td>2019-08-30 13:45:00+05:30</td>\n",
       "      <td>269.25</td>\n",
       "      <td>270.00</td>\n",
       "      <td>269.00</td>\n",
       "      <td>269.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2005</th>\n",
       "      <td>2019-08-30 13:50:00+05:30</td>\n",
       "      <td>269.80</td>\n",
       "      <td>270.80</td>\n",
       "      <td>269.80</td>\n",
       "      <td>270.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>2019-08-30 13:55:00+05:30</td>\n",
       "      <td>270.30</td>\n",
       "      <td>270.35</td>\n",
       "      <td>268.80</td>\n",
       "      <td>268.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>2019-08-30 14:00:00+05:30</td>\n",
       "      <td>268.90</td>\n",
       "      <td>270.00</td>\n",
       "      <td>268.65</td>\n",
       "      <td>269.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>2019-08-30 14:05:00+05:30</td>\n",
       "      <td>269.95</td>\n",
       "      <td>270.20</td>\n",
       "      <td>269.60</td>\n",
       "      <td>269.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>2019-08-30 14:10:00+05:30</td>\n",
       "      <td>269.80</td>\n",
       "      <td>270.05</td>\n",
       "      <td>269.50</td>\n",
       "      <td>269.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>2019-08-30 14:15:00+05:30</td>\n",
       "      <td>269.50</td>\n",
       "      <td>269.55</td>\n",
       "      <td>268.85</td>\n",
       "      <td>269.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>2019-08-30 14:20:00+05:30</td>\n",
       "      <td>269.40</td>\n",
       "      <td>269.65</td>\n",
       "      <td>268.85</td>\n",
       "      <td>269.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>2019-08-30 14:25:00+05:30</td>\n",
       "      <td>269.30</td>\n",
       "      <td>270.25</td>\n",
       "      <td>269.15</td>\n",
       "      <td>270.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>2019-08-30 14:30:00+05:30</td>\n",
       "      <td>270.15</td>\n",
       "      <td>270.55</td>\n",
       "      <td>270.05</td>\n",
       "      <td>270.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>2019-08-30 14:35:00+05:30</td>\n",
       "      <td>270.20</td>\n",
       "      <td>270.40</td>\n",
       "      <td>269.05</td>\n",
       "      <td>269.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>2019-08-30 14:40:00+05:30</td>\n",
       "      <td>269.40</td>\n",
       "      <td>270.30</td>\n",
       "      <td>269.40</td>\n",
       "      <td>270.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016</th>\n",
       "      <td>2019-08-30 14:45:00+05:30</td>\n",
       "      <td>270.10</td>\n",
       "      <td>270.95</td>\n",
       "      <td>270.10</td>\n",
       "      <td>270.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017</th>\n",
       "      <td>2019-08-30 14:50:00+05:30</td>\n",
       "      <td>270.90</td>\n",
       "      <td>271.75</td>\n",
       "      <td>270.85</td>\n",
       "      <td>271.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018</th>\n",
       "      <td>2019-08-30 14:55:00+05:30</td>\n",
       "      <td>271.60</td>\n",
       "      <td>272.45</td>\n",
       "      <td>271.40</td>\n",
       "      <td>272.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019</th>\n",
       "      <td>2019-08-30 15:00:00+05:30</td>\n",
       "      <td>272.45</td>\n",
       "      <td>273.80</td>\n",
       "      <td>272.35</td>\n",
       "      <td>272.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020</th>\n",
       "      <td>2019-08-30 15:05:00+05:30</td>\n",
       "      <td>272.95</td>\n",
       "      <td>273.95</td>\n",
       "      <td>272.45</td>\n",
       "      <td>273.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021</th>\n",
       "      <td>2019-08-30 15:10:00+05:30</td>\n",
       "      <td>273.85</td>\n",
       "      <td>274.50</td>\n",
       "      <td>273.65</td>\n",
       "      <td>273.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022</th>\n",
       "      <td>2019-08-30 15:15:00+05:30</td>\n",
       "      <td>273.95</td>\n",
       "      <td>274.40</td>\n",
       "      <td>273.75</td>\n",
       "      <td>274.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023</th>\n",
       "      <td>2019-08-30 15:20:00+05:30</td>\n",
       "      <td>274.35</td>\n",
       "      <td>274.60</td>\n",
       "      <td>273.85</td>\n",
       "      <td>274.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024</th>\n",
       "      <td>2019-08-30 15:25:00+05:30</td>\n",
       "      <td>274.20</td>\n",
       "      <td>274.25</td>\n",
       "      <td>273.00</td>\n",
       "      <td>273.50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2025 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           date    open    high     low   close\n",
       "0     2019-07-23 09:15:00+05:30  351.20  352.85  350.55  350.70\n",
       "1     2019-07-23 09:20:00+05:30  350.80  350.80  348.95  349.05\n",
       "2     2019-07-23 09:25:00+05:30  349.00  350.00  348.80  349.20\n",
       "3     2019-07-23 09:30:00+05:30  349.10  349.20  347.80  348.20\n",
       "4     2019-07-23 09:35:00+05:30  348.15  348.25  347.50  347.85\n",
       "5     2019-07-23 09:40:00+05:30  347.80  348.30  347.50  347.50\n",
       "6     2019-07-23 09:45:00+05:30  347.50  349.00  347.50  348.90\n",
       "7     2019-07-23 09:50:00+05:30  348.95  350.00  348.85  349.30\n",
       "8     2019-07-23 09:55:00+05:30  349.30  350.30  349.05  349.85\n",
       "9     2019-07-23 10:00:00+05:30  349.85  350.15  349.10  349.10\n",
       "10    2019-07-23 10:05:00+05:30  349.10  349.10  348.30  348.75\n",
       "11    2019-07-23 10:10:00+05:30  348.75  349.80  348.70  349.80\n",
       "12    2019-07-23 10:15:00+05:30  349.70  350.00  349.10  349.20\n",
       "13    2019-07-23 10:20:00+05:30  349.20  349.40  348.70  349.05\n",
       "14    2019-07-23 10:25:00+05:30  349.00  349.35  348.85  349.00\n",
       "15    2019-07-23 10:30:00+05:30  349.15  349.20  348.85  349.05\n",
       "16    2019-07-23 10:35:00+05:30  349.05  349.50  348.90  349.40\n",
       "17    2019-07-23 10:40:00+05:30  349.40  349.95  349.25  349.85\n",
       "18    2019-07-23 10:45:00+05:30  349.90  350.80  349.65  350.45\n",
       "19    2019-07-23 10:50:00+05:30  350.45  350.45  349.75  349.85\n",
       "20    2019-07-23 10:55:00+05:30  349.80  349.85  349.40  349.70\n",
       "21    2019-07-23 11:00:00+05:30  349.70  349.80  349.10  349.30\n",
       "22    2019-07-23 11:05:00+05:30  349.20  349.30  348.60  348.60\n",
       "23    2019-07-23 11:10:00+05:30  348.60  349.00  348.55  348.80\n",
       "24    2019-07-23 11:15:00+05:30  348.80  349.30  348.60  349.15\n",
       "25    2019-07-23 11:20:00+05:30  349.15  349.85  348.80  349.75\n",
       "26    2019-07-23 11:25:00+05:30  349.75  349.80  349.25  349.30\n",
       "27    2019-07-23 11:30:00+05:30  349.25  349.30  348.60  348.60\n",
       "28    2019-07-23 11:35:00+05:30  348.65  349.10  348.05  348.10\n",
       "29    2019-07-23 11:40:00+05:30  348.10  348.35  347.80  348.10\n",
       "...                         ...     ...     ...     ...     ...\n",
       "1995  2019-08-30 13:00:00+05:30  267.50  268.30  267.50  268.10\n",
       "1996  2019-08-30 13:05:00+05:30  268.15  269.10  267.70  268.70\n",
       "1997  2019-08-30 13:10:00+05:30  268.70  269.40  268.30  268.50\n",
       "1998  2019-08-30 13:15:00+05:30  268.50  269.30  268.40  268.50\n",
       "1999  2019-08-30 13:20:00+05:30  268.50  268.70  267.60  268.05\n",
       "2000  2019-08-30 13:25:00+05:30  268.10  268.40  267.70  268.30\n",
       "2001  2019-08-30 13:30:00+05:30  268.20  268.40  267.80  268.15\n",
       "2002  2019-08-30 13:35:00+05:30  268.10  268.85  268.10  268.35\n",
       "2003  2019-08-30 13:40:00+05:30  268.50  269.35  268.50  269.15\n",
       "2004  2019-08-30 13:45:00+05:30  269.25  270.00  269.00  269.90\n",
       "2005  2019-08-30 13:50:00+05:30  269.80  270.80  269.80  270.35\n",
       "2006  2019-08-30 13:55:00+05:30  270.30  270.35  268.80  268.90\n",
       "2007  2019-08-30 14:00:00+05:30  268.90  270.00  268.65  269.90\n",
       "2008  2019-08-30 14:05:00+05:30  269.95  270.20  269.60  269.75\n",
       "2009  2019-08-30 14:10:00+05:30  269.80  270.05  269.50  269.50\n",
       "2010  2019-08-30 14:15:00+05:30  269.50  269.55  268.85  269.45\n",
       "2011  2019-08-30 14:20:00+05:30  269.40  269.65  268.85  269.25\n",
       "2012  2019-08-30 14:25:00+05:30  269.30  270.25  269.15  270.10\n",
       "2013  2019-08-30 14:30:00+05:30  270.15  270.55  270.05  270.10\n",
       "2014  2019-08-30 14:35:00+05:30  270.20  270.40  269.05  269.40\n",
       "2015  2019-08-30 14:40:00+05:30  269.40  270.30  269.40  270.10\n",
       "2016  2019-08-30 14:45:00+05:30  270.10  270.95  270.10  270.90\n",
       "2017  2019-08-30 14:50:00+05:30  270.90  271.75  270.85  271.55\n",
       "2018  2019-08-30 14:55:00+05:30  271.60  272.45  271.40  272.35\n",
       "2019  2019-08-30 15:00:00+05:30  272.45  273.80  272.35  272.85\n",
       "2020  2019-08-30 15:05:00+05:30  272.95  273.95  272.45  273.90\n",
       "2021  2019-08-30 15:10:00+05:30  273.85  274.50  273.65  273.90\n",
       "2022  2019-08-30 15:15:00+05:30  273.95  274.40  273.75  274.35\n",
       "2023  2019-08-30 15:20:00+05:30  274.35  274.60  273.85  274.15\n",
       "2024  2019-08-30 15:25:00+05:30  274.20  274.25  273.00  273.50\n",
       "\n",
       "[2025 rows x 5 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Downloaded Data\n",
    "\n",
    "new_file=pd.DataFrame(pd.read_csv(\"SBIN.csv\"))\n",
    "new_file[[\"date\",\"open\",\"high\",\"low\",\"close\"]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>close</th>\n",
       "      <th>date</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>open</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>350.70</td>\n",
       "      <td>2019-07-23 09:15:00+05:30</td>\n",
       "      <td>352.85</td>\n",
       "      <td>350.55</td>\n",
       "      <td>351.20</td>\n",
       "      <td>752547</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>349.05</td>\n",
       "      <td>2019-07-23 09:20:00+05:30</td>\n",
       "      <td>350.80</td>\n",
       "      <td>348.95</td>\n",
       "      <td>350.80</td>\n",
       "      <td>743751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>349.20</td>\n",
       "      <td>2019-07-23 09:25:00+05:30</td>\n",
       "      <td>350.00</td>\n",
       "      <td>348.80</td>\n",
       "      <td>349.00</td>\n",
       "      <td>594206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>348.20</td>\n",
       "      <td>2019-07-23 09:30:00+05:30</td>\n",
       "      <td>349.20</td>\n",
       "      <td>347.80</td>\n",
       "      <td>349.10</td>\n",
       "      <td>592144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>347.85</td>\n",
       "      <td>2019-07-23 09:35:00+05:30</td>\n",
       "      <td>348.25</td>\n",
       "      <td>347.50</td>\n",
       "      <td>348.15</td>\n",
       "      <td>503455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>347.50</td>\n",
       "      <td>2019-07-23 09:40:00+05:30</td>\n",
       "      <td>348.30</td>\n",
       "      <td>347.50</td>\n",
       "      <td>347.80</td>\n",
       "      <td>411564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>348.90</td>\n",
       "      <td>2019-07-23 09:45:00+05:30</td>\n",
       "      <td>349.00</td>\n",
       "      <td>347.50</td>\n",
       "      <td>347.50</td>\n",
       "      <td>384230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>349.30</td>\n",
       "      <td>2019-07-23 09:50:00+05:30</td>\n",
       "      <td>350.00</td>\n",
       "      <td>348.85</td>\n",
       "      <td>348.95</td>\n",
       "      <td>387064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>349.85</td>\n",
       "      <td>2019-07-23 09:55:00+05:30</td>\n",
       "      <td>350.30</td>\n",
       "      <td>349.05</td>\n",
       "      <td>349.30</td>\n",
       "      <td>337632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>349.10</td>\n",
       "      <td>2019-07-23 10:00:00+05:30</td>\n",
       "      <td>350.15</td>\n",
       "      <td>349.10</td>\n",
       "      <td>349.85</td>\n",
       "      <td>257093</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>348.75</td>\n",
       "      <td>2019-07-23 10:05:00+05:30</td>\n",
       "      <td>349.10</td>\n",
       "      <td>348.30</td>\n",
       "      <td>349.10</td>\n",
       "      <td>396477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>349.80</td>\n",
       "      <td>2019-07-23 10:10:00+05:30</td>\n",
       "      <td>349.80</td>\n",
       "      <td>348.70</td>\n",
       "      <td>348.75</td>\n",
       "      <td>226859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>349.20</td>\n",
       "      <td>2019-07-23 10:15:00+05:30</td>\n",
       "      <td>350.00</td>\n",
       "      <td>349.10</td>\n",
       "      <td>349.70</td>\n",
       "      <td>215059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>349.05</td>\n",
       "      <td>2019-07-23 10:20:00+05:30</td>\n",
       "      <td>349.40</td>\n",
       "      <td>348.70</td>\n",
       "      <td>349.20</td>\n",
       "      <td>207552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>349.00</td>\n",
       "      <td>2019-07-23 10:25:00+05:30</td>\n",
       "      <td>349.35</td>\n",
       "      <td>348.85</td>\n",
       "      <td>349.00</td>\n",
       "      <td>147200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>349.05</td>\n",
       "      <td>2019-07-23 10:30:00+05:30</td>\n",
       "      <td>349.20</td>\n",
       "      <td>348.85</td>\n",
       "      <td>349.15</td>\n",
       "      <td>148228</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>349.40</td>\n",
       "      <td>2019-07-23 10:35:00+05:30</td>\n",
       "      <td>349.50</td>\n",
       "      <td>348.90</td>\n",
       "      <td>349.05</td>\n",
       "      <td>100049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>349.85</td>\n",
       "      <td>2019-07-23 10:40:00+05:30</td>\n",
       "      <td>349.95</td>\n",
       "      <td>349.25</td>\n",
       "      <td>349.40</td>\n",
       "      <td>234573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>350.45</td>\n",
       "      <td>2019-07-23 10:45:00+05:30</td>\n",
       "      <td>350.80</td>\n",
       "      <td>349.65</td>\n",
       "      <td>349.90</td>\n",
       "      <td>294020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>349.85</td>\n",
       "      <td>2019-07-23 10:50:00+05:30</td>\n",
       "      <td>350.45</td>\n",
       "      <td>349.75</td>\n",
       "      <td>350.45</td>\n",
       "      <td>130359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>349.70</td>\n",
       "      <td>2019-07-23 10:55:00+05:30</td>\n",
       "      <td>349.85</td>\n",
       "      <td>349.40</td>\n",
       "      <td>349.80</td>\n",
       "      <td>208711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>349.30</td>\n",
       "      <td>2019-07-23 11:00:00+05:30</td>\n",
       "      <td>349.80</td>\n",
       "      <td>349.10</td>\n",
       "      <td>349.70</td>\n",
       "      <td>106642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>348.60</td>\n",
       "      <td>2019-07-23 11:05:00+05:30</td>\n",
       "      <td>349.30</td>\n",
       "      <td>348.60</td>\n",
       "      <td>349.20</td>\n",
       "      <td>273213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>348.80</td>\n",
       "      <td>2019-07-23 11:10:00+05:30</td>\n",
       "      <td>349.00</td>\n",
       "      <td>348.55</td>\n",
       "      <td>348.60</td>\n",
       "      <td>239866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>349.15</td>\n",
       "      <td>2019-07-23 11:15:00+05:30</td>\n",
       "      <td>349.30</td>\n",
       "      <td>348.60</td>\n",
       "      <td>348.80</td>\n",
       "      <td>182088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>349.75</td>\n",
       "      <td>2019-07-23 11:20:00+05:30</td>\n",
       "      <td>349.85</td>\n",
       "      <td>348.80</td>\n",
       "      <td>349.15</td>\n",
       "      <td>206997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>349.30</td>\n",
       "      <td>2019-07-23 11:25:00+05:30</td>\n",
       "      <td>349.80</td>\n",
       "      <td>349.25</td>\n",
       "      <td>349.75</td>\n",
       "      <td>242315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>348.60</td>\n",
       "      <td>2019-07-23 11:30:00+05:30</td>\n",
       "      <td>349.30</td>\n",
       "      <td>348.60</td>\n",
       "      <td>349.25</td>\n",
       "      <td>148363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>348.10</td>\n",
       "      <td>2019-07-23 11:35:00+05:30</td>\n",
       "      <td>349.10</td>\n",
       "      <td>348.05</td>\n",
       "      <td>348.65</td>\n",
       "      <td>215921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>348.10</td>\n",
       "      <td>2019-07-23 11:40:00+05:30</td>\n",
       "      <td>348.35</td>\n",
       "      <td>347.80</td>\n",
       "      <td>348.10</td>\n",
       "      <td>340481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1995</th>\n",
       "      <td>268.10</td>\n",
       "      <td>2019-08-30 13:00:00+05:30</td>\n",
       "      <td>268.30</td>\n",
       "      <td>267.50</td>\n",
       "      <td>267.50</td>\n",
       "      <td>409983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996</th>\n",
       "      <td>268.70</td>\n",
       "      <td>2019-08-30 13:05:00+05:30</td>\n",
       "      <td>269.10</td>\n",
       "      <td>267.70</td>\n",
       "      <td>268.15</td>\n",
       "      <td>548218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997</th>\n",
       "      <td>268.50</td>\n",
       "      <td>2019-08-30 13:10:00+05:30</td>\n",
       "      <td>269.40</td>\n",
       "      <td>268.30</td>\n",
       "      <td>268.70</td>\n",
       "      <td>564742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1998</th>\n",
       "      <td>268.50</td>\n",
       "      <td>2019-08-30 13:15:00+05:30</td>\n",
       "      <td>269.30</td>\n",
       "      <td>268.40</td>\n",
       "      <td>268.50</td>\n",
       "      <td>439667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999</th>\n",
       "      <td>268.05</td>\n",
       "      <td>2019-08-30 13:20:00+05:30</td>\n",
       "      <td>268.70</td>\n",
       "      <td>267.60</td>\n",
       "      <td>268.50</td>\n",
       "      <td>348325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000</th>\n",
       "      <td>268.30</td>\n",
       "      <td>2019-08-30 13:25:00+05:30</td>\n",
       "      <td>268.40</td>\n",
       "      <td>267.70</td>\n",
       "      <td>268.10</td>\n",
       "      <td>225214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001</th>\n",
       "      <td>268.15</td>\n",
       "      <td>2019-08-30 13:30:00+05:30</td>\n",
       "      <td>268.40</td>\n",
       "      <td>267.80</td>\n",
       "      <td>268.20</td>\n",
       "      <td>231371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2002</th>\n",
       "      <td>268.35</td>\n",
       "      <td>2019-08-30 13:35:00+05:30</td>\n",
       "      <td>268.85</td>\n",
       "      <td>268.10</td>\n",
       "      <td>268.10</td>\n",
       "      <td>398516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>269.15</td>\n",
       "      <td>2019-08-30 13:40:00+05:30</td>\n",
       "      <td>269.35</td>\n",
       "      <td>268.50</td>\n",
       "      <td>268.50</td>\n",
       "      <td>528277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004</th>\n",
       "      <td>269.90</td>\n",
       "      <td>2019-08-30 13:45:00+05:30</td>\n",
       "      <td>270.00</td>\n",
       "      <td>269.00</td>\n",
       "      <td>269.25</td>\n",
       "      <td>1166120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2005</th>\n",
       "      <td>270.35</td>\n",
       "      <td>2019-08-30 13:50:00+05:30</td>\n",
       "      <td>270.80</td>\n",
       "      <td>269.80</td>\n",
       "      <td>269.80</td>\n",
       "      <td>1218472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>268.90</td>\n",
       "      <td>2019-08-30 13:55:00+05:30</td>\n",
       "      <td>270.35</td>\n",
       "      <td>268.80</td>\n",
       "      <td>270.30</td>\n",
       "      <td>605796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>269.90</td>\n",
       "      <td>2019-08-30 14:00:00+05:30</td>\n",
       "      <td>270.00</td>\n",
       "      <td>268.65</td>\n",
       "      <td>268.90</td>\n",
       "      <td>608792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>269.75</td>\n",
       "      <td>2019-08-30 14:05:00+05:30</td>\n",
       "      <td>270.20</td>\n",
       "      <td>269.60</td>\n",
       "      <td>269.95</td>\n",
       "      <td>401145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>269.50</td>\n",
       "      <td>2019-08-30 14:10:00+05:30</td>\n",
       "      <td>270.05</td>\n",
       "      <td>269.50</td>\n",
       "      <td>269.80</td>\n",
       "      <td>492073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>269.45</td>\n",
       "      <td>2019-08-30 14:15:00+05:30</td>\n",
       "      <td>269.55</td>\n",
       "      <td>268.85</td>\n",
       "      <td>269.50</td>\n",
       "      <td>498125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>269.25</td>\n",
       "      <td>2019-08-30 14:20:00+05:30</td>\n",
       "      <td>269.65</td>\n",
       "      <td>268.85</td>\n",
       "      <td>269.40</td>\n",
       "      <td>302189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>270.10</td>\n",
       "      <td>2019-08-30 14:25:00+05:30</td>\n",
       "      <td>270.25</td>\n",
       "      <td>269.15</td>\n",
       "      <td>269.30</td>\n",
       "      <td>624969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>270.10</td>\n",
       "      <td>2019-08-30 14:30:00+05:30</td>\n",
       "      <td>270.55</td>\n",
       "      <td>270.05</td>\n",
       "      <td>270.15</td>\n",
       "      <td>605022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>269.40</td>\n",
       "      <td>2019-08-30 14:35:00+05:30</td>\n",
       "      <td>270.40</td>\n",
       "      <td>269.05</td>\n",
       "      <td>270.20</td>\n",
       "      <td>672557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>270.10</td>\n",
       "      <td>2019-08-30 14:40:00+05:30</td>\n",
       "      <td>270.30</td>\n",
       "      <td>269.40</td>\n",
       "      <td>269.40</td>\n",
       "      <td>441850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016</th>\n",
       "      <td>270.90</td>\n",
       "      <td>2019-08-30 14:45:00+05:30</td>\n",
       "      <td>270.95</td>\n",
       "      <td>270.10</td>\n",
       "      <td>270.10</td>\n",
       "      <td>646640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017</th>\n",
       "      <td>271.55</td>\n",
       "      <td>2019-08-30 14:50:00+05:30</td>\n",
       "      <td>271.75</td>\n",
       "      <td>270.85</td>\n",
       "      <td>270.90</td>\n",
       "      <td>960641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018</th>\n",
       "      <td>272.35</td>\n",
       "      <td>2019-08-30 14:55:00+05:30</td>\n",
       "      <td>272.45</td>\n",
       "      <td>271.40</td>\n",
       "      <td>271.60</td>\n",
       "      <td>805946</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019</th>\n",
       "      <td>272.85</td>\n",
       "      <td>2019-08-30 15:00:00+05:30</td>\n",
       "      <td>273.80</td>\n",
       "      <td>272.35</td>\n",
       "      <td>272.45</td>\n",
       "      <td>1830246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020</th>\n",
       "      <td>273.90</td>\n",
       "      <td>2019-08-30 15:05:00+05:30</td>\n",
       "      <td>273.95</td>\n",
       "      <td>272.45</td>\n",
       "      <td>272.95</td>\n",
       "      <td>1481904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021</th>\n",
       "      <td>273.90</td>\n",
       "      <td>2019-08-30 15:10:00+05:30</td>\n",
       "      <td>274.50</td>\n",
       "      <td>273.65</td>\n",
       "      <td>273.85</td>\n",
       "      <td>1642681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022</th>\n",
       "      <td>274.35</td>\n",
       "      <td>2019-08-30 15:15:00+05:30</td>\n",
       "      <td>274.40</td>\n",
       "      <td>273.75</td>\n",
       "      <td>273.95</td>\n",
       "      <td>1680898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023</th>\n",
       "      <td>274.15</td>\n",
       "      <td>2019-08-30 15:20:00+05:30</td>\n",
       "      <td>274.60</td>\n",
       "      <td>273.85</td>\n",
       "      <td>274.35</td>\n",
       "      <td>1607910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024</th>\n",
       "      <td>273.50</td>\n",
       "      <td>2019-08-30 15:25:00+05:30</td>\n",
       "      <td>274.25</td>\n",
       "      <td>273.00</td>\n",
       "      <td>274.20</td>\n",
       "      <td>591154</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2025 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       close                      date    high     low    open   volume\n",
       "0     350.70 2019-07-23 09:15:00+05:30  352.85  350.55  351.20   752547\n",
       "1     349.05 2019-07-23 09:20:00+05:30  350.80  348.95  350.80   743751\n",
       "2     349.20 2019-07-23 09:25:00+05:30  350.00  348.80  349.00   594206\n",
       "3     348.20 2019-07-23 09:30:00+05:30  349.20  347.80  349.10   592144\n",
       "4     347.85 2019-07-23 09:35:00+05:30  348.25  347.50  348.15   503455\n",
       "5     347.50 2019-07-23 09:40:00+05:30  348.30  347.50  347.80   411564\n",
       "6     348.90 2019-07-23 09:45:00+05:30  349.00  347.50  347.50   384230\n",
       "7     349.30 2019-07-23 09:50:00+05:30  350.00  348.85  348.95   387064\n",
       "8     349.85 2019-07-23 09:55:00+05:30  350.30  349.05  349.30   337632\n",
       "9     349.10 2019-07-23 10:00:00+05:30  350.15  349.10  349.85   257093\n",
       "10    348.75 2019-07-23 10:05:00+05:30  349.10  348.30  349.10   396477\n",
       "11    349.80 2019-07-23 10:10:00+05:30  349.80  348.70  348.75   226859\n",
       "12    349.20 2019-07-23 10:15:00+05:30  350.00  349.10  349.70   215059\n",
       "13    349.05 2019-07-23 10:20:00+05:30  349.40  348.70  349.20   207552\n",
       "14    349.00 2019-07-23 10:25:00+05:30  349.35  348.85  349.00   147200\n",
       "15    349.05 2019-07-23 10:30:00+05:30  349.20  348.85  349.15   148228\n",
       "16    349.40 2019-07-23 10:35:00+05:30  349.50  348.90  349.05   100049\n",
       "17    349.85 2019-07-23 10:40:00+05:30  349.95  349.25  349.40   234573\n",
       "18    350.45 2019-07-23 10:45:00+05:30  350.80  349.65  349.90   294020\n",
       "19    349.85 2019-07-23 10:50:00+05:30  350.45  349.75  350.45   130359\n",
       "20    349.70 2019-07-23 10:55:00+05:30  349.85  349.40  349.80   208711\n",
       "21    349.30 2019-07-23 11:00:00+05:30  349.80  349.10  349.70   106642\n",
       "22    348.60 2019-07-23 11:05:00+05:30  349.30  348.60  349.20   273213\n",
       "23    348.80 2019-07-23 11:10:00+05:30  349.00  348.55  348.60   239866\n",
       "24    349.15 2019-07-23 11:15:00+05:30  349.30  348.60  348.80   182088\n",
       "25    349.75 2019-07-23 11:20:00+05:30  349.85  348.80  349.15   206997\n",
       "26    349.30 2019-07-23 11:25:00+05:30  349.80  349.25  349.75   242315\n",
       "27    348.60 2019-07-23 11:30:00+05:30  349.30  348.60  349.25   148363\n",
       "28    348.10 2019-07-23 11:35:00+05:30  349.10  348.05  348.65   215921\n",
       "29    348.10 2019-07-23 11:40:00+05:30  348.35  347.80  348.10   340481\n",
       "...      ...                       ...     ...     ...     ...      ...\n",
       "1995  268.10 2019-08-30 13:00:00+05:30  268.30  267.50  267.50   409983\n",
       "1996  268.70 2019-08-30 13:05:00+05:30  269.10  267.70  268.15   548218\n",
       "1997  268.50 2019-08-30 13:10:00+05:30  269.40  268.30  268.70   564742\n",
       "1998  268.50 2019-08-30 13:15:00+05:30  269.30  268.40  268.50   439667\n",
       "1999  268.05 2019-08-30 13:20:00+05:30  268.70  267.60  268.50   348325\n",
       "2000  268.30 2019-08-30 13:25:00+05:30  268.40  267.70  268.10   225214\n",
       "2001  268.15 2019-08-30 13:30:00+05:30  268.40  267.80  268.20   231371\n",
       "2002  268.35 2019-08-30 13:35:00+05:30  268.85  268.10  268.10   398516\n",
       "2003  269.15 2019-08-30 13:40:00+05:30  269.35  268.50  268.50   528277\n",
       "2004  269.90 2019-08-30 13:45:00+05:30  270.00  269.00  269.25  1166120\n",
       "2005  270.35 2019-08-30 13:50:00+05:30  270.80  269.80  269.80  1218472\n",
       "2006  268.90 2019-08-30 13:55:00+05:30  270.35  268.80  270.30   605796\n",
       "2007  269.90 2019-08-30 14:00:00+05:30  270.00  268.65  268.90   608792\n",
       "2008  269.75 2019-08-30 14:05:00+05:30  270.20  269.60  269.95   401145\n",
       "2009  269.50 2019-08-30 14:10:00+05:30  270.05  269.50  269.80   492073\n",
       "2010  269.45 2019-08-30 14:15:00+05:30  269.55  268.85  269.50   498125\n",
       "2011  269.25 2019-08-30 14:20:00+05:30  269.65  268.85  269.40   302189\n",
       "2012  270.10 2019-08-30 14:25:00+05:30  270.25  269.15  269.30   624969\n",
       "2013  270.10 2019-08-30 14:30:00+05:30  270.55  270.05  270.15   605022\n",
       "2014  269.40 2019-08-30 14:35:00+05:30  270.40  269.05  270.20   672557\n",
       "2015  270.10 2019-08-30 14:40:00+05:30  270.30  269.40  269.40   441850\n",
       "2016  270.90 2019-08-30 14:45:00+05:30  270.95  270.10  270.10   646640\n",
       "2017  271.55 2019-08-30 14:50:00+05:30  271.75  270.85  270.90   960641\n",
       "2018  272.35 2019-08-30 14:55:00+05:30  272.45  271.40  271.60   805946\n",
       "2019  272.85 2019-08-30 15:00:00+05:30  273.80  272.35  272.45  1830246\n",
       "2020  273.90 2019-08-30 15:05:00+05:30  273.95  272.45  272.95  1481904\n",
       "2021  273.90 2019-08-30 15:10:00+05:30  274.50  273.65  273.85  1642681\n",
       "2022  274.35 2019-08-30 15:15:00+05:30  274.40  273.75  273.95  1680898\n",
       "2023  274.15 2019-08-30 15:20:00+05:30  274.60  273.85  274.35  1607910\n",
       "2024  273.50 2019-08-30 15:25:00+05:30  274.25  273.00  274.20   591154\n",
       "\n",
       "[2025 rows x 6 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(dfw) # data from exchange"
   ]
  }
 ],
 "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
## END