test_code.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# !pip install nsepy\n",
    "# !pip install nsetools\n",
    "# !pip install nsepython"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "# from nsepy import get_history\n",
    "# import yfinance as yf\n",
    "# from nsetools import Nse\n",
    "from nsepython import *\n",
    "from datetime import date\n",
    "import pandas as pd\n",
    "import glob\n",
    "from datetime import date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "ticker = 'RELIANCE'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "def equity_history(symbol,series,start_date,end_date):\n",
    "    print(nsefetch(\"https://www.nseindia.com/api/historical/cm/equity?symbol=\"+symbol+\"&series=[%22\"+series+\"%22]&from=\"+start_date+\"&to=\"+end_date+\"\"))\n",
    "    return pd.DataFrame.from_records(payload[\"data\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'data': [{'_id': '61b34167edff5a0009452615', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 194.55, 'CH_TRADE_LOW_PRICE': 179.2, 'CH_OPENING_PRICE': 184.6, 'CH_CLOSING_PRICE': 188.6, 'CH_LAST_TRADED_PRICE': 187.85, 'CH_PREVIOUS_CLS_PRICE': 184.6, 'CH_TOT_TRADED_QTY': 16854998, 'CH_TOT_TRADED_VAL': 3162910041.45, 'CH_52WEEK_HIGH_PRICE': 194.55, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 127673, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-12-10', 'TIMESTAMP': '2021-12-09T18:30:00.000Z', 'createdAt': '2021-12-10T12:00:39.159Z', 'updatedAt': '2021-12-10T12:00:39.159Z', '__v': 0, 'VWAP': 187.65, 'mTIMESTAMP': '10-Dec-2021'}, {'_id': '61b1efe7a87c3d000818ef1c', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 190.4, 'CH_TRADE_LOW_PRICE': 176.2, 'CH_OPENING_PRICE': 177, 'CH_CLOSING_PRICE': 184.6, 'CH_LAST_TRADED_PRICE': 184.25, 'CH_PREVIOUS_CLS_PRICE': 175.75, 'CH_TOT_TRADED_QTY': 24389590, 'CH_TOT_TRADED_VAL': 4510806730.45, 'CH_52WEEK_HIGH_PRICE': 190.4, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 173789, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-12-09', 'TIMESTAMP': '2021-12-08T18:30:00.000Z', 'createdAt': '2021-12-09T12:00:39.791Z', 'updatedAt': '2021-12-09T12:00:39.791Z', '__v': 0, 'VWAP': 184.95, 'mTIMESTAMP': '09-Dec-2021'}, {'_id': '61b09e82347e200008347304', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 183.8, 'CH_TRADE_LOW_PRICE': 162.85, 'CH_OPENING_PRICE': 163.95, 'CH_CLOSING_PRICE': 175.75, 'CH_LAST_TRADED_PRICE': 176, 'CH_PREVIOUS_CLS_PRICE': 160.7, 'CH_TOT_TRADED_QTY': 32264155, 'CH_TOT_TRADED_VAL': 5653335991.6, 'CH_52WEEK_HIGH_PRICE': 183.8, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 225974, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-12-08', 'TIMESTAMP': '2021-12-07T18:30:00.000Z', 'createdAt': '2021-12-08T12:01:06.543Z', 'updatedAt': '2021-12-08T12:01:06.543Z', '__v': 0, 'VWAP': 175.22, 'mTIMESTAMP': '08-Dec-2021'}, {'_id': '61af4d03e9de120008066b49', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 164.7, 'CH_TRADE_LOW_PRICE': 149, 'CH_OPENING_PRICE': 149, 'CH_CLOSING_PRICE': 160.7, 'CH_LAST_TRADED_PRICE': 162.9, 'CH_PREVIOUS_CLS_PRICE': 147.7, 'CH_TOT_TRADED_QTY': 7897452, 'CH_TOT_TRADED_VAL': 1238513810.65, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 67528, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-12-07', 'TIMESTAMP': '2021-12-06T18:30:00.000Z', 'createdAt': '2021-12-07T12:01:07.120Z', 'updatedAt': '2021-12-07T12:01:07.120Z', '__v': 0, 'VWAP': 156.82, 'mTIMESTAMP': '07-Dec-2021'}, {'_id': '61adfb827a56bc00084d4c29', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 154.5, 'CH_TRADE_LOW_PRICE': 147.1, 'CH_OPENING_PRICE': 154.5, 'CH_CLOSING_PRICE': 147.7, 'CH_LAST_TRADED_PRICE': 147.9, 'CH_PREVIOUS_CLS_PRICE': 153.7, 'CH_TOT_TRADED_QTY': 2953002, 'CH_TOT_TRADED_VAL': 441572160.05, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 35343, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-12-06', 'TIMESTAMP': '2021-12-05T18:30:00.000Z', 'createdAt': '2021-12-06T12:01:06.187Z', 'updatedAt': '2021-12-06T12:01:06.187Z', '__v': 0, 'VWAP': 149.53, 'mTIMESTAMP': '06-Dec-2021'}, {'_id': '61aa06e89232b600084add92', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 154.75, 'CH_TRADE_LOW_PRICE': 151.3, 'CH_OPENING_PRICE': 152.7, 'CH_CLOSING_PRICE': 153.7, 'CH_LAST_TRADED_PRICE': 153.35, 'CH_PREVIOUS_CLS_PRICE': 152.9, 'CH_TOT_TRADED_QTY': 3092348, 'CH_TOT_TRADED_VAL': 473349321.4, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 24247, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-12-03', 'TIMESTAMP': '2021-12-02T18:30:00.000Z', 'createdAt': '2021-12-03T12:00:40.816Z', 'updatedAt': '2021-12-03T12:00:40.816Z', '__v': 0, 'VWAP': 153.07, 'mTIMESTAMP': '03-Dec-2021'}, {'_id': '61a8b58aedff5a00094510f4', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 155.3, 'CH_TRADE_LOW_PRICE': 151.5, 'CH_OPENING_PRICE': 155.3, 'CH_CLOSING_PRICE': 152.9, 'CH_LAST_TRADED_PRICE': 152.65, 'CH_PREVIOUS_CLS_PRICE': 154.75, 'CH_TOT_TRADED_QTY': 2501926, 'CH_TOT_TRADED_VAL': 383200355.85, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 26275, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-12-02', 'TIMESTAMP': '2021-12-01T18:30:00.000Z', 'createdAt': '2021-12-02T12:01:14.962Z', 'updatedAt': '2021-12-02T12:01:14.962Z', '__v': 0, 'VWAP': 153.16, 'mTIMESTAMP': '02-Dec-2021'}, {'_id': '61a763ea46b02b0009cb267d', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 155.8, 'CH_TRADE_LOW_PRICE': 148.75, 'CH_OPENING_PRICE': 150, 'CH_CLOSING_PRICE': 154.75, 'CH_LAST_TRADED_PRICE': 155.3, 'CH_PREVIOUS_CLS_PRICE': 148.15, 'CH_TOT_TRADED_QTY': 5996114, 'CH_TOT_TRADED_VAL': 915469900.05, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 55617, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-12-01', 'TIMESTAMP': '2021-11-30T18:30:00.000Z', 'createdAt': '2021-12-01T12:00:42.541Z', 'updatedAt': '2021-12-01T12:00:42.541Z', '__v': 0, 'VWAP': 152.68, 'mTIMESTAMP': '01-Dec-2021'}, {'_id': '61a612672b3cf40008972e6b', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 151.15, 'CH_TRADE_LOW_PRICE': 142.5, 'CH_OPENING_PRICE': 142.7, 'CH_CLOSING_PRICE': 148.15, 'CH_LAST_TRADED_PRICE': 146.05, 'CH_PREVIOUS_CLS_PRICE': 139.05, 'CH_TOT_TRADED_QTY': 11131410, 'CH_TOT_TRADED_VAL': 1647758641.45, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 70945, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-30', 'TIMESTAMP': '2021-11-29T18:30:00.000Z', 'createdAt': '2021-11-30T12:00:39.285Z', 'updatedAt': '2021-11-30T12:00:39.285Z', '__v': 0, 'VWAP': 148.03, 'mTIMESTAMP': '30-Nov-2021'}, {'_id': '61a4c0ea07a749000882c095', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 145.95, 'CH_TRADE_LOW_PRICE': 135.5, 'CH_OPENING_PRICE': 144.3, 'CH_CLOSING_PRICE': 139.05, 'CH_LAST_TRADED_PRICE': 138.5, 'CH_PREVIOUS_CLS_PRICE': 147, 'CH_TOT_TRADED_QTY': 5112235, 'CH_TOT_TRADED_VAL': 721187433.45, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 54680, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-29', 'TIMESTAMP': '2021-11-28T18:30:00.000Z', 'createdAt': '2021-11-29T12:00:42.103Z', 'updatedAt': '2021-11-29T12:00:42.103Z', '__v': 0, 'VWAP': 141.07, 'mTIMESTAMP': '29-Nov-2021'}, {'_id': '61a0cc6872ed870008877feb', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 154.1, 'CH_TRADE_LOW_PRICE': 146.05, 'CH_OPENING_PRICE': 152.65, 'CH_CLOSING_PRICE': 147, 'CH_LAST_TRADED_PRICE': 146.95, 'CH_PREVIOUS_CLS_PRICE': 155.85, 'CH_TOT_TRADED_QTY': 5419185, 'CH_TOT_TRADED_VAL': 812659188.35, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 56759, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-26', 'TIMESTAMP': '2021-11-25T18:30:00.000Z', 'createdAt': '2021-11-26T12:00:40.841Z', 'updatedAt': '2021-11-26T12:00:40.841Z', '__v': 0, 'VWAP': 149.96, 'mTIMESTAMP': '26-Nov-2021'}, {'_id': '619f7ae4e6926900091e5372', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 157.4, 'CH_TRADE_LOW_PRICE': 152.45, 'CH_OPENING_PRICE': 154, 'CH_CLOSING_PRICE': 155.85, 'CH_LAST_TRADED_PRICE': 155.8, 'CH_PREVIOUS_CLS_PRICE': 153.55, 'CH_TOT_TRADED_QTY': 4335671, 'CH_TOT_TRADED_VAL': 675693867.2, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 71853, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-25', 'TIMESTAMP': '2021-11-24T18:30:00.000Z', 'createdAt': '2021-11-25T12:00:36.739Z', 'updatedAt': '2021-11-25T12:00:36.739Z', '__v': 0, 'VWAP': 155.85, 'mTIMESTAMP': '25-Nov-2021'}, {'_id': '619e29825f17ee00098895fc', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 156.6, 'CH_TRADE_LOW_PRICE': 152.2, 'CH_OPENING_PRICE': 155, 'CH_CLOSING_PRICE': 153.55, 'CH_LAST_TRADED_PRICE': 152.55, 'CH_PREVIOUS_CLS_PRICE': 154.2, 'CH_TOT_TRADED_QTY': 4310673, 'CH_TOT_TRADED_VAL': 667614778.25, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 37515, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-24', 'TIMESTAMP': '2021-11-23T18:30:00.000Z', 'createdAt': '2021-11-24T12:01:06.902Z', 'updatedAt': '2021-11-24T12:01:06.902Z', '__v': 0, 'VWAP': 154.87, 'mTIMESTAMP': '24-Nov-2021'}, {'_id': '619d0fcaa3d68a00088a85e4', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 155.75, 'CH_TRADE_LOW_PRICE': 151.5, 'CH_OPENING_PRICE': 152.65, 'CH_CLOSING_PRICE': 154.2, 'CH_LAST_TRADED_PRICE': 153.9, 'CH_PREVIOUS_CLS_PRICE': 153.45, 'CH_TOT_TRADED_QTY': 4667284, 'CH_TOT_TRADED_VAL': 718235954.85, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 45295, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-23', 'TIMESTAMP': '2021-11-22T18:30:00.000Z', 'createdAt': '2021-11-23T15:59:06.663Z', 'updatedAt': '2021-11-23T15:59:06.663Z', '__v': 0, 'VWAP': 153.89, 'mTIMESTAMP': '23-Nov-2021'}, {'_id': '619b86642e69970009d3b969', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 157.5, 'CH_TRADE_LOW_PRICE': 146.7, 'CH_OPENING_PRICE': 151.45, 'CH_CLOSING_PRICE': 153.45, 'CH_LAST_TRADED_PRICE': 153.8, 'CH_PREVIOUS_CLS_PRICE': 149.85, 'CH_TOT_TRADED_QTY': 10422280, 'CH_TOT_TRADED_VAL': 1579021867.25, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 89506, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-22', 'TIMESTAMP': '2021-11-21T18:30:00.000Z', 'createdAt': '2021-11-22T12:00:36.564Z', 'updatedAt': '2021-11-22T12:00:36.564Z', '__v': 0, 'VWAP': 151.5, 'mTIMESTAMP': '22-Nov-2021'}, {'_id': '6196405e89c5470008f38441', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 171, 'CH_TRADE_LOW_PRICE': 146.45, 'CH_OPENING_PRICE': 163.5, 'CH_CLOSING_PRICE': 149.85, 'CH_LAST_TRADED_PRICE': 152, 'CH_PREVIOUS_CLS_PRICE': 162.25, 'CH_TOT_TRADED_QTY': 17084451, 'CH_TOT_TRADED_VAL': 2698717461.9, 'CH_52WEEK_HIGH_PRICE': 171, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 146666, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-18', 'TIMESTAMP': '2021-11-17T18:30:00.000Z', 'createdAt': '2021-11-18T12:00:30.768Z', 'updatedAt': '2021-11-18T12:00:30.768Z', '__v': 0, 'VWAP': 157.96, 'mTIMESTAMP': '18-Nov-2021'}, {'_id': '6194eeeb71a3860009bdb904', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 166.5, 'CH_TRADE_LOW_PRICE': 160.15, 'CH_OPENING_PRICE': 162.95, 'CH_CLOSING_PRICE': 162.25, 'CH_LAST_TRADED_PRICE': 162.25, 'CH_PREVIOUS_CLS_PRICE': 163.35, 'CH_TOT_TRADED_QTY': 5896345, 'CH_TOT_TRADED_VAL': 960332797.2, 'CH_52WEEK_HIGH_PRICE': 168.35, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 57833, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-17', 'TIMESTAMP': '2021-11-16T18:30:00.000Z', 'createdAt': '2021-11-17T12:00:43.715Z', 'updatedAt': '2021-11-17T12:00:43.715Z', '__v': 0, 'VWAP': 162.87, 'mTIMESTAMP': '17-Nov-2021'}, {'_id': '61939d85d62e770009352ad6', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 168.3, 'CH_TRADE_LOW_PRICE': 161.1, 'CH_OPENING_PRICE': 163.5, 'CH_CLOSING_PRICE': 163.35, 'CH_LAST_TRADED_PRICE': 162.8, 'CH_PREVIOUS_CLS_PRICE': 163.85, 'CH_TOT_TRADED_QTY': 7507262, 'CH_TOT_TRADED_VAL': 1234225896.95, 'CH_52WEEK_HIGH_PRICE': 168.35, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 60871, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-16', 'TIMESTAMP': '2021-11-15T18:30:00.000Z', 'createdAt': '2021-11-16T12:01:09.836Z', 'updatedAt': '2021-11-16T12:01:09.836Z', '__v': 0, 'VWAP': 164.4, 'mTIMESTAMP': '16-Nov-2021'}, {'_id': '61924be871a386000955771a', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 167.7, 'CH_TRADE_LOW_PRICE': 156.25, 'CH_OPENING_PRICE': 161.8, 'CH_CLOSING_PRICE': 163.85, 'CH_LAST_TRADED_PRICE': 162.95, 'CH_PREVIOUS_CLS_PRICE': 160.55, 'CH_TOT_TRADED_QTY': 12254901, 'CH_TOT_TRADED_VAL': 1985978818.4, 'CH_52WEEK_HIGH_PRICE': 168.35, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 92437, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-15', 'TIMESTAMP': '2021-11-14T18:30:00.000Z', 'createdAt': '2021-11-15T12:00:40.893Z', 'updatedAt': '2021-11-15T12:00:40.893Z', '__v': 0, 'VWAP': 162.06, 'mTIMESTAMP': '15-Nov-2021'}, {'_id': '618e576670ee1300092fa1c7', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 168.35, 'CH_TRADE_LOW_PRICE': 147.65, 'CH_OPENING_PRICE': 147.95, 'CH_CLOSING_PRICE': 160.55, 'CH_LAST_TRADED_PRICE': 160.5, 'CH_PREVIOUS_CLS_PRICE': 146.75, 'CH_TOT_TRADED_QTY': 29585065, 'CH_TOT_TRADED_VAL': 4748802139.55, 'CH_52WEEK_HIGH_PRICE': 168.35, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 210536, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-12', 'TIMESTAMP': '2021-11-11T18:30:00.000Z', 'createdAt': '2021-11-12T12:00:38.064Z', 'updatedAt': '2021-11-12T12:00:38.064Z', '__v': 0, 'VWAP': 160.51, 'mTIMESTAMP': '12-Nov-2021'}, {'_id': '618d0602f1951f0008c57746', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 150.95, 'CH_TRADE_LOW_PRICE': 145.3, 'CH_OPENING_PRICE': 150.9, 'CH_CLOSING_PRICE': 146.75, 'CH_LAST_TRADED_PRICE': 146.65, 'CH_PREVIOUS_CLS_PRICE': 150.3, 'CH_TOT_TRADED_QTY': 3192136, 'CH_TOT_TRADED_VAL': 471159428.55, 'CH_52WEEK_HIGH_PRICE': 154.75, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 36173, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-11', 'TIMESTAMP': '2021-11-10T18:30:00.000Z', 'createdAt': '2021-11-11T12:01:06.829Z', 'updatedAt': '2021-11-11T12:01:06.829Z', '__v': 0, 'VWAP': 147.6, 'mTIMESTAMP': '11-Nov-2021'}, {'_id': '618bb468bc3bb200084c8960', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 153.25, 'CH_TRADE_LOW_PRICE': 144.25, 'CH_OPENING_PRICE': 146, 'CH_CLOSING_PRICE': 150.3, 'CH_LAST_TRADED_PRICE': 150.6, 'CH_PREVIOUS_CLS_PRICE': 147.15, 'CH_TOT_TRADED_QTY': 7463363, 'CH_TOT_TRADED_VAL': 1120722213.8, 'CH_52WEEK_HIGH_PRICE': 154.75, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 73557, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-10', 'TIMESTAMP': '2021-11-09T18:30:00.000Z', 'createdAt': '2021-11-10T12:00:41.006Z', 'updatedAt': '2021-11-10T12:00:41.006Z', '__v': 0, 'VWAP': 150.16, 'mTIMESTAMP': '10-Nov-2021'}, {'_id': '618a62e88f071100080f8552', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 152, 'CH_TRADE_LOW_PRICE': 145.7, 'CH_OPENING_PRICE': 150.4, 'CH_CLOSING_PRICE': 147.15, 'CH_LAST_TRADED_PRICE': 146.5, 'CH_PREVIOUS_CLS_PRICE': 149.9, 'CH_TOT_TRADED_QTY': 6244990, 'CH_TOT_TRADED_VAL': 925407247.15, 'CH_52WEEK_HIGH_PRICE': 154.75, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 58578, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-09', 'TIMESTAMP': '2021-11-08T18:30:00.000Z', 'createdAt': '2021-11-09T12:00:40.121Z', 'updatedAt': '2021-11-09T12:00:40.121Z', '__v': 0, 'VWAP': 148.18, 'mTIMESTAMP': '09-Nov-2021'}, {'_id': '61891182e9cff3000803de43', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 154.75, 'CH_TRADE_LOW_PRICE': 145.7, 'CH_OPENING_PRICE': 149, 'CH_CLOSING_PRICE': 149.9, 'CH_LAST_TRADED_PRICE': 150.6, 'CH_PREVIOUS_CLS_PRICE': 146.5, 'CH_TOT_TRADED_QTY': 18117872, 'CH_TOT_TRADED_VAL': 2734169020.6, 'CH_52WEEK_HIGH_PRICE': 154.75, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 186797, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-08', 'TIMESTAMP': '2021-11-07T18:30:00.000Z', 'createdAt': '2021-11-08T12:01:06.234Z', 'updatedAt': '2021-11-08T12:01:06.234Z', '__v': 0, 'VWAP': 150.91, 'mTIMESTAMP': '08-Nov-2021'}, {'_id': '6183f1f55963b10008c6c223', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 147.8, 'CH_TRADE_LOW_PRICE': 142, 'CH_OPENING_PRICE': 142.4, 'CH_CLOSING_PRICE': 146.5, 'CH_LAST_TRADED_PRICE': 147.7, 'CH_PREVIOUS_CLS_PRICE': 140.35, 'CH_TOT_TRADED_QTY': 6310539, 'CH_TOT_TRADED_VAL': 919130124.1, 'CH_52WEEK_HIGH_PRICE': 149.25, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 65475, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-04', 'TIMESTAMP': '2021-11-03T18:30:00.000Z', 'createdAt': '2021-11-04T14:45:09.534Z', 'updatedAt': '2021-11-04T14:45:09.534Z', '__v': 0, 'VWAP': 145.65, 'mTIMESTAMP': '04-Nov-2021'}, {'_id': '618279e6caa36d0008269ac7', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 149.25, 'CH_TRADE_LOW_PRICE': 134.35, 'CH_OPENING_PRICE': 137.65, 'CH_CLOSING_PRICE': 140.35, 'CH_LAST_TRADED_PRICE': 139.85, 'CH_PREVIOUS_CLS_PRICE': 137.3, 'CH_TOT_TRADED_QTY': 24332826, 'CH_TOT_TRADED_VAL': 3485292888.15, 'CH_52WEEK_HIGH_PRICE': 149.25, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 217622, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-03', 'TIMESTAMP': '2021-11-02T18:30:00.000Z', 'createdAt': '2021-11-03T12:00:38.858Z', 'updatedAt': '2021-11-03T12:00:38.858Z', '__v': 0, 'VWAP': 143.23, 'mTIMESTAMP': '03-Nov-2021'}, {'_id': '61812883884aaf000895fd3d', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 142.6, 'CH_TRADE_LOW_PRICE': 126.6, 'CH_OPENING_PRICE': 126.7, 'CH_CLOSING_PRICE': 137.3, 'CH_LAST_TRADED_PRICE': 136.8, 'CH_PREVIOUS_CLS_PRICE': 124.5, 'CH_TOT_TRADED_QTY': 31927085, 'CH_TOT_TRADED_VAL': 4312541024.6, 'CH_52WEEK_HIGH_PRICE': 142.6, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 231658, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-02', 'TIMESTAMP': '2021-11-01T18:30:00.000Z', 'createdAt': '2021-11-02T12:01:07.419Z', 'updatedAt': '2021-11-02T12:01:07.419Z', '__v': 0, 'VWAP': 135.07, 'mTIMESTAMP': '02-Nov-2021'}, {'_id': '6180056cb4b8860009b1688e', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 128, 'CH_TRADE_LOW_PRICE': 120.9, 'CH_OPENING_PRICE': 124, 'CH_CLOSING_PRICE': 124.5, 'CH_LAST_TRADED_PRICE': 124.3, 'CH_PREVIOUS_CLS_PRICE': 122.7, 'CH_TOT_TRADED_QTY': 10472876, 'CH_TOT_TRADED_VAL': 1308744018.05, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 75957, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-11-01', 'TIMESTAMP': '2021-10-31T18:30:00.000Z', 'createdAt': '2021-11-01T15:19:08.777Z', 'updatedAt': '2021-11-01T15:19:08.777Z', '__v': 0, 'VWAP': 124.97, 'mTIMESTAMP': '01-Nov-2021'}, {'_id': '617be25fb698860008e42a56', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 124, 'CH_TRADE_LOW_PRICE': 118, 'CH_OPENING_PRICE': 119.2, 'CH_CLOSING_PRICE': 122.7, 'CH_LAST_TRADED_PRICE': 122.85, 'CH_PREVIOUS_CLS_PRICE': 119.2, 'CH_TOT_TRADED_QTY': 4978128, 'CH_TOT_TRADED_VAL': 605972519.25, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 48619, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-29', 'TIMESTAMP': '2021-10-28T18:30:00.000Z', 'createdAt': '2021-10-29T12:00:31.373Z', 'updatedAt': '2021-10-29T12:00:31.373Z', '__v': 0, 'VWAP': 121.73, 'mTIMESTAMP': '29-Oct-2021'}, {'_id': '617a90e7b698860008b70f11', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 122.45, 'CH_TRADE_LOW_PRICE': 117.85, 'CH_OPENING_PRICE': 119.85, 'CH_CLOSING_PRICE': 119.2, 'CH_LAST_TRADED_PRICE': 119.3, 'CH_PREVIOUS_CLS_PRICE': 120.05, 'CH_TOT_TRADED_QTY': 2735570, 'CH_TOT_TRADED_VAL': 327984315.7, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 33714, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-28', 'TIMESTAMP': '2021-10-27T18:30:00.000Z', 'createdAt': '2021-10-28T12:00:39.143Z', 'updatedAt': '2021-10-28T12:00:39.143Z', '__v': 0, 'VWAP': 119.9, 'mTIMESTAMP': '28-Oct-2021'}, {'_id': '61793f8b7220a800093c75ef', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 122.45, 'CH_TRADE_LOW_PRICE': 119.2, 'CH_OPENING_PRICE': 121.6, 'CH_CLOSING_PRICE': 120.05, 'CH_LAST_TRADED_PRICE': 119.8, 'CH_PREVIOUS_CLS_PRICE': 121.6, 'CH_TOT_TRADED_QTY': 1510892, 'CH_TOT_TRADED_VAL': 181902806.35, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 15160, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-27', 'TIMESTAMP': '2021-10-26T18:30:00.000Z', 'createdAt': '2021-10-27T12:01:15.565Z', 'updatedAt': '2021-10-27T12:01:15.565Z', '__v': 0, 'VWAP': 120.39, 'mTIMESTAMP': '27-Oct-2021'}, {'_id': '6177ee032ed3fb00087df234', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 122.2, 'CH_TRADE_LOW_PRICE': 116.3, 'CH_OPENING_PRICE': 117, 'CH_CLOSING_PRICE': 121.6, 'CH_LAST_TRADED_PRICE': 121.55, 'CH_PREVIOUS_CLS_PRICE': 117.05, 'CH_TOT_TRADED_QTY': 3396370, 'CH_TOT_TRADED_VAL': 409102378.55, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 46862, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-26', 'TIMESTAMP': '2021-10-25T18:30:00.000Z', 'createdAt': '2021-10-26T12:01:07.041Z', 'updatedAt': '2021-10-26T12:01:07.041Z', '__v': 0, 'VWAP': 120.45, 'mTIMESTAMP': '26-Oct-2021'}, {'_id': '61769c60db443b0008c8ec63', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 121.75, 'CH_TRADE_LOW_PRICE': 114, 'CH_OPENING_PRICE': 121.2, 'CH_CLOSING_PRICE': 117.05, 'CH_LAST_TRADED_PRICE': 117.05, 'CH_PREVIOUS_CLS_PRICE': 120.25, 'CH_TOT_TRADED_QTY': 2745832, 'CH_TOT_TRADED_VAL': 320503238.65, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 28068, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-25', 'TIMESTAMP': '2021-10-24T18:30:00.000Z', 'createdAt': '2021-10-25T12:00:32.091Z', 'updatedAt': '2021-10-25T12:00:32.091Z', '__v': 0, 'VWAP': 116.72, 'mTIMESTAMP': '25-Oct-2021'}, {'_id': '6172a8082dc18f00080fea6d', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 124.7, 'CH_TRADE_LOW_PRICE': 119.5, 'CH_OPENING_PRICE': 123, 'CH_CLOSING_PRICE': 120.25, 'CH_LAST_TRADED_PRICE': 120.5, 'CH_PREVIOUS_CLS_PRICE': 122.9, 'CH_TOT_TRADED_QTY': 2113262, 'CH_TOT_TRADED_VAL': 257917086.35, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 19675, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-22', 'TIMESTAMP': '2021-10-21T18:30:00.000Z', 'createdAt': '2021-10-22T12:01:12.305Z', 'updatedAt': '2021-10-22T12:01:12.305Z', '__v': 0, 'VWAP': 122.05, 'mTIMESTAMP': '22-Oct-2021'}, {'_id': '61715665facf5c0008bb1d68', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 127, 'CH_TRADE_LOW_PRICE': 122.25, 'CH_OPENING_PRICE': 126, 'CH_CLOSING_PRICE': 122.9, 'CH_LAST_TRADED_PRICE': 122.7, 'CH_PREVIOUS_CLS_PRICE': 124.5, 'CH_TOT_TRADED_QTY': 5970096, 'CH_TOT_TRADED_VAL': 743042684.2, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 45421, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-21', 'TIMESTAMP': '2021-10-20T18:30:00.000Z', 'createdAt': '2021-10-21T12:00:37.643Z', 'updatedAt': '2021-10-21T12:00:37.643Z', '__v': 0, 'VWAP': 124.46, 'mTIMESTAMP': '21-Oct-2021'}, {'_id': '61700beeffea140009a3a1f1', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 125.5, 'CH_TRADE_LOW_PRICE': 120.5, 'CH_OPENING_PRICE': 121.7, 'CH_CLOSING_PRICE': 124.5, 'CH_LAST_TRADED_PRICE': 124.45, 'CH_PREVIOUS_CLS_PRICE': 119.4, 'CH_TOT_TRADED_QTY': 13245703, 'CH_TOT_TRADED_VAL': 1632626319, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 81570, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-20', 'TIMESTAMP': '2021-10-19T18:30:00.000Z', 'createdAt': '2021-10-20T12:30:38.809Z', 'updatedAt': '2021-10-20T12:30:38.809Z', '__v': 0, 'VWAP': 123.26, 'mTIMESTAMP': '20-Oct-2021'}, {'_id': '616eb3822137b10008e734b4', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 128.4, 'CH_TRADE_LOW_PRICE': 113.4, 'CH_OPENING_PRICE': 113.5, 'CH_CLOSING_PRICE': 119.4, 'CH_LAST_TRADED_PRICE': 119.75, 'CH_PREVIOUS_CLS_PRICE': 112.65, 'CH_TOT_TRADED_QTY': 25059129, 'CH_TOT_TRADED_VAL': 3043914583.3, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 150107, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-19', 'TIMESTAMP': '2021-10-18T18:30:00.000Z', 'createdAt': '2021-10-19T12:01:06.322Z', 'updatedAt': '2021-10-19T12:01:06.322Z', '__v': 0, 'VWAP': 121.47, 'mTIMESTAMP': '19-Oct-2021'}, {'_id': '616d61e581039a0008f7690e', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 113.65, 'CH_TRADE_LOW_PRICE': 111.85, 'CH_OPENING_PRICE': 113.6, 'CH_CLOSING_PRICE': 112.65, 'CH_LAST_TRADED_PRICE': 112.75, 'CH_PREVIOUS_CLS_PRICE': 112.55, 'CH_TOT_TRADED_QTY': 5664809, 'CH_TOT_TRADED_VAL': 637681303.2, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 42399, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-18', 'TIMESTAMP': '2021-10-17T18:30:00.000Z', 'createdAt': '2021-10-18T12:00:37.653Z', 'updatedAt': '2021-10-18T12:00:37.653Z', '__v': 0, 'VWAP': 112.57, 'mTIMESTAMP': '18-Oct-2021'}, {'_id': '61681c0203a7b2000873e5e9', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 114.8, 'CH_TRADE_LOW_PRICE': 112.35, 'CH_OPENING_PRICE': 114.5, 'CH_CLOSING_PRICE': 112.55, 'CH_LAST_TRADED_PRICE': 112.65, 'CH_PREVIOUS_CLS_PRICE': 114.05, 'CH_TOT_TRADED_QTY': 4002402, 'CH_TOT_TRADED_VAL': 453429342.95, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 33580, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-14', 'TIMESTAMP': '2021-10-13T18:30:00.000Z', 'createdAt': '2021-10-14T12:01:06.591Z', 'updatedAt': '2021-10-14T12:01:06.591Z', '__v': 0, 'VWAP': 113.29, 'mTIMESTAMP': '14-Oct-2021'}, {'_id': '6166ca6873e7b00008259367', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 115, 'CH_TRADE_LOW_PRICE': 113.15, 'CH_OPENING_PRICE': 114.15, 'CH_CLOSING_PRICE': 114.05, 'CH_LAST_TRADED_PRICE': 114.1, 'CH_PREVIOUS_CLS_PRICE': 113.95, 'CH_TOT_TRADED_QTY': 4895053, 'CH_TOT_TRADED_VAL': 557222080.95, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 28595, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-13', 'TIMESTAMP': '2021-10-12T18:30:00.000Z', 'createdAt': '2021-10-13T12:00:40.652Z', 'updatedAt': '2021-10-13T12:00:40.652Z', '__v': 0, 'VWAP': 113.83, 'mTIMESTAMP': '13-Oct-2021'}, {'_id': '6165790260745c000893796a', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 115.55, 'CH_TRADE_LOW_PRICE': 113.75, 'CH_OPENING_PRICE': 114.95, 'CH_CLOSING_PRICE': 113.95, 'CH_LAST_TRADED_PRICE': 113.95, 'CH_PREVIOUS_CLS_PRICE': 114.75, 'CH_TOT_TRADED_QTY': 3215778, 'CH_TOT_TRADED_VAL': 368220309.1, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 29674, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-12', 'TIMESTAMP': '2021-10-11T18:30:00.000Z', 'createdAt': '2021-10-12T12:01:06.317Z', 'updatedAt': '2021-10-12T12:01:06.317Z', '__v': 0, 'VWAP': 114.5, 'mTIMESTAMP': '12-Oct-2021'}, {'_id': '61644a901ffdf40008ba43dc', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 117.35, 'CH_TRADE_LOW_PRICE': 113.65, 'CH_OPENING_PRICE': 113.65, 'CH_CLOSING_PRICE': 114.75, 'CH_LAST_TRADED_PRICE': 114.8, 'CH_PREVIOUS_CLS_PRICE': 113.4, 'CH_TOT_TRADED_QTY': 3254425, 'CH_TOT_TRADED_VAL': 375540526.05, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 24674, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-11', 'TIMESTAMP': '2021-10-10T18:30:00.000Z', 'createdAt': '2021-10-11T14:30:40.148Z', 'updatedAt': '2021-10-11T14:30:40.148Z', '__v': 0, 'VWAP': 115.39, 'mTIMESTAMP': '11-Oct-2021'}, {'_id': '6160330131c1ce0008cb0891', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 114.5, 'CH_TRADE_LOW_PRICE': 113.25, 'CH_OPENING_PRICE': 114.45, 'CH_CLOSING_PRICE': 113.4, 'CH_LAST_TRADED_PRICE': 113.65, 'CH_PREVIOUS_CLS_PRICE': 113.65, 'CH_TOT_TRADED_QTY': 1831316, 'CH_TOT_TRADED_VAL': 208072213.25, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 16820, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-08', 'TIMESTAMP': '2021-10-07T18:30:00.000Z', 'createdAt': '2021-10-08T12:01:05.942Z', 'updatedAt': '2021-10-08T12:01:05.942Z', '__v': 0, 'VWAP': 113.62, 'mTIMESTAMP': '08-Oct-2021'}, {'_id': '615ee164c7aa980008978532', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 114.7, 'CH_TRADE_LOW_PRICE': 113.05, 'CH_OPENING_PRICE': 114.65, 'CH_CLOSING_PRICE': 113.65, 'CH_LAST_TRADED_PRICE': 113.85, 'CH_PREVIOUS_CLS_PRICE': 113, 'CH_TOT_TRADED_QTY': 2664475, 'CH_TOT_TRADED_VAL': 302771601.75, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 18672, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-07', 'TIMESTAMP': '2021-10-06T18:30:00.000Z', 'createdAt': '2021-10-07T12:00:36.544Z', 'updatedAt': '2021-10-07T12:00:36.544Z', '__v': 0, 'VWAP': 113.63, 'mTIMESTAMP': '07-Oct-2021'}, {'_id': '615d8fe57c2c3b0008a00415', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 115.1, 'CH_TRADE_LOW_PRICE': 112.8, 'CH_OPENING_PRICE': 113.6, 'CH_CLOSING_PRICE': 113, 'CH_LAST_TRADED_PRICE': 113.25, 'CH_PREVIOUS_CLS_PRICE': 112.5, 'CH_TOT_TRADED_QTY': 2456312, 'CH_TOT_TRADED_VAL': 279738994.85, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 19969, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-06', 'TIMESTAMP': '2021-10-05T18:30:00.000Z', 'createdAt': '2021-10-06T12:00:37.031Z', 'updatedAt': '2021-10-06T12:00:37.031Z', '__v': 0, 'VWAP': 113.89, 'mTIMESTAMP': '06-Oct-2021'}, {'_id': '615c3e691728530008f0b477', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 115.9, 'CH_TRADE_LOW_PRICE': 112.1, 'CH_OPENING_PRICE': 115.2, 'CH_CLOSING_PRICE': 112.5, 'CH_LAST_TRADED_PRICE': 112.8, 'CH_PREVIOUS_CLS_PRICE': 115.8, 'CH_TOT_TRADED_QTY': 5977801, 'CH_TOT_TRADED_VAL': 677648617.55, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 61150, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-05', 'TIMESTAMP': '2021-10-04T18:30:00.000Z', 'createdAt': '2021-10-05T12:00:41.675Z', 'updatedAt': '2021-10-05T12:00:41.675Z', '__v': 0, 'VWAP': 113.36, 'mTIMESTAMP': '05-Oct-2021'}, {'_id': '615aed0200c38500088e0048', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 116.85, 'CH_TRADE_LOW_PRICE': 115.6, 'CH_OPENING_PRICE': 116.5, 'CH_CLOSING_PRICE': 115.8, 'CH_LAST_TRADED_PRICE': 115.75, 'CH_PREVIOUS_CLS_PRICE': 115.8, 'CH_TOT_TRADED_QTY': 1874155, 'CH_TOT_TRADED_VAL': 217438964.25, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 26416, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-04', 'TIMESTAMP': '2021-10-03T18:30:00.000Z', 'createdAt': '2021-10-04T12:01:06.379Z', 'updatedAt': '2021-10-04T12:01:06.379Z', '__v': 0, 'VWAP': 116.02, 'mTIMESTAMP': '04-Oct-2021'}, {'_id': '6156f85f00c38500086c3395', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 116.9, 'CH_TRADE_LOW_PRICE': 115.45, 'CH_OPENING_PRICE': 115.5, 'CH_CLOSING_PRICE': 115.8, 'CH_LAST_TRADED_PRICE': 115.85, 'CH_PREVIOUS_CLS_PRICE': 115.8, 'CH_TOT_TRADED_QTY': 1641048, 'CH_TOT_TRADED_VAL': 190312471.9, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 23442, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-10-01', 'TIMESTAMP': '2021-09-30T18:30:00.000Z', 'createdAt': '2021-10-01T12:00:31.472Z', 'updatedAt': '2021-10-01T12:00:31.472Z', '__v': 0, 'VWAP': 115.97, 'mTIMESTAMP': '01-Oct-2021'}, {'_id': '6155a7025956820008176a46', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 117.1, 'CH_TRADE_LOW_PRICE': 115.7, 'CH_OPENING_PRICE': 116.8, 'CH_CLOSING_PRICE': 115.8, 'CH_LAST_TRADED_PRICE': 115.9, 'CH_PREVIOUS_CLS_PRICE': 116.4, 'CH_TOT_TRADED_QTY': 1514865, 'CH_TOT_TRADED_VAL': 176012433.65, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 23435, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-09-30', 'TIMESTAMP': '2021-09-29T18:30:00.000Z', 'createdAt': '2021-09-30T12:01:06.581Z', 'updatedAt': '2021-09-30T12:01:06.581Z', '__v': 0, 'VWAP': 116.19, 'mTIMESTAMP': '30-Sep-2021'}, {'_id': '615455834a501f0008e4d29d', 'CH_SYMBOL': 'DEVYANI', 'CH_SERIES': 'EQ', 'CH_MARKET_TYPE': 'N', 'CH_TRADE_HIGH_PRICE': 117.45, 'CH_TRADE_LOW_PRICE': 115.55, 'CH_OPENING_PRICE': 116, 'CH_CLOSING_PRICE': 116.4, 'CH_LAST_TRADED_PRICE': 116.4, 'CH_PREVIOUS_CLS_PRICE': 116.4, 'CH_TOT_TRADED_QTY': 1724216, 'CH_TOT_TRADED_VAL': 200994302.65, 'CH_52WEEK_HIGH_PRICE': 140.9, 'CH_52WEEK_LOW_PRICE': 107.55, 'CH_TOTAL_TRADES': 25984, 'CH_ISIN': 'INE872J01023', 'CH_TIMESTAMP': '2021-09-29', 'TIMESTAMP': '2021-09-28T18:30:00.000Z', 'createdAt': '2021-09-29T12:01:07.390Z', 'updatedAt': '2021-09-29T12:01:07.390Z', '__v': 0, 'VWAP': 116.57, 'mTIMESTAMP': '29-Sep-2021'}], 'meta': {'series': ['EQ'], 'fromDate': '08-06-2021', 'toDate': '14-12-2021', 'symbols': ['DEVYANI', 'DEVYANI']}}\n"
     ]
    },
    {
     "ename": "KeyError",
     "evalue": "'data'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m/tmp/ipykernel_1559767/2328697930.py\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0mstart_date\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"08-06-2021\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0mend_date\u001b[0m \u001b[0;34m=\u001b[0m\u001b[0;34m\"14-12-2021\"\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 5\u001b[0;31m \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mequity_history\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msymbol\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mseries\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mstart_date\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mend_date\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/tmp/ipykernel_1559767/3749437503.py\u001b[0m in \u001b[0;36mequity_history\u001b[0;34m(symbol, series, start_date, end_date)\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;32mdef\u001b[0m \u001b[0mequity_history\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msymbol\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mseries\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mstart_date\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mend_date\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      2\u001b[0m     \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnsefetch\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"https://www.nseindia.com/api/historical/cm/equity?symbol=\"\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0msymbol\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0;34m\"&series=[%22\"\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0mseries\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0;34m\"%22]&from=\"\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0mstart_date\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0;34m\"&to=\"\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0mend_date\u001b[0m\u001b[0;34m+\u001b[0m\u001b[0;34m\"\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 3\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mDataFrame\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfrom_records\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mpayload\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"data\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m: 'data'"
     ]
    }
   ],
   "source": [
    "symbol = \"DEVYANI\"\n",
    "series = \"EQ\"\n",
    "start_date = \"08-06-2021\"\n",
    "end_date =\"14-12-2021\"\n",
    "df = equity_history(symbol,series,start_date,end_date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: []\n",
       "Index: []"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\"data\":[{\"_id\":\"61b34167edff5a0009452615\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":194.55,\"CH_TRADE_LOW_PRICE\":179.2,\"CH_OPENING_PRICE\":184.6,\"CH_CLOSING_PRICE\":188.6,\"CH_LAST_TRADED_PRICE\":187.85,\"CH_PREVIOUS_CLS_PRICE\":184.6,\"CH_TOT_TRADED_QTY\":16854998,\"CH_TOT_TRADED_VAL\":3162910041.45,\"CH_52WEEK_HIGH_PRICE\":194.55,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":127673,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-12-10\",\"TIMESTAMP\":\"2021-12-09T18:30:00.000Z\",\"createdAt\":\"2021-12-10T12:00:39.159Z\",\"updatedAt\":\"2021-12-10T12:00:39.159Z\",\"__v\":0,\"VWAP\":187.65,\"mTIMESTAMP\":\"10-Dec-2021\"},{\"_id\":\"61b1efe7a87c3d000818ef1c\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":190.4,\"CH_TRADE_LOW_PRICE\":176.2,\"CH_OPENING_PRICE\":177,\"CH_CLOSING_PRICE\":184.6,\"CH_LAST_TRADED_PRICE\":184.25,\"CH_PREVIOUS_CLS_PRICE\":175.75,\"CH_TOT_TRADED_QTY\":24389590,\"CH_TOT_TRADED_VAL\":4510806730.45,\"CH_52WEEK_HIGH_PRICE\":190.4,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":173789,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-12-09\",\"TIMESTAMP\":\"2021-12-08T18:30:00.000Z\",\"createdAt\":\"2021-12-09T12:00:39.791Z\",\"updatedAt\":\"2021-12-09T12:00:39.791Z\",\"__v\":0,\"VWAP\":184.95,\"mTIMESTAMP\":\"09-Dec-2021\"},{\"_id\":\"61b09e82347e200008347304\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":183.8,\"CH_TRADE_LOW_PRICE\":162.85,\"CH_OPENING_PRICE\":163.95,\"CH_CLOSING_PRICE\":175.75,\"CH_LAST_TRADED_PRICE\":176,\"CH_PREVIOUS_CLS_PRICE\":160.7,\"CH_TOT_TRADED_QTY\":32264155,\"CH_TOT_TRADED_VAL\":5653335991.6,\"CH_52WEEK_HIGH_PRICE\":183.8,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":225974,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-12-08\",\"TIMESTAMP\":\"2021-12-07T18:30:00.000Z\",\"createdAt\":\"2021-12-08T12:01:06.543Z\",\"updatedAt\":\"2021-12-08T12:01:06.543Z\",\"__v\":0,\"VWAP\":175.22,\"mTIMESTAMP\":\"08-Dec-2021\"},{\"_id\":\"61af4d03e9de120008066b49\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":164.7,\"CH_TRADE_LOW_PRICE\":149,\"CH_OPENING_PRICE\":149,\"CH_CLOSING_PRICE\":160.7,\"CH_LAST_TRADED_PRICE\":162.9,\"CH_PREVIOUS_CLS_PRICE\":147.7,\"CH_TOT_TRADED_QTY\":7897452,\"CH_TOT_TRADED_VAL\":1238513810.65,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":67528,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-12-07\",\"TIMESTAMP\":\"2021-12-06T18:30:00.000Z\",\"createdAt\":\"2021-12-07T12:01:07.120Z\",\"updatedAt\":\"2021-12-07T12:01:07.120Z\",\"__v\":0,\"VWAP\":156.82,\"mTIMESTAMP\":\"07-Dec-2021\"},{\"_id\":\"61adfb827a56bc00084d4c29\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":154.5,\"CH_TRADE_LOW_PRICE\":147.1,\"CH_OPENING_PRICE\":154.5,\"CH_CLOSING_PRICE\":147.7,\"CH_LAST_TRADED_PRICE\":147.9,\"CH_PREVIOUS_CLS_PRICE\":153.7,\"CH_TOT_TRADED_QTY\":2953002,\"CH_TOT_TRADED_VAL\":441572160.05,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":35343,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-12-06\",\"TIMESTAMP\":\"2021-12-05T18:30:00.000Z\",\"createdAt\":\"2021-12-06T12:01:06.187Z\",\"updatedAt\":\"2021-12-06T12:01:06.187Z\",\"__v\":0,\"VWAP\":149.53,\"mTIMESTAMP\":\"06-Dec-2021\"},{\"_id\":\"61aa06e89232b600084add92\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":154.75,\"CH_TRADE_LOW_PRICE\":151.3,\"CH_OPENING_PRICE\":152.7,\"CH_CLOSING_PRICE\":153.7,\"CH_LAST_TRADED_PRICE\":153.35,\"CH_PREVIOUS_CLS_PRICE\":152.9,\"CH_TOT_TRADED_QTY\":3092348,\"CH_TOT_TRADED_VAL\":473349321.4,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":24247,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-12-03\",\"TIMESTAMP\":\"2021-12-02T18:30:00.000Z\",\"createdAt\":\"2021-12-03T12:00:40.816Z\",\"updatedAt\":\"2021-12-03T12:00:40.816Z\",\"__v\":0,\"VWAP\":153.07,\"mTIMESTAMP\":\"03-Dec-2021\"},{\"_id\":\"61a8b58aedff5a00094510f4\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":155.3,\"CH_TRADE_LOW_PRICE\":151.5,\"CH_OPENING_PRICE\":155.3,\"CH_CLOSING_PRICE\":152.9,\"CH_LAST_TRADED_PRICE\":152.65,\"CH_PREVIOUS_CLS_PRICE\":154.75,\"CH_TOT_TRADED_QTY\":2501926,\"CH_TOT_TRADED_VAL\":383200355.85,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":26275,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-12-02\",\"TIMESTAMP\":\"2021-12-01T18:30:00.000Z\",\"createdAt\":\"2021-12-02T12:01:14.962Z\",\"updatedAt\":\"2021-12-02T12:01:14.962Z\",\"__v\":0,\"VWAP\":153.16,\"mTIMESTAMP\":\"02-Dec-2021\"},{\"_id\":\"61a763ea46b02b0009cb267d\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":155.8,\"CH_TRADE_LOW_PRICE\":148.75,\"CH_OPENING_PRICE\":150,\"CH_CLOSING_PRICE\":154.75,\"CH_LAST_TRADED_PRICE\":155.3,\"CH_PREVIOUS_CLS_PRICE\":148.15,\"CH_TOT_TRADED_QTY\":5996114,\"CH_TOT_TRADED_VAL\":915469900.05,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":55617,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-12-01\",\"TIMESTAMP\":\"2021-11-30T18:30:00.000Z\",\"createdAt\":\"2021-12-01T12:00:42.541Z\",\"updatedAt\":\"2021-12-01T12:00:42.541Z\",\"__v\":0,\"VWAP\":152.68,\"mTIMESTAMP\":\"01-Dec-2021\"},{\"_id\":\"61a612672b3cf40008972e6b\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":151.15,\"CH_TRADE_LOW_PRICE\":142.5,\"CH_OPENING_PRICE\":142.7,\"CH_CLOSING_PRICE\":148.15,\"CH_LAST_TRADED_PRICE\":146.05,\"CH_PREVIOUS_CLS_PRICE\":139.05,\"CH_TOT_TRADED_QTY\":11131410,\"CH_TOT_TRADED_VAL\":1647758641.45,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":70945,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-30\",\"TIMESTAMP\":\"2021-11-29T18:30:00.000Z\",\"createdAt\":\"2021-11-30T12:00:39.285Z\",\"updatedAt\":\"2021-11-30T12:00:39.285Z\",\"__v\":0,\"VWAP\":148.03,\"mTIMESTAMP\":\"30-Nov-2021\"},{\"_id\":\"61a4c0ea07a749000882c095\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":145.95,\"CH_TRADE_LOW_PRICE\":135.5,\"CH_OPENING_PRICE\":144.3,\"CH_CLOSING_PRICE\":139.05,\"CH_LAST_TRADED_PRICE\":138.5,\"CH_PREVIOUS_CLS_PRICE\":147,\"CH_TOT_TRADED_QTY\":5112235,\"CH_TOT_TRADED_VAL\":721187433.45,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":54680,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-29\",\"TIMESTAMP\":\"2021-11-28T18:30:00.000Z\",\"createdAt\":\"2021-11-29T12:00:42.103Z\",\"updatedAt\":\"2021-11-29T12:00:42.103Z\",\"__v\":0,\"VWAP\":141.07,\"mTIMESTAMP\":\"29-Nov-2021\"},{\"_id\":\"61a0cc6872ed870008877feb\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":154.1,\"CH_TRADE_LOW_PRICE\":146.05,\"CH_OPENING_PRICE\":152.65,\"CH_CLOSING_PRICE\":147,\"CH_LAST_TRADED_PRICE\":146.95,\"CH_PREVIOUS_CLS_PRICE\":155.85,\"CH_TOT_TRADED_QTY\":5419185,\"CH_TOT_TRADED_VAL\":812659188.35,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":56759,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-26\",\"TIMESTAMP\":\"2021-11-25T18:30:00.000Z\",\"createdAt\":\"2021-11-26T12:00:40.841Z\",\"updatedAt\":\"2021-11-26T12:00:40.841Z\",\"__v\":0,\"VWAP\":149.96,\"mTIMESTAMP\":\"26-Nov-2021\"},{\"_id\":\"619f7ae4e6926900091e5372\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":157.4,\"CH_TRADE_LOW_PRICE\":152.45,\"CH_OPENING_PRICE\":154,\"CH_CLOSING_PRICE\":155.85,\"CH_LAST_TRADED_PRICE\":155.8,\"CH_PREVIOUS_CLS_PRICE\":153.55,\"CH_TOT_TRADED_QTY\":4335671,\"CH_TOT_TRADED_VAL\":675693867.2,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":71853,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-25\",\"TIMESTAMP\":\"2021-11-24T18:30:00.000Z\",\"createdAt\":\"2021-11-25T12:00:36.739Z\",\"updatedAt\":\"2021-11-25T12:00:36.739Z\",\"__v\":0,\"VWAP\":155.85,\"mTIMESTAMP\":\"25-Nov-2021\"},{\"_id\":\"619e29825f17ee00098895fc\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":156.6,\"CH_TRADE_LOW_PRICE\":152.2,\"CH_OPENING_PRICE\":155,\"CH_CLOSING_PRICE\":153.55,\"CH_LAST_TRADED_PRICE\":152.55,\"CH_PREVIOUS_CLS_PRICE\":154.2,\"CH_TOT_TRADED_QTY\":4310673,\"CH_TOT_TRADED_VAL\":667614778.25,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":37515,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-24\",\"TIMESTAMP\":\"2021-11-23T18:30:00.000Z\",\"createdAt\":\"2021-11-24T12:01:06.902Z\",\"updatedAt\":\"2021-11-24T12:01:06.902Z\",\"__v\":0,\"VWAP\":154.87,\"mTIMESTAMP\":\"24-Nov-2021\"},{\"_id\":\"619d0fcaa3d68a00088a85e4\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":155.75,\"CH_TRADE_LOW_PRICE\":151.5,\"CH_OPENING_PRICE\":152.65,\"CH_CLOSING_PRICE\":154.2,\"CH_LAST_TRADED_PRICE\":153.9,\"CH_PREVIOUS_CLS_PRICE\":153.45,\"CH_TOT_TRADED_QTY\":4667284,\"CH_TOT_TRADED_VAL\":718235954.85,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":45295,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-23\",\"TIMESTAMP\":\"2021-11-22T18:30:00.000Z\",\"createdAt\":\"2021-11-23T15:59:06.663Z\",\"updatedAt\":\"2021-11-23T15:59:06.663Z\",\"__v\":0,\"VWAP\":153.89,\"mTIMESTAMP\":\"23-Nov-2021\"},{\"_id\":\"619b86642e69970009d3b969\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":157.5,\"CH_TRADE_LOW_PRICE\":146.7,\"CH_OPENING_PRICE\":151.45,\"CH_CLOSING_PRICE\":153.45,\"CH_LAST_TRADED_PRICE\":153.8,\"CH_PREVIOUS_CLS_PRICE\":149.85,\"CH_TOT_TRADED_QTY\":10422280,\"CH_TOT_TRADED_VAL\":1579021867.25,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":89506,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-22\",\"TIMESTAMP\":\"2021-11-21T18:30:00.000Z\",\"createdAt\":\"2021-11-22T12:00:36.564Z\",\"updatedAt\":\"2021-11-22T12:00:36.564Z\",\"__v\":0,\"VWAP\":151.5,\"mTIMESTAMP\":\"22-Nov-2021\"},{\"_id\":\"6196405e89c5470008f38441\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":171,\"CH_TRADE_LOW_PRICE\":146.45,\"CH_OPENING_PRICE\":163.5,\"CH_CLOSING_PRICE\":149.85,\"CH_LAST_TRADED_PRICE\":152,\"CH_PREVIOUS_CLS_PRICE\":162.25,\"CH_TOT_TRADED_QTY\":17084451,\"CH_TOT_TRADED_VAL\":2698717461.9,\"CH_52WEEK_HIGH_PRICE\":171,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":146666,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-18\",\"TIMESTAMP\":\"2021-11-17T18:30:00.000Z\",\"createdAt\":\"2021-11-18T12:00:30.768Z\",\"updatedAt\":\"2021-11-18T12:00:30.768Z\",\"__v\":0,\"VWAP\":157.96,\"mTIMESTAMP\":\"18-Nov-2021\"},{\"_id\":\"6194eeeb71a3860009bdb904\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":166.5,\"CH_TRADE_LOW_PRICE\":160.15,\"CH_OPENING_PRICE\":162.95,\"CH_CLOSING_PRICE\":162.25,\"CH_LAST_TRADED_PRICE\":162.25,\"CH_PREVIOUS_CLS_PRICE\":163.35,\"CH_TOT_TRADED_QTY\":5896345,\"CH_TOT_TRADED_VAL\":960332797.2,\"CH_52WEEK_HIGH_PRICE\":168.35,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":57833,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-17\",\"TIMESTAMP\":\"2021-11-16T18:30:00.000Z\",\"createdAt\":\"2021-11-17T12:00:43.715Z\",\"updatedAt\":\"2021-11-17T12:00:43.715Z\",\"__v\":0,\"VWAP\":162.87,\"mTIMESTAMP\":\"17-Nov-2021\"},{\"_id\":\"61939d85d62e770009352ad6\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":168.3,\"CH_TRADE_LOW_PRICE\":161.1,\"CH_OPENING_PRICE\":163.5,\"CH_CLOSING_PRICE\":163.35,\"CH_LAST_TRADED_PRICE\":162.8,\"CH_PREVIOUS_CLS_PRICE\":163.85,\"CH_TOT_TRADED_QTY\":7507262,\"CH_TOT_TRADED_VAL\":1234225896.95,\"CH_52WEEK_HIGH_PRICE\":168.35,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":60871,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-16\",\"TIMESTAMP\":\"2021-11-15T18:30:00.000Z\",\"createdAt\":\"2021-11-16T12:01:09.836Z\",\"updatedAt\":\"2021-11-16T12:01:09.836Z\",\"__v\":0,\"VWAP\":164.4,\"mTIMESTAMP\":\"16-Nov-2021\"},{\"_id\":\"61924be871a386000955771a\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":167.7,\"CH_TRADE_LOW_PRICE\":156.25,\"CH_OPENING_PRICE\":161.8,\"CH_CLOSING_PRICE\":163.85,\"CH_LAST_TRADED_PRICE\":162.95,\"CH_PREVIOUS_CLS_PRICE\":160.55,\"CH_TOT_TRADED_QTY\":12254901,\"CH_TOT_TRADED_VAL\":1985978818.4,\"CH_52WEEK_HIGH_PRICE\":168.35,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":92437,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-15\",\"TIMESTAMP\":\"2021-11-14T18:30:00.000Z\",\"createdAt\":\"2021-11-15T12:00:40.893Z\",\"updatedAt\":\"2021-11-15T12:00:40.893Z\",\"__v\":0,\"VWAP\":162.06,\"mTIMESTAMP\":\"15-Nov-2021\"},{\"_id\":\"618e576670ee1300092fa1c7\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":168.35,\"CH_TRADE_LOW_PRICE\":147.65,\"CH_OPENING_PRICE\":147.95,\"CH_CLOSING_PRICE\":160.55,\"CH_LAST_TRADED_PRICE\":160.5,\"CH_PREVIOUS_CLS_PRICE\":146.75,\"CH_TOT_TRADED_QTY\":29585065,\"CH_TOT_TRADED_VAL\":4748802139.55,\"CH_52WEEK_HIGH_PRICE\":168.35,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":210536,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-12\",\"TIMESTAMP\":\"2021-11-11T18:30:00.000Z\",\"createdAt\":\"2021-11-12T12:00:38.064Z\",\"updatedAt\":\"2021-11-12T12:00:38.064Z\",\"__v\":0,\"VWAP\":160.51,\"mTIMESTAMP\":\"12-Nov-2021\"},{\"_id\":\"618d0602f1951f0008c57746\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":150.95,\"CH_TRADE_LOW_PRICE\":145.3,\"CH_OPENING_PRICE\":150.9,\"CH_CLOSING_PRICE\":146.75,\"CH_LAST_TRADED_PRICE\":146.65,\"CH_PREVIOUS_CLS_PRICE\":150.3,\"CH_TOT_TRADED_QTY\":3192136,\"CH_TOT_TRADED_VAL\":471159428.55,\"CH_52WEEK_HIGH_PRICE\":154.75,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":36173,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-11\",\"TIMESTAMP\":\"2021-11-10T18:30:00.000Z\",\"createdAt\":\"2021-11-11T12:01:06.829Z\",\"updatedAt\":\"2021-11-11T12:01:06.829Z\",\"__v\":0,\"VWAP\":147.6,\"mTIMESTAMP\":\"11-Nov-2021\"},{\"_id\":\"618bb468bc3bb200084c8960\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":153.25,\"CH_TRADE_LOW_PRICE\":144.25,\"CH_OPENING_PRICE\":146,\"CH_CLOSING_PRICE\":150.3,\"CH_LAST_TRADED_PRICE\":150.6,\"CH_PREVIOUS_CLS_PRICE\":147.15,\"CH_TOT_TRADED_QTY\":7463363,\"CH_TOT_TRADED_VAL\":1120722213.8,\"CH_52WEEK_HIGH_PRICE\":154.75,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":73557,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-10\",\"TIMESTAMP\":\"2021-11-09T18:30:00.000Z\",\"createdAt\":\"2021-11-10T12:00:41.006Z\",\"updatedAt\":\"2021-11-10T12:00:41.006Z\",\"__v\":0,\"VWAP\":150.16,\"mTIMESTAMP\":\"10-Nov-2021\"},{\"_id\":\"618a62e88f071100080f8552\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":152,\"CH_TRADE_LOW_PRICE\":145.7,\"CH_OPENING_PRICE\":150.4,\"CH_CLOSING_PRICE\":147.15,\"CH_LAST_TRADED_PRICE\":146.5,\"CH_PREVIOUS_CLS_PRICE\":149.9,\"CH_TOT_TRADED_QTY\":6244990,\"CH_TOT_TRADED_VAL\":925407247.15,\"CH_52WEEK_HIGH_PRICE\":154.75,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":58578,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-09\",\"TIMESTAMP\":\"2021-11-08T18:30:00.000Z\",\"createdAt\":\"2021-11-09T12:00:40.121Z\",\"updatedAt\":\"2021-11-09T12:00:40.121Z\",\"__v\":0,\"VWAP\":148.18,\"mTIMESTAMP\":\"09-Nov-2021\"},{\"_id\":\"61891182e9cff3000803de43\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":154.75,\"CH_TRADE_LOW_PRICE\":145.7,\"CH_OPENING_PRICE\":149,\"CH_CLOSING_PRICE\":149.9,\"CH_LAST_TRADED_PRICE\":150.6,\"CH_PREVIOUS_CLS_PRICE\":146.5,\"CH_TOT_TRADED_QTY\":18117872,\"CH_TOT_TRADED_VAL\":2734169020.6,\"CH_52WEEK_HIGH_PRICE\":154.75,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":186797,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-08\",\"TIMESTAMP\":\"2021-11-07T18:30:00.000Z\",\"createdAt\":\"2021-11-08T12:01:06.234Z\",\"updatedAt\":\"2021-11-08T12:01:06.234Z\",\"__v\":0,\"VWAP\":150.91,\"mTIMESTAMP\":\"08-Nov-2021\"},{\"_id\":\"6183f1f55963b10008c6c223\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":147.8,\"CH_TRADE_LOW_PRICE\":142,\"CH_OPENING_PRICE\":142.4,\"CH_CLOSING_PRICE\":146.5,\"CH_LAST_TRADED_PRICE\":147.7,\"CH_PREVIOUS_CLS_PRICE\":140.35,\"CH_TOT_TRADED_QTY\":6310539,\"CH_TOT_TRADED_VAL\":919130124.1,\"CH_52WEEK_HIGH_PRICE\":149.25,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":65475,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-04\",\"TIMESTAMP\":\"2021-11-03T18:30:00.000Z\",\"createdAt\":\"2021-11-04T14:45:09.534Z\",\"updatedAt\":\"2021-11-04T14:45:09.534Z\",\"__v\":0,\"VWAP\":145.65,\"mTIMESTAMP\":\"04-Nov-2021\"},{\"_id\":\"618279e6caa36d0008269ac7\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":149.25,\"CH_TRADE_LOW_PRICE\":134.35,\"CH_OPENING_PRICE\":137.65,\"CH_CLOSING_PRICE\":140.35,\"CH_LAST_TRADED_PRICE\":139.85,\"CH_PREVIOUS_CLS_PRICE\":137.3,\"CH_TOT_TRADED_QTY\":24332826,\"CH_TOT_TRADED_VAL\":3485292888.15,\"CH_52WEEK_HIGH_PRICE\":149.25,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":217622,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-03\",\"TIMESTAMP\":\"2021-11-02T18:30:00.000Z\",\"createdAt\":\"2021-11-03T12:00:38.858Z\",\"updatedAt\":\"2021-11-03T12:00:38.858Z\",\"__v\":0,\"VWAP\":143.23,\"mTIMESTAMP\":\"03-Nov-2021\"},{\"_id\":\"61812883884aaf000895fd3d\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":142.6,\"CH_TRADE_LOW_PRICE\":126.6,\"CH_OPENING_PRICE\":126.7,\"CH_CLOSING_PRICE\":137.3,\"CH_LAST_TRADED_PRICE\":136.8,\"CH_PREVIOUS_CLS_PRICE\":124.5,\"CH_TOT_TRADED_QTY\":31927085,\"CH_TOT_TRADED_VAL\":4312541024.6,\"CH_52WEEK_HIGH_PRICE\":142.6,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":231658,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-02\",\"TIMESTAMP\":\"2021-11-01T18:30:00.000Z\",\"createdAt\":\"2021-11-02T12:01:07.419Z\",\"updatedAt\":\"2021-11-02T12:01:07.419Z\",\"__v\":0,\"VWAP\":135.07,\"mTIMESTAMP\":\"02-Nov-2021\"},{\"_id\":\"6180056cb4b8860009b1688e\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":128,\"CH_TRADE_LOW_PRICE\":120.9,\"CH_OPENING_PRICE\":124,\"CH_CLOSING_PRICE\":124.5,\"CH_LAST_TRADED_PRICE\":124.3,\"CH_PREVIOUS_CLS_PRICE\":122.7,\"CH_TOT_TRADED_QTY\":10472876,\"CH_TOT_TRADED_VAL\":1308744018.05,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":75957,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-11-01\",\"TIMESTAMP\":\"2021-10-31T18:30:00.000Z\",\"createdAt\":\"2021-11-01T15:19:08.777Z\",\"updatedAt\":\"2021-11-01T15:19:08.777Z\",\"__v\":0,\"VWAP\":124.97,\"mTIMESTAMP\":\"01-Nov-2021\"},{\"_id\":\"617be25fb698860008e42a56\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":124,\"CH_TRADE_LOW_PRICE\":118,\"CH_OPENING_PRICE\":119.2,\"CH_CLOSING_PRICE\":122.7,\"CH_LAST_TRADED_PRICE\":122.85,\"CH_PREVIOUS_CLS_PRICE\":119.2,\"CH_TOT_TRADED_QTY\":4978128,\"CH_TOT_TRADED_VAL\":605972519.25,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":48619,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-29\",\"TIMESTAMP\":\"2021-10-28T18:30:00.000Z\",\"createdAt\":\"2021-10-29T12:00:31.373Z\",\"updatedAt\":\"2021-10-29T12:00:31.373Z\",\"__v\":0,\"VWAP\":121.73,\"mTIMESTAMP\":\"29-Oct-2021\"},{\"_id\":\"617a90e7b698860008b70f11\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":122.45,\"CH_TRADE_LOW_PRICE\":117.85,\"CH_OPENING_PRICE\":119.85,\"CH_CLOSING_PRICE\":119.2,\"CH_LAST_TRADED_PRICE\":119.3,\"CH_PREVIOUS_CLS_PRICE\":120.05,\"CH_TOT_TRADED_QTY\":2735570,\"CH_TOT_TRADED_VAL\":327984315.7,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":33714,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-28\",\"TIMESTAMP\":\"2021-10-27T18:30:00.000Z\",\"createdAt\":\"2021-10-28T12:00:39.143Z\",\"updatedAt\":\"2021-10-28T12:00:39.143Z\",\"__v\":0,\"VWAP\":119.9,\"mTIMESTAMP\":\"28-Oct-2021\"},{\"_id\":\"61793f8b7220a800093c75ef\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":122.45,\"CH_TRADE_LOW_PRICE\":119.2,\"CH_OPENING_PRICE\":121.6,\"CH_CLOSING_PRICE\":120.05,\"CH_LAST_TRADED_PRICE\":119.8,\"CH_PREVIOUS_CLS_PRICE\":121.6,\"CH_TOT_TRADED_QTY\":1510892,\"CH_TOT_TRADED_VAL\":181902806.35,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":15160,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-27\",\"TIMESTAMP\":\"2021-10-26T18:30:00.000Z\",\"createdAt\":\"2021-10-27T12:01:15.565Z\",\"updatedAt\":\"2021-10-27T12:01:15.565Z\",\"__v\":0,\"VWAP\":120.39,\"mTIMESTAMP\":\"27-Oct-2021\"},{\"_id\":\"6177ee032ed3fb00087df234\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":122.2,\"CH_TRADE_LOW_PRICE\":116.3,\"CH_OPENING_PRICE\":117,\"CH_CLOSING_PRICE\":121.6,\"CH_LAST_TRADED_PRICE\":121.55,\"CH_PREVIOUS_CLS_PRICE\":117.05,\"CH_TOT_TRADED_QTY\":3396370,\"CH_TOT_TRADED_VAL\":409102378.55,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":46862,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-26\",\"TIMESTAMP\":\"2021-10-25T18:30:00.000Z\",\"createdAt\":\"2021-10-26T12:01:07.041Z\",\"updatedAt\":\"2021-10-26T12:01:07.041Z\",\"__v\":0,\"VWAP\":120.45,\"mTIMESTAMP\":\"26-Oct-2021\"},{\"_id\":\"61769c60db443b0008c8ec63\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":121.75,\"CH_TRADE_LOW_PRICE\":114,\"CH_OPENING_PRICE\":121.2,\"CH_CLOSING_PRICE\":117.05,\"CH_LAST_TRADED_PRICE\":117.05,\"CH_PREVIOUS_CLS_PRICE\":120.25,\"CH_TOT_TRADED_QTY\":2745832,\"CH_TOT_TRADED_VAL\":320503238.65,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":28068,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-25\",\"TIMESTAMP\":\"2021-10-24T18:30:00.000Z\",\"createdAt\":\"2021-10-25T12:00:32.091Z\",\"updatedAt\":\"2021-10-25T12:00:32.091Z\",\"__v\":0,\"VWAP\":116.72,\"mTIMESTAMP\":\"25-Oct-2021\"},{\"_id\":\"6172a8082dc18f00080fea6d\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":124.7,\"CH_TRADE_LOW_PRICE\":119.5,\"CH_OPENING_PRICE\":123,\"CH_CLOSING_PRICE\":120.25,\"CH_LAST_TRADED_PRICE\":120.5,\"CH_PREVIOUS_CLS_PRICE\":122.9,\"CH_TOT_TRADED_QTY\":2113262,\"CH_TOT_TRADED_VAL\":257917086.35,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":19675,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-22\",\"TIMESTAMP\":\"2021-10-21T18:30:00.000Z\",\"createdAt\":\"2021-10-22T12:01:12.305Z\",\"updatedAt\":\"2021-10-22T12:01:12.305Z\",\"__v\":0,\"VWAP\":122.05,\"mTIMESTAMP\":\"22-Oct-2021\"},{\"_id\":\"61715665facf5c0008bb1d68\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":127,\"CH_TRADE_LOW_PRICE\":122.25,\"CH_OPENING_PRICE\":126,\"CH_CLOSING_PRICE\":122.9,\"CH_LAST_TRADED_PRICE\":122.7,\"CH_PREVIOUS_CLS_PRICE\":124.5,\"CH_TOT_TRADED_QTY\":5970096,\"CH_TOT_TRADED_VAL\":743042684.2,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":45421,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-21\",\"TIMESTAMP\":\"2021-10-20T18:30:00.000Z\",\"createdAt\":\"2021-10-21T12:00:37.643Z\",\"updatedAt\":\"2021-10-21T12:00:37.643Z\",\"__v\":0,\"VWAP\":124.46,\"mTIMESTAMP\":\"21-Oct-2021\"},{\"_id\":\"61700beeffea140009a3a1f1\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":125.5,\"CH_TRADE_LOW_PRICE\":120.5,\"CH_OPENING_PRICE\":121.7,\"CH_CLOSING_PRICE\":124.5,\"CH_LAST_TRADED_PRICE\":124.45,\"CH_PREVIOUS_CLS_PRICE\":119.4,\"CH_TOT_TRADED_QTY\":13245703,\"CH_TOT_TRADED_VAL\":1632626319,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":81570,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-20\",\"TIMESTAMP\":\"2021-10-19T18:30:00.000Z\",\"createdAt\":\"2021-10-20T12:30:38.809Z\",\"updatedAt\":\"2021-10-20T12:30:38.809Z\",\"__v\":0,\"VWAP\":123.26,\"mTIMESTAMP\":\"20-Oct-2021\"},{\"_id\":\"616eb3822137b10008e734b4\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":128.4,\"CH_TRADE_LOW_PRICE\":113.4,\"CH_OPENING_PRICE\":113.5,\"CH_CLOSING_PRICE\":119.4,\"CH_LAST_TRADED_PRICE\":119.75,\"CH_PREVIOUS_CLS_PRICE\":112.65,\"CH_TOT_TRADED_QTY\":25059129,\"CH_TOT_TRADED_VAL\":3043914583.3,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":150107,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-19\",\"TIMESTAMP\":\"2021-10-18T18:30:00.000Z\",\"createdAt\":\"2021-10-19T12:01:06.322Z\",\"updatedAt\":\"2021-10-19T12:01:06.322Z\",\"__v\":0,\"VWAP\":121.47,\"mTIMESTAMP\":\"19-Oct-2021\"},{\"_id\":\"616d61e581039a0008f7690e\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":113.65,\"CH_TRADE_LOW_PRICE\":111.85,\"CH_OPENING_PRICE\":113.6,\"CH_CLOSING_PRICE\":112.65,\"CH_LAST_TRADED_PRICE\":112.75,\"CH_PREVIOUS_CLS_PRICE\":112.55,\"CH_TOT_TRADED_QTY\":5664809,\"CH_TOT_TRADED_VAL\":637681303.2,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":42399,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-18\",\"TIMESTAMP\":\"2021-10-17T18:30:00.000Z\",\"createdAt\":\"2021-10-18T12:00:37.653Z\",\"updatedAt\":\"2021-10-18T12:00:37.653Z\",\"__v\":0,\"VWAP\":112.57,\"mTIMESTAMP\":\"18-Oct-2021\"},{\"_id\":\"61681c0203a7b2000873e5e9\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":114.8,\"CH_TRADE_LOW_PRICE\":112.35,\"CH_OPENING_PRICE\":114.5,\"CH_CLOSING_PRICE\":112.55,\"CH_LAST_TRADED_PRICE\":112.65,\"CH_PREVIOUS_CLS_PRICE\":114.05,\"CH_TOT_TRADED_QTY\":4002402,\"CH_TOT_TRADED_VAL\":453429342.95,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":33580,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-14\",\"TIMESTAMP\":\"2021-10-13T18:30:00.000Z\",\"createdAt\":\"2021-10-14T12:01:06.591Z\",\"updatedAt\":\"2021-10-14T12:01:06.591Z\",\"__v\":0,\"VWAP\":113.29,\"mTIMESTAMP\":\"14-Oct-2021\"},{\"_id\":\"6166ca6873e7b00008259367\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":115,\"CH_TRADE_LOW_PRICE\":113.15,\"CH_OPENING_PRICE\":114.15,\"CH_CLOSING_PRICE\":114.05,\"CH_LAST_TRADED_PRICE\":114.1,\"CH_PREVIOUS_CLS_PRICE\":113.95,\"CH_TOT_TRADED_QTY\":4895053,\"CH_TOT_TRADED_VAL\":557222080.95,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":28595,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-13\",\"TIMESTAMP\":\"2021-10-12T18:30:00.000Z\",\"createdAt\":\"2021-10-13T12:00:40.652Z\",\"updatedAt\":\"2021-10-13T12:00:40.652Z\",\"__v\":0,\"VWAP\":113.83,\"mTIMESTAMP\":\"13-Oct-2021\"},{\"_id\":\"6165790260745c000893796a\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":115.55,\"CH_TRADE_LOW_PRICE\":113.75,\"CH_OPENING_PRICE\":114.95,\"CH_CLOSING_PRICE\":113.95,\"CH_LAST_TRADED_PRICE\":113.95,\"CH_PREVIOUS_CLS_PRICE\":114.75,\"CH_TOT_TRADED_QTY\":3215778,\"CH_TOT_TRADED_VAL\":368220309.1,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":29674,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-12\",\"TIMESTAMP\":\"2021-10-11T18:30:00.000Z\",\"createdAt\":\"2021-10-12T12:01:06.317Z\",\"updatedAt\":\"2021-10-12T12:01:06.317Z\",\"__v\":0,\"VWAP\":114.5,\"mTIMESTAMP\":\"12-Oct-2021\"},{\"_id\":\"61644a901ffdf40008ba43dc\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":117.35,\"CH_TRADE_LOW_PRICE\":113.65,\"CH_OPENING_PRICE\":113.65,\"CH_CLOSING_PRICE\":114.75,\"CH_LAST_TRADED_PRICE\":114.8,\"CH_PREVIOUS_CLS_PRICE\":113.4,\"CH_TOT_TRADED_QTY\":3254425,\"CH_TOT_TRADED_VAL\":375540526.05,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":24674,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-11\",\"TIMESTAMP\":\"2021-10-10T18:30:00.000Z\",\"createdAt\":\"2021-10-11T14:30:40.148Z\",\"updatedAt\":\"2021-10-11T14:30:40.148Z\",\"__v\":0,\"VWAP\":115.39,\"mTIMESTAMP\":\"11-Oct-2021\"},{\"_id\":\"6160330131c1ce0008cb0891\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":114.5,\"CH_TRADE_LOW_PRICE\":113.25,\"CH_OPENING_PRICE\":114.45,\"CH_CLOSING_PRICE\":113.4,\"CH_LAST_TRADED_PRICE\":113.65,\"CH_PREVIOUS_CLS_PRICE\":113.65,\"CH_TOT_TRADED_QTY\":1831316,\"CH_TOT_TRADED_VAL\":208072213.25,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":16820,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-08\",\"TIMESTAMP\":\"2021-10-07T18:30:00.000Z\",\"createdAt\":\"2021-10-08T12:01:05.942Z\",\"updatedAt\":\"2021-10-08T12:01:05.942Z\",\"__v\":0,\"VWAP\":113.62,\"mTIMESTAMP\":\"08-Oct-2021\"},{\"_id\":\"615ee164c7aa980008978532\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":114.7,\"CH_TRADE_LOW_PRICE\":113.05,\"CH_OPENING_PRICE\":114.65,\"CH_CLOSING_PRICE\":113.65,\"CH_LAST_TRADED_PRICE\":113.85,\"CH_PREVIOUS_CLS_PRICE\":113,\"CH_TOT_TRADED_QTY\":2664475,\"CH_TOT_TRADED_VAL\":302771601.75,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":18672,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-07\",\"TIMESTAMP\":\"2021-10-06T18:30:00.000Z\",\"createdAt\":\"2021-10-07T12:00:36.544Z\",\"updatedAt\":\"2021-10-07T12:00:36.544Z\",\"__v\":0,\"VWAP\":113.63,\"mTIMESTAMP\":\"07-Oct-2021\"},{\"_id\":\"615d8fe57c2c3b0008a00415\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":115.1,\"CH_TRADE_LOW_PRICE\":112.8,\"CH_OPENING_PRICE\":113.6,\"CH_CLOSING_PRICE\":113,\"CH_LAST_TRADED_PRICE\":113.25,\"CH_PREVIOUS_CLS_PRICE\":112.5,\"CH_TOT_TRADED_QTY\":2456312,\"CH_TOT_TRADED_VAL\":279738994.85,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":19969,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-06\",\"TIMESTAMP\":\"2021-10-05T18:30:00.000Z\",\"createdAt\":\"2021-10-06T12:00:37.031Z\",\"updatedAt\":\"2021-10-06T12:00:37.031Z\",\"__v\":0,\"VWAP\":113.89,\"mTIMESTAMP\":\"06-Oct-2021\"},{\"_id\":\"615c3e691728530008f0b477\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":115.9,\"CH_TRADE_LOW_PRICE\":112.1,\"CH_OPENING_PRICE\":115.2,\"CH_CLOSING_PRICE\":112.5,\"CH_LAST_TRADED_PRICE\":112.8,\"CH_PREVIOUS_CLS_PRICE\":115.8,\"CH_TOT_TRADED_QTY\":5977801,\"CH_TOT_TRADED_VAL\":677648617.55,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":61150,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-05\",\"TIMESTAMP\":\"2021-10-04T18:30:00.000Z\",\"createdAt\":\"2021-10-05T12:00:41.675Z\",\"updatedAt\":\"2021-10-05T12:00:41.675Z\",\"__v\":0,\"VWAP\":113.36,\"mTIMESTAMP\":\"05-Oct-2021\"},{\"_id\":\"615aed0200c38500088e0048\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":116.85,\"CH_TRADE_LOW_PRICE\":115.6,\"CH_OPENING_PRICE\":116.5,\"CH_CLOSING_PRICE\":115.8,\"CH_LAST_TRADED_PRICE\":115.75,\"CH_PREVIOUS_CLS_PRICE\":115.8,\"CH_TOT_TRADED_QTY\":1874155,\"CH_TOT_TRADED_VAL\":217438964.25,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":26416,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-04\",\"TIMESTAMP\":\"2021-10-03T18:30:00.000Z\",\"createdAt\":\"2021-10-04T12:01:06.379Z\",\"updatedAt\":\"2021-10-04T12:01:06.379Z\",\"__v\":0,\"VWAP\":116.02,\"mTIMESTAMP\":\"04-Oct-2021\"},{\"_id\":\"6156f85f00c38500086c3395\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":116.9,\"CH_TRADE_LOW_PRICE\":115.45,\"CH_OPENING_PRICE\":115.5,\"CH_CLOSING_PRICE\":115.8,\"CH_LAST_TRADED_PRICE\":115.85,\"CH_PREVIOUS_CLS_PRICE\":115.8,\"CH_TOT_TRADED_QTY\":1641048,\"CH_TOT_TRADED_VAL\":190312471.9,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":23442,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-10-01\",\"TIMESTAMP\":\"2021-09-30T18:30:00.000Z\",\"createdAt\":\"2021-10-01T12:00:31.472Z\",\"updatedAt\":\"2021-10-01T12:00:31.472Z\",\"__v\":0,\"VWAP\":115.97,\"mTIMESTAMP\":\"01-Oct-2021\"},{\"_id\":\"6155a7025956820008176a46\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":117.1,\"CH_TRADE_LOW_PRICE\":115.7,\"CH_OPENING_PRICE\":116.8,\"CH_CLOSING_PRICE\":115.8,\"CH_LAST_TRADED_PRICE\":115.9,\"CH_PREVIOUS_CLS_PRICE\":116.4,\"CH_TOT_TRADED_QTY\":1514865,\"CH_TOT_TRADED_VAL\":176012433.65,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":23435,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-09-30\",\"TIMESTAMP\":\"2021-09-29T18:30:00.000Z\",\"createdAt\":\"2021-09-30T12:01:06.581Z\",\"updatedAt\":\"2021-09-30T12:01:06.581Z\",\"__v\":0,\"VWAP\":116.19,\"mTIMESTAMP\":\"30-Sep-2021\"},{\"_id\":\"615455834a501f0008e4d29d\",\"CH_SYMBOL\":\"DEVYANI\",\"CH_SERIES\":\"EQ\",\"CH_MARKET_TYPE\":\"N\",\"CH_TRADE_HIGH_PRICE\":117.45,\"CH_TRADE_LOW_PRICE\":115.55,\"CH_OPENING_PRICE\":116,\"CH_CLOSING_PRICE\":116.4,\"CH_LAST_TRADED_PRICE\":116.4,\"CH_PREVIOUS_CLS_PRICE\":116.4,\"CH_TOT_TRADED_QTY\":1724216,\"CH_TOT_TRADED_VAL\":200994302.65,\"CH_52WEEK_HIGH_PRICE\":140.9,\"CH_52WEEK_LOW_PRICE\":107.55,\"CH_TOTAL_TRADES\":25984,\"CH_ISIN\":\"INE872J01023\",\"CH_TIMESTAMP\":\"2021-09-29\",\"TIMESTAMP\":\"2021-09-28T18:30:00.000Z\",\"createdAt\":\"2021-09-29T12:01:07.390Z\",\"updatedAt\":\"2021-09-29T12:01:07.390Z\",\"__v\":0,\"VWAP\":116.57,\"mTIMESTAMP\":\"29-Sep-2021\"}],\"meta\":{\"series\":[\"EQ\"],\"fromDate\":\"10-12-2020\",\"toDate\":\"10-12-2021\",\"symbols\":[\"DEVYANI\",\"DEVYANI\"]}}\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "\n",
    "url = \"https://www.nseindia.com/api/historical/cm/equity?symbol=DEVYANI&series=[%22EQ%22]&from=10-12-2020&to=10-12-2021\"\n",
    "\n",
    "payload={}\n",
    "headers = {\n",
    "  'authority': 'www.nseindia.com',\n",
    "  'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.93 Safari/537.36',\n",
    "  'accept': '*/*',\n",
    "  'sec-gpc': '1',\n",
    "  'sec-fetch-site': 'same-origin',\n",
    "  'sec-fetch-mode': 'cors',\n",
    "  'sec-fetch-dest': 'empty',\n",
    "  'referer': 'https://www.nseindia.com/get-quotes/equity?symbol=DEVYANI',\n",
    "  'accept-language': 'en-US,en;q=0.9',\n",
    "  # 'cookie': 'nsit=pMx4_3ctu5yrdsfzn9HTuGq0; AKA_A2=A; ak_bmsc=1CF8604689D91A0E00CA785CAFF66BA8~000000000000000000000000000000~YAAQUEo5F8qLx6R9AQAAQltjpQ4C0rqDx52k5nF8YRA8o2bOHuW93ePxvGdibn0DelzwMFaZE2FimOxfQ/AcLEU4QNwRTFkpZVIV7tF7kD6jz1s5VNBxENIajOi76AHLnTG5HURwBHWzrnYA1ap4ixHqE2Ay+5tbM9WvG36QveCoOx84nAGUkZxrSrqGrook0AI6xqVPbXPkiReqvfGB0dmWkHN1jXG9x2Y/KV99aoNrTdETLRYzejSPsfCat/RzCnGDcPb5vLZ1qE3iY4llLgo3Fx61sKiOCf+9syqlQMhxFUprre/SQeJNrXKm7Rd7yrzmZgeCyZ9Rr6XlOT+tUNJKV7/T1Pf9Q5qdj2K6yee/6H3h48glEufXefdQ6FucID4LdaJWJwj3lPs8Cg8FXbj2WCJGFq2ScsI1+pTcaNYVOdKDz/eae8WhBZzQ3239IsluGxtr7VqFZKVksgGi4phwNXYjnKNDQwJ4aEUKy28qHNsMXb1lz/Bg6Fg=; nseappid=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJhcGkubnNlIiwiYXVkIjoiYXBpLm5zZSIsImlhdCI6MTYzOTE1NzMyNSwiZXhwIjoxNjM5MTYwOTI1fQ.M4JDw51JYdWptUdutuhUdt-8vSQ942omUk2-ABxQw38; nseQuoteSymbols=[{\"symbol\":\"DEVYANI\",\"identifier\":null,\"type\":\"equity\"}]; bm_sv=17C7B9456ECEFF901C168939F9089B94~gisjaAWSWRPCCdr5P9nzSAnA6bU9AMLehKFaxCaHI9jOlD4lzRhOiyIBry6hPduztEf0h/Ci3E4m4WzIX7moRyLUTYqI82N/+n0MKxGMQTZpviYQYL1uWEo2sTRanlG4hW5MT5P0hbXkO0kRkVBX8xheEnAhDLtrUrey6ET9KF8=; ak_bmsc=1309DA47AF79B6F74A196FDF25776507~000000000000000000000000000000~YAAQUEo5F9F8x6R9AQAA4XtgpQ4G1Xh1nsONusj3XUlAsLbj1b2VAJggn70n+GLl/9QA17FVnECZvkepFzvym1p2vTU189G8oWHbpE5jyAPvRFMusDIorN3OrC3qWSAIvRyTJgf+GnzFf97OrMVpZAR6CARKYwhsP7LPBrcdURJsQ+QjzdbzDfvY9iWqMj/F4XQTDsLfmN0+HeDuSb7DE4hVCtqfm6zXpG7pjT+tfHjoiNae1C4UA+YeUwvwGgrIxzGhCFj0Ams2nGghkxwiYUOaKkc47LCdiDU+nqYTOc+ruTNpnWLKdLXO29PcAKCUs50VNXfL7Ffp4v8b6NChAsK7KkMIjGGFfLuuF7ic3CahKe95HIYuK69wAwkfQ1WzQY5zlijre4TsqwPA47/ES7cOAL5P8TAU2vqo7BkqkDEkJkwv2BCuiEu8UD/u+JmyOY3RcO1hNwmL9vCq3ttoCxynmeYqUDGXObx8vhVk/lvEAkagxS1p1zFtIauc0oA=; bm_sv=17C7B9456ECEFF901C168939F9089B94~gisjaAWSWRPCCdr5P9nzSAnA6bU9AMLehKFaxCaHI9jOlD4lzRhOiyIBry6hPduztEf0h/Ci3E4m4WzIX7moRyLUTYqI82N/+n0MKxGMQTY/izUQ8Av0Z/+mi4g+SALbF8z8FHdNhH15/1LDxCNhrMYp3GyTCYI6s8NgQR2ad6E='\n",
    "}\n",
    "\n",
    "response = requests.request(\"GET\", url, headers=headers, data=payload)\n",
    "\n",
    "print(response.text)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "response\n",
    "\n",
    "\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "\n",
    "headers = {\n",
    "    'authority': 'www.nseindia.com',\n",
    "    'referer': 'https://www.nseindia.com/get-quotes/equity?symbol=DEVYANI',\n",
    "}\n",
    "\n",
    "params = (\n",
    "    ('symbol', 'DEVYANI'),\n",
    "    ('series', '/[\"EQ\"/]'),\n",
    "    ('from', '10-12-2020'),\n",
    "    ('to', '10-12-2021'),\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "response = requests.get('https://www.nseindia.com/api/historical/cm/equity?symbol=DEVYANI&series=\\[%22EQ%22\\]&from=10-12-2020&to=10-12-2021', headers=headers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "import urllib.request\n",
    "import json\n",
    "class GoogleFinanceAPI:\n",
    "    def __init__(self):\n",
    "        self.prefix = \"https://www.google.com/finance/quote/{}:{}\"\n",
    "    def get(self,symbol,exchange):\n",
    "            url = self.prefix.format(symbol,exchange)\n",
    "            print(url)\n",
    "            u = urllib.request.urlopen(url)\n",
    "            content = u.read().decode('utf-8')\n",
    "            return content\n",
    "            # obj = json.loads(content[3:])\n",
    "            # return obj[0]\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "aa04fd3e108343f53b2d6e6654c4c4b6057699e7018a04c2df91327deac36d8c"
  },
  "kernelspec": {
   "display_name": "Python 3.8.3 64-bit ('venv': venv)",
   "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.8.10"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}