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)	HINDALC0	EQ	813.45	851	878.5	851	869	867.45	869.86	33799	2940055005000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALC0	EQ	867.45	879	930	870	900	900.35	903.51	70944	6409848250000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALC0	EQ	900.35	835	972.4	835	972.4	972.35	949.32	153030	14527435500000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALC0	EQ	972.35	1050.15	1050.15	1015.1	1045	1048.45	1047.08	129708	13581441355000.002
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALC0	EQ	1048.45	1096	1120	1015	1086	1094.95	1085.24	138829	15066226300000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALC0	EQ	1094.95	1124	1124	1015	1028	1022.9	1040.73	43684	4546304000000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALC0	EQ	1022.9	1022	1055	970	985	993.25	1016.35	64490	6554410615000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALC0	EQ	993.25	1010	1017	960	970	971.35	987.17	11011	1086970965000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALC0	EQ	971.35	965	1049.1	965	975	975.85	1001.73	26722	2676829160000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDALC0	EQ	975.85	980	988	925	947	944.1	954.46	15191	1449923675000


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