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)	BAJAUTOFIN	EQ	46.95	49.45	50.75	46.5	50.75	50.75	50.05	7600	38038000000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAUTOFIN	EQ	50.75	53.2	53.2	47.9	48	48.1	48.56	5000	24280000000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAUTOFIN	EQ	48.1	46.55	47.4	44.6	44.6	44.6	45.47	3500	15914500000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAUTOFIN	EQ	44.6	43.5	46	42.1	46	45.25	44.43	6200	27547500000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAUTOFIN	EQ	45.25	48	48	42	42.9	42.9	44.44	3500	15555500000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAUTOFIN	EQ	42.9	42.05	44.9	41	43	42.9	42.47	4700	19961000000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAUTOFIN	EQ	42.9	42	42	39.5	40.25	40.1	40.25	5500	22139000000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAUTOFIN	EQ	40.1	40	40	39	39	39	39.8	1000	3980000000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAUTOFIN	EQ	39	40	41	38.5	39.5	39.5	39.37	1000	3937000000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAUTOFIN	EQ	39.5	39	40.5	39	39.9	39.9	39.72	1700	6752000000


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