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)	INDUSINDBK	EQ	26.8	28.9	28.95	28	28.95	28.95	28.69	107224	307582690000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSINDBK	EQ	28.95	30.85	31.25	27.9	30.6	30.25	29.12	182693	532073100000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSINDBK	EQ	30.25	29.9	30	27.85	28.45	28.15	28.72	162820	467571720000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSINDBK	EQ	28.15	29.25	29.35	27.95	27.95	28	28.55	87901	251000680000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSINDBK	EQ	28	27.2	28	26.5	27.2	27.05	27.09	65684	177918970000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSINDBK	EQ	27.05	28	28.05	27.15	27.45	27.5	27.68	87142	241182330000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSINDBK	EQ	27.5	28	28	26	27	26.35	26.52	186472	494532610000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSINDBK	EQ	26.35	27.4	27.4	26.65	27.3	27.1	26.93	72140	194259125000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSINDBK	EQ	27.1	27	27.5	26.55	26.8	26.7	27.07	89730	242881680000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSINDBK	EQ	26.7	26.5	26.7	25.65	26	25.95	26.04	66070	172028850000


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