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)	SHREECEM	EQ	63.5	68	68	63.05	63.6	64.75	65.13	30530	198842050000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	EQ	64.75	65.6	66	59.6	59.6	59.85	60.7	23525	142791950000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	EQ	59.85	59.1	61	59	60	60	60.03	23535	141292250000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	EQ	60	58.1	62	58.1	60.65	60.6	60.52	8931	54049825000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	EQ	60.6	60	61.95	57.05	60.6	60.45	60.21	5115	30795800000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	EQ	60.45	57.1	60	57	57.35	57.35	57.5	7001	40258465000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	EQ	57.35	58	58	53	53.35	54.1	54.66	8923	48770045000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	EQ	54.1	53.4	54.8	53	54.4	54.75	54.49	2050	11170290000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	EQ	54.75	53.75	53.95	52.7	53	52.95	53.55	4250	22759250000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	EQ	52.95	55	55	52	54	54	52.89	1480	7828000000


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