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)	ITC	EQ	656	694	708.5	675	708.5	708.5	701.81	562715	39491742195000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	EQ	708.5	714	729	694.3	710.65	712.35	714.16	712637	50893789485000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	EQ	712.35	716.25	758.9	660	731	726.2	732.43	1382149	101232477810000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	EQ	726.2	741	784.3	741	784.3	784.3	776.63	721618	56042663465000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	EQ	784.3	832.4	847.05	824	847.05	847.05	841.25	231209	19450459595000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	EQ	847.05	911.15	914.85	875	914.85	914.85	907.23	1219818	110665283920000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	EQ	914.85	902	952	866.1	877	883.7	908.61	2376154	215900790480000.03
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	EQ	883.7	905	924	870.3	895	888.35	891.48	616366	54947542470000.01
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	EQ	888.35	900	936	871	876.95	879.75	908.42	667073	60598440045000.01
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	EQ	879.75	879.9	903.7	863.2	894	887.55	883.15	575381	50814658380000


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