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)	TISCO	EQ	142.35	148	153.2	146.1	152.5	152.45	150.92	2003185	30231643945000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TISCO	EQ	152.45	150.1	153	143.05	151.95	150.8	151.03	1555136	23487854555000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TISCO	EQ	150.8	144.6	162.9	144.6	158	156.55	156.85	3840284	60233642704999.99
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TISCO	EQ	156.55	158.95	169.1	158.95	169	168.25	167.61	2560449	42915295930000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TISCO	EQ	168.25	173.4	179	166.3	170.55	171.95	173.89	3641691	63324587285000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TISCO	EQ	171.95	173.95	184.9	173.95	179	182.25	180.32	4642054	83706263495000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TISCO	EQ	182.25	179	180	167.7	167.7	167.7	170.99	1705968	29170586570000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TISCO	EQ	167.7	165	172	159.15	166.5	165.3	165.39	2337738	38664964255000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TISCO	EQ	165.3	167.9	170	156.05	158.7	159.2	163	1584803	25831999455000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	TISCO	EQ	159.2	161	161.9	156	159.25	158.7	158.87	1541731	24494183355000


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