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)	ZEETELE	EQ	1092.55	1175	1179.95	1160	1179.95	1179.95	1177.03	1261391	148469028020000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEETELE	EQ	1179.95	1220	1274.35	1183.1	1274.35	1260.65	1228.02	4616547	566921974510000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEETELE	EQ	1260.65	1160.55	1317.7	1159.8	1190.95	1176.55	1238.35	8763127	1085177595800000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEETELE	EQ	1176.55	1195	1200	1095	1106	1115.45	1135.04	5164020	586135272520000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEETELE	EQ	1115.45	1097.1	1097.1	1026.25	1026.25	1026.25	1029.94	755129	77773741030000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEETELE	EQ	1026.25	1026.25	1026.25	944.3	962	966.7	980.49	3942813	386588483605000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEETELE	EQ	966.7	985	1044	891	1018.8	1019.95	995.97	6802005	677460525215000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEETELE	EQ	1019.95	1035	1088	1035	1064	1063.85	1068.99	2968833	317365292920000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEETELE	EQ	1063.85	1073	1085	1012.7	1018	1023.1	1050.57	2251046	236488202445000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ZEETELE	EQ	1023.1	1030	1034.75	980.7	1001	1001.85	1007.74	2949092	297190565470000


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