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)	INFOSYSTCH	EQ	14467.75	15625	15625.2	15625	15625.2	15625.2	15625.18	5137	8026657140000.001
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INFOSYSTCH	EQ	15625.2	16800	16875.25	16253	16875.25	16855.9	16646.38	56186	93529374750000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INFOSYSTCH	EQ	16855.9	15701	16250	15507.45	15507.45	15507.45	15786.38	164605	259851640715000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INFOSYSTCH	EQ	15507.45	15256.65	15300	14266.85	14266.85	14266.85	14462.82	81997	118590794075000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INFOSYSTCH	EQ	14266.85	13125.5	13125.5	13125.5	13125.5	13125.5	13125.5	7589	9960941950000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INFOSYSTCH	EQ	13125.5	13125.5	14175.5	12075.5	13750	13757.3	13270.6	236175	313418481875000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INFOSYSTCH	EQ	13757.3	13200	13800	12656.75	12656.75	12656.75	12885.28	122331	157626976990000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INFOSYSTCH	EQ	12656.75	11950	13349	11766	13010	13077.55	12873.99	203074	261437329065000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INFOSYSTCH	EQ	13077.55	13100	13149	12031.35	12033	12090.6	12529.38	156550	196147474930000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INFOSYSTCH	EQ	12090.6	12249	12297	11203	12170	12176.4	11896.77	125313	149081962870000


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