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)	SBIN	EQ	225.6	236	243.65	234.25	243.65	243.65	240.83	2373228	57153383840000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	EQ	243.65	243.65	262	238.85	258	259.1	251.46	4495741	113050615659999.98
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	EQ	259.1	249	264.7	245	249.05	248.45	252.35	3434058	86660084115000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	EQ	248.45	252	268	252	260.5	261	262.18	6658801	174581740585000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	EQ	261	261.5	279.9	255	279	273.3	269.02	7873985	211828694020000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	EQ	273.3	280	289.85	265.2	266	269.5	279.79	5519316	154424794075000
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	EQ	269.5	266.8	267	247.95	247.95	247.95	254.66	2427606	61821906360000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	EQ	247.95	244	251.5	236.6	244	244.75	243.71	2805072	68361624250000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	EQ	244.75	246	255.6	243.1	243.15	244.5	250.04	3226776	80683488755000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	SBIN	EQ	244.5	245	245	238.1	239.05	239.2	240.55	1506543	36240580640000


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