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)	TITAN	EQ	144.95	146	156.45	146	155	155.7	154.36	23000	355037000000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	EQ	155.7	152	152	144	148.05	147.4	146.72	26300	385870000000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	EQ	147.4	144	148.8	136	139.95	138.4	142.95	20600	294485000000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	EQ	138.4	142	149.5	141	149.5	149.5	147.87	31600	467275000000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	EQ	149.5	149.5	153	145	147.75	146.35	148.63	36600	543996500000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	EQ	146.35	150	150	141.05	144.65	144.9	145.28	33100	480879000000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	EQ	144.9	138	146.7	137.1	142	141	142.34	75600	1076059500000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	EQ	141	151.9	152.3	145.5	148	147.9	151.23	19711	298090655000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	EQ	147.9	151.5	157	146.3	148.6	148.85	154.34	62777	968924885000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TITAN	EQ	148.85	150	150	143.05	144	144.5	144.56	14332	207190540000


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