NIFTY-50 Stock Market Data (2000 - 2021)

date Date	symbol Symbol	series Series	prev_close Prev Close	open Open	high High	low Low	last Last	close Close	vwap VWAP	volume Volume	turnover Turnover	deliverable_volume Deliverable Volume	n__deliverble %Deliverble
Mon May 26 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	2101.05	600	619	501	505.1	509.1	548.85	3145446	172636816770000	908264	0.2888
Tue May 27 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	509.1	505	610.95	491.1	564	554.65	572.15	4349144	248836962445000	677627	0.1558
Wed May 28 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	554.65	564	665.6	564	643	640.95	618.37	4588759	283753013850000	774895	0.1689
Thu May 29 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	640.95	656.65	703	608	634.5	632.4	659.6	4522302	298292067720000	1006161	0.2225
Fri May 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	632.4	642.4	668	588.3	647	644	636.41	3057669	194592873410000	462832	0.1514
Mon Jun 02 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	644	650	699	622	687	686.95	670.51	2247399	150691325015000	351112	0.1562
Tue Jun 03 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	686.95	672	689.8	632.55	670.55	672.05	665.87	2299383	153108236050000	391772	0.1704
Wed Jun 04 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	672.05	674	674	566.6	595	598.95	602.36	2832725	170631710390000	735765	0.2597
Thu Jun 05 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	598.95	603	639.8	572.3	631.5	631.85	610.65	1344712	82115215000000	167819	0.1248
Fri Jun 06 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	EQ	631.85	639.25	642.9	608.05	635	630.9	628.44	794722	49943255770000	65497	0.0824


CREATE TABLE bajajfinsv (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "series" VARCHAR,
  "prev_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "last" DOUBLE,
  "close" DOUBLE,
  "vwap" DOUBLE,
  "volume" BIGINT,
  "turnover" DOUBLE,
  "trades" DOUBLE,
  "deliverable_volume" BIGINT,
  "n__deliverble" DOUBLE
);