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
Wed Aug 25 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	850	1198.7	1198.7	979	985	987.95	1008.32	17116372	1725876095745000	5206360	0.3042
Thu Aug 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	987.95	992	997	975.3	976.85	979	985.65	5055400	498286476730000	1294899	0.2561
Fri Aug 27 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	979	982.4	982.4	958.55	961.2	962.65	969.94	3830750	371558603080000	976527	0.2549
Mon Aug 30 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	962.65	969.9	990	965	986.4	986.75	982.65	3058151	300510633990000	701664	0.2294
Tue Aug 31 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	986.75	986.5	990	976	987.8	988.1	982.18	2649332	260213265065000	695234	0.2623999999999999
Wed Sep 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	988.1	990	995	983.6	986	987.9	989.68	2491943	246623557695000	790586	0.3173
Thu Sep 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	987.9	989.9	1004.6	986	994	993.65	996.96	2669544	266142619640000	501792	0.188
Fri Sep 03 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	993.65	1006	1100	990.35	998.7	997.85	996.91	1233732	122991693990000.02	235508	0.1909
Mon Sep 06 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	997.85	1039.9	1039.9	992.9	996.8	994.85	998.87	1129834	112855395175000	430184	0.3807
Tue Sep 07 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	TCS	EQ	994.85	1035	1035	995	995	995.6	997.34	721529	71961091360000	198212	0.2747


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