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)	KOTAKMAH	EQ	212.35	220	229.35	220	229.35	229.35	229.13	7086	162364030000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKMAH	EQ	229.35	247.7	247.7	225.25	247.7	246.95	244.12	73681	1798729060000.0002
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKMAH	EQ	246.95	229	240	227.2	228	228.4	233.75	105799	2473093055000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKMAH	EQ	228.4	235.1	239	217	224.95	225.9	226.84	40202	911954590000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKMAH	EQ	225.9	213	219	207.85	207.85	208.85	209.94	24463	513574715000.00006
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKMAH	EQ	208.85	215	219	192.15	192.15	192.15	196.47	12408	243780380000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKMAH	EQ	192.15	180.2	180.2	176.8	176.8	176.8	176.98	15253	269947240000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKMAH	EQ	176.8	165	169.45	162.7	162.7	162.7	163.34	20558	335791970000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKMAH	EQ	162.7	149.7	175.7	149.7	163.35	167.35	163.83	103323	1692772575000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	KOTAKMAH	EQ	167.35	169	177	156.15	160.5	159.85	161.69	31522	509687795000


CREATE TABLE kotakbank (
  "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
);