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)	GRASIM	EQ	405.8	429.9	438.3	425	438.3	438.3	432.24	101578	4390621335000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	EQ	438.3	437.5	440	420.05	439.5	437.15	428.27	126117	5401215770000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	EQ	437.15	420.1	447.9	412	430	439.6	436.1	163877	7146660280000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	EQ	439.6	449.9	474.8	449.9	474.8	474.8	474.68	44248	2100383930000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	EQ	474.8	472	512.8	472	512.8	512.8	512.61	188564	9666049480000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	EQ	512.8	553.8	553.85	475	510	501.95	505.41	368433	18620874390000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	EQ	501.95	497	497	462	462	474.3	479.9	196177	9414471210000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	EQ	474.3	465	472	437	461.9	458.45	456.26	68421	3121776245000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	EQ	458.45	460	475	442	456	452.35	460.77	103720	4779057820000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	EQ	452.35	460	460	416.2	433	434.95	432.61	93774	4056795720000.001


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