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)	GAIL	EQ	67.8	65	70	65	68.8	68.7	67.91	76055	516516560000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	EQ	68.7	69.85	72.9	66	67	66.35	67.29	98097	660045745000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	EQ	66.35	68.35	68.7	61.1	63	63.2	65.24	92690	604688925000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	EQ	63.2	64.8	67	63	64.75	64.95	65.55	173654	1138298685000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	EQ	64.95	65.9	65.9	62	62.9	62.65	63.76	86590	552138810000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	EQ	62.65	64.95	64.95	62	62.7	62.3	62.81	85104	534497865000.00006
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	EQ	62.3	62	62.4	59	59.75	59.8	60.79	97101	590270265000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	EQ	59.8	62.7	62.7	60.25	61.7	61.55	61.25	97974	600092480000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	EQ	61.55	62.3	62.5	61.25	61.7	61.85	61.88	28151	174196045000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	EQ	61.85	61.75	62.9	60.05	62.9	62.45	61.34	33125	203184300000


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