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
Mon Jan 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	157.4	166	170	166	170	170	169.52	33259	563812250000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	170	182	183.45	171	174	173.8	174.99	168710	2952261350000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	173.8	170	173.9	165	168	166.95	169.2	159820	2704093975000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	166.95	168	170	165.3	168.95	168.3	168.44	85026	1432165990000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	168.3	162.15	171	162.15	170.75	168.35	166.79	85144	1420157785000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	168.35	172.9	179.5	165	166.3	165.9	167.79	100434	1685217295000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	165.9	166.5	167.9	157	163	163.4	161.4	145784	2352906750000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	163.4	163.75	167.95	162.3	165.1	165.45	163.89	85952	1408657535000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	165.45	169.9	169.9	165	165.95	165.1	165.26	48276	797787115000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCBANK	EQ	165.1	168	168	164	166	165.45	164.68	58152	957654390000


CREATE TABLE hdfcbank (
  "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" DOUBLE,
  "n__deliverble" DOUBLE
);