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)	WIPRO	EQ	2522.4	2724	2724.2	2724	2724.2	2724.2	2724.17	1599	435594205000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	EQ	2724.2	2942.15	2942.15	2942.15	2942.15	2942.15	2942.15	4392	1292192280000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	EQ	2942.15	2942.15	3177.55	2715	3000	2990.1	3063.86	132297	40533895620000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	EQ	2990.1	3144.7	3183	2790	2915	2932.25	2962.41	72840	21578221245000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	EQ	2932.25	2751	2751	2697.7	2697.7	2697.7	2697.95	10110	2727630390000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	EQ	2697.7	2697.7	2913.5	2612	2665	2701.35	2740.88	40382	11068241285000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	EQ	2701.35	2734	2789	2485.25	2485.25	2485.45	2543.38	46178	11744835900000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	EQ	2485.45	2590	2608	2485	2570	2562.9	2543.75	20037	5096904595000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	EQ	2562.9	2574	2620	2460	2484.9	2480.25	2539.63	19080	4845620595000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	EQ	2480.25	2590	2590	2405	2475.15	2497.85	2470.43	20412	5042646415000


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