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)	RELIANCE	EQ	233.05	237.5	251.7	237.5	251.7	251.7	249.37	4456424	111131914445000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	EQ	251.7	258.4	271.85	251.3	271.85	271.85	263.52	9487878	250022190690000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	EQ	271.85	256.65	287.9	256.65	286.75	282.5	274.79	26833684	737369727570000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	EQ	282.5	289	300.7	289	293.5	294.35	295.45	15682286	463325404090000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	EQ	294.35	295	317.9	293	314.5	314.55	308.91	19870977	613838765740000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	EQ	314.55	317.4	318.7	305.3	306.65	308.5	312.35	13417057	419085494795000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	EQ	308.5	307.95	310.95	283.85	288.5	288.5	296.4	12544322	371819207090000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	EQ	288.5	289	305	282.15	304.7	301.7	294.57	12109507	356708113910000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	EQ	301.7	306	316.4	304.1	309.75	311.85	311.79	17076042	532418081645000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	RELIANCE	EQ	311.85	309.5	321.65	309.5	317	316.3	316.17	13460592	425587852020000


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