Hisorical_Data_Download_of_stocks.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "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"
    },
    "colab": {
      "name": "Hisorical_Data_Download of stocks.ipynb",
      "provenance": [],
      "include_colab_link": true
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/ashishkumar30/Zerodha_Live_Automate_Trading-_using_AI_ML_on_Indian_stock_market-using-basic-python/blob/master/Hisorical_Data_Download_of_stocks.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "RK2RqbqmNOAO",
        "colab_type": "text"
      },
      "source": [
        "# Historical Data Download Code for any stock of Stock Market"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "33L1lQO3NOAU",
        "colab_type": "text"
      },
      "source": [
        "This code will download historical data of any stocks or multiple stocks in csv "
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "EQhn_q1ZNOAW",
        "colab_type": "code",
        "colab": {},
        "outputId": "96a8f0bf-cd2a-4443-b977-e46cbf25638a"
      },
      "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"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "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"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "VZmnYBb4NOAf",
        "colab_type": "code",
        "colab": {},
        "outputId": "d493d42a-1c8f-4b77-d90b-ed32e3fbb3e2"
      },
      "source": [
        "# Downloaded Data\n",
        "\n",
        "new_file=pd.DataFrame(pd.read_csv(\"SBIN.csv\"))\n",
        "new_file[[\"date\",\"open\",\"high\",\"low\",\"close\"]]"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "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]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "iTg7nVRONOAm",
        "colab_type": "code",
        "colab": {},
        "outputId": "d5556b4d-242b-4ae3-dfda-526d38bb4094"
      },
      "source": [
        "display(dfw) # data from exchange"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "display_data",
          "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": {
            "tags": []
          }
        }
      ]
    }
  ]
}