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	deliverable_volume Deliverable Volume	n__deliverble %Deliverble
Tue Nov 27 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	440	770	1050	770	959	962.9	984.72	27294366	2687719053785000	9859619	0.3611999999999999
Wed Nov 28 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	962.9	984	990	874	885	893.9	941.38	4581338	431276530165000	1453278	0.3172
Thu Nov 29 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	893.9	909	914.75	841	887	884.2	888.09	5124121	455065846265000	1069678	0.2087999999999999
Fri Nov 30 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	884.2	890	958	890	929	921.55	929.17	4609762	428325662830000	1260913	0.2735
Mon Dec 03 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	921.55	939.75	995	922	980	969.3	965.65	2977470	287519974300000	816123	0.2741
Tue Dec 04 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	969.3	985	1056	976	1049	1041.45	1015.39	4849250	492386736075000	1537667	0.3171
Wed Dec 05 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	1041.45	1061	1099.5	1050	1084	1082.45	1082.79	2848209	308400973015000	904260	0.3175
Thu Dec 06 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	1082.45	1089	1109.7	1051	1090.1	1081.3	1087.03	1749516	190177114020000	825691	0.472
Fri Dec 07 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	1081.3	1100	1134	1078	1100	1102.4	1106.57	2247904	248746530710000	697763	0.3104
Mon Dec 10 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	MUNDRAPORT	EQ	1102.4	1110	1110	1061.1	1073.55	1075.4	1080.38	1012350	109372679359999.98	417514	0.4124


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