{ "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
dateopenhighlowclose
02019-07-23 09:15:00+05:30351.20352.85350.55350.70
12019-07-23 09:20:00+05:30350.80350.80348.95349.05
22019-07-23 09:25:00+05:30349.00350.00348.80349.20
32019-07-23 09:30:00+05:30349.10349.20347.80348.20
42019-07-23 09:35:00+05:30348.15348.25347.50347.85
52019-07-23 09:40:00+05:30347.80348.30347.50347.50
62019-07-23 09:45:00+05:30347.50349.00347.50348.90
72019-07-23 09:50:00+05:30348.95350.00348.85349.30
82019-07-23 09:55:00+05:30349.30350.30349.05349.85
92019-07-23 10:00:00+05:30349.85350.15349.10349.10
102019-07-23 10:05:00+05:30349.10349.10348.30348.75
112019-07-23 10:10:00+05:30348.75349.80348.70349.80
122019-07-23 10:15:00+05:30349.70350.00349.10349.20
132019-07-23 10:20:00+05:30349.20349.40348.70349.05
142019-07-23 10:25:00+05:30349.00349.35348.85349.00
152019-07-23 10:30:00+05:30349.15349.20348.85349.05
162019-07-23 10:35:00+05:30349.05349.50348.90349.40
172019-07-23 10:40:00+05:30349.40349.95349.25349.85
182019-07-23 10:45:00+05:30349.90350.80349.65350.45
192019-07-23 10:50:00+05:30350.45350.45349.75349.85
202019-07-23 10:55:00+05:30349.80349.85349.40349.70
212019-07-23 11:00:00+05:30349.70349.80349.10349.30
222019-07-23 11:05:00+05:30349.20349.30348.60348.60
232019-07-23 11:10:00+05:30348.60349.00348.55348.80
242019-07-23 11:15:00+05:30348.80349.30348.60349.15
252019-07-23 11:20:00+05:30349.15349.85348.80349.75
262019-07-23 11:25:00+05:30349.75349.80349.25349.30
272019-07-23 11:30:00+05:30349.25349.30348.60348.60
282019-07-23 11:35:00+05:30348.65349.10348.05348.10
292019-07-23 11:40:00+05:30348.10348.35347.80348.10
..................
19952019-08-30 13:00:00+05:30267.50268.30267.50268.10
19962019-08-30 13:05:00+05:30268.15269.10267.70268.70
19972019-08-30 13:10:00+05:30268.70269.40268.30268.50
19982019-08-30 13:15:00+05:30268.50269.30268.40268.50
19992019-08-30 13:20:00+05:30268.50268.70267.60268.05
20002019-08-30 13:25:00+05:30268.10268.40267.70268.30
20012019-08-30 13:30:00+05:30268.20268.40267.80268.15
20022019-08-30 13:35:00+05:30268.10268.85268.10268.35
20032019-08-30 13:40:00+05:30268.50269.35268.50269.15
20042019-08-30 13:45:00+05:30269.25270.00269.00269.90
20052019-08-30 13:50:00+05:30269.80270.80269.80270.35
20062019-08-30 13:55:00+05:30270.30270.35268.80268.90
20072019-08-30 14:00:00+05:30268.90270.00268.65269.90
20082019-08-30 14:05:00+05:30269.95270.20269.60269.75
20092019-08-30 14:10:00+05:30269.80270.05269.50269.50
20102019-08-30 14:15:00+05:30269.50269.55268.85269.45
20112019-08-30 14:20:00+05:30269.40269.65268.85269.25
20122019-08-30 14:25:00+05:30269.30270.25269.15270.10
20132019-08-30 14:30:00+05:30270.15270.55270.05270.10
20142019-08-30 14:35:00+05:30270.20270.40269.05269.40
20152019-08-30 14:40:00+05:30269.40270.30269.40270.10
20162019-08-30 14:45:00+05:30270.10270.95270.10270.90
20172019-08-30 14:50:00+05:30270.90271.75270.85271.55
20182019-08-30 14:55:00+05:30271.60272.45271.40272.35
20192019-08-30 15:00:00+05:30272.45273.80272.35272.85
20202019-08-30 15:05:00+05:30272.95273.95272.45273.90
20212019-08-30 15:10:00+05:30273.85274.50273.65273.90
20222019-08-30 15:15:00+05:30273.95274.40273.75274.35
20232019-08-30 15:20:00+05:30274.35274.60273.85274.15
20242019-08-30 15:25:00+05:30274.20274.25273.00273.50
\n", "

2025 rows × 5 columns

\n", "
" ], "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": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
closedatehighlowopenvolume
0350.702019-07-23 09:15:00+05:30352.85350.55351.20752547
1349.052019-07-23 09:20:00+05:30350.80348.95350.80743751
2349.202019-07-23 09:25:00+05:30350.00348.80349.00594206
3348.202019-07-23 09:30:00+05:30349.20347.80349.10592144
4347.852019-07-23 09:35:00+05:30348.25347.50348.15503455
5347.502019-07-23 09:40:00+05:30348.30347.50347.80411564
6348.902019-07-23 09:45:00+05:30349.00347.50347.50384230
7349.302019-07-23 09:50:00+05:30350.00348.85348.95387064
8349.852019-07-23 09:55:00+05:30350.30349.05349.30337632
9349.102019-07-23 10:00:00+05:30350.15349.10349.85257093
10348.752019-07-23 10:05:00+05:30349.10348.30349.10396477
11349.802019-07-23 10:10:00+05:30349.80348.70348.75226859
12349.202019-07-23 10:15:00+05:30350.00349.10349.70215059
13349.052019-07-23 10:20:00+05:30349.40348.70349.20207552
14349.002019-07-23 10:25:00+05:30349.35348.85349.00147200
15349.052019-07-23 10:30:00+05:30349.20348.85349.15148228
16349.402019-07-23 10:35:00+05:30349.50348.90349.05100049
17349.852019-07-23 10:40:00+05:30349.95349.25349.40234573
18350.452019-07-23 10:45:00+05:30350.80349.65349.90294020
19349.852019-07-23 10:50:00+05:30350.45349.75350.45130359
20349.702019-07-23 10:55:00+05:30349.85349.40349.80208711
21349.302019-07-23 11:00:00+05:30349.80349.10349.70106642
22348.602019-07-23 11:05:00+05:30349.30348.60349.20273213
23348.802019-07-23 11:10:00+05:30349.00348.55348.60239866
24349.152019-07-23 11:15:00+05:30349.30348.60348.80182088
25349.752019-07-23 11:20:00+05:30349.85348.80349.15206997
26349.302019-07-23 11:25:00+05:30349.80349.25349.75242315
27348.602019-07-23 11:30:00+05:30349.30348.60349.25148363
28348.102019-07-23 11:35:00+05:30349.10348.05348.65215921
29348.102019-07-23 11:40:00+05:30348.35347.80348.10340481
.....................
1995268.102019-08-30 13:00:00+05:30268.30267.50267.50409983
1996268.702019-08-30 13:05:00+05:30269.10267.70268.15548218
1997268.502019-08-30 13:10:00+05:30269.40268.30268.70564742
1998268.502019-08-30 13:15:00+05:30269.30268.40268.50439667
1999268.052019-08-30 13:20:00+05:30268.70267.60268.50348325
2000268.302019-08-30 13:25:00+05:30268.40267.70268.10225214
2001268.152019-08-30 13:30:00+05:30268.40267.80268.20231371
2002268.352019-08-30 13:35:00+05:30268.85268.10268.10398516
2003269.152019-08-30 13:40:00+05:30269.35268.50268.50528277
2004269.902019-08-30 13:45:00+05:30270.00269.00269.251166120
2005270.352019-08-30 13:50:00+05:30270.80269.80269.801218472
2006268.902019-08-30 13:55:00+05:30270.35268.80270.30605796
2007269.902019-08-30 14:00:00+05:30270.00268.65268.90608792
2008269.752019-08-30 14:05:00+05:30270.20269.60269.95401145
2009269.502019-08-30 14:10:00+05:30270.05269.50269.80492073
2010269.452019-08-30 14:15:00+05:30269.55268.85269.50498125
2011269.252019-08-30 14:20:00+05:30269.65268.85269.40302189
2012270.102019-08-30 14:25:00+05:30270.25269.15269.30624969
2013270.102019-08-30 14:30:00+05:30270.55270.05270.15605022
2014269.402019-08-30 14:35:00+05:30270.40269.05270.20672557
2015270.102019-08-30 14:40:00+05:30270.30269.40269.40441850
2016270.902019-08-30 14:45:00+05:30270.95270.10270.10646640
2017271.552019-08-30 14:50:00+05:30271.75270.85270.90960641
2018272.352019-08-30 14:55:00+05:30272.45271.40271.60805946
2019272.852019-08-30 15:00:00+05:30273.80272.35272.451830246
2020273.902019-08-30 15:05:00+05:30273.95272.45272.951481904
2021273.902019-08-30 15:10:00+05:30274.50273.65273.851642681
2022274.352019-08-30 15:15:00+05:30274.40273.75273.951680898
2023274.152019-08-30 15:20:00+05:30274.60273.85274.351607910
2024273.502019-08-30 15:25:00+05:30274.25273.00274.20591154
\n", "

2025 rows × 6 columns

\n", "
" ], "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