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 Mar 23 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	10	455	458.5	383.6	386.9	390.15	419.86	2087710	87653754275000	382057	0.183
Thu Mar 24 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	390.15	392.85	398.5	357.5	371.8	369.2	372.01	1226479	45626375060000	232172	0.1893
Mon Mar 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	369.2	376.7	394.05	375	380	378.85	383.64	1235794	47410479745000	263415	0.2132
Tue Mar 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	378.85	382.9	383.8	363.25	369.1	368.05	375.26	624072	23419148680000	198916	0.3187
Wed Mar 30 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	368.05	367	371.9	360.05	362.7	362.15	365.13	466349	17027753015000	159641	0.3423
Thu Mar 31 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	362.15	366	375	356.65	362.9	362.5	364.46	1203015	43844869335000	249796	0.2076
Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	362.5	366	396.5	361.4	391	391.55	384.84	1056290	40650273520000	189696	0.1796
Mon Apr 04 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	391.55	393	394	372.1	372.7	373.65	382.22	359643	13746288944999.998	127320	0.354
Tue Apr 05 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	373.65	375.9	377.9	364	367	365.75	370.04	279815	10354360305000	79782	0.2851
Wed Apr 06 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	JSWSTL	EQ	365.75	367	375.9	367	372.2	371.9	372.6	292625	10903062830000	91277	0.3119


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