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)	HDFC	EQ	271.75	293.5	293.5	293.5	293.5	293.5	293.5	22744	667536400000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	EQ	293.5	317	317	297	304	304.05	303.62	255251	7749972375000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	EQ	304.05	290	303.9	285	295	292.8	294.53	269087	7925367705000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	EQ	292.8	301	314	295	296	296.45	300.14	305916	9181669105000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	EQ	296.45	290	296.35	281	287.1	286.55	288.8	197039	5690480500000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	EQ	286.55	292	296	285	288.4	287.2	289.42	133363	3859778795000.001
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	EQ	287.2	290	292	273.25	282.85	283.85	284.54	337411	9600616635000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	EQ	283.85	287	293	284.5	285.25	285.6	287.6	222537	6400216900000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	EQ	285.6	288	290.5	283	284	283.85	285.84	113238	3236741395000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFC	EQ	283.85	284	294	276.25	291	286.55	283.6	152322	4319904740000


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