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)	M&M	EQ	419.75	453.3	453.35	448.9	453.35	453.35	453.18	67195	3045173830000
Tue Jan 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	EQ	453.35	489.6	489.65	489.6	489.65	489.65	489.65	37470	1834710050000
Wed Jan 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	EQ	489.65	528.85	528.85	451.15	519	514.85	521.37	227621	11867452450000
Thu Jan 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	EQ	514.85	528	550	518	521	524.55	538.27	198870	10704557575000
Fri Jan 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	EQ	524.55	515	522	490	498.9	496.4	508.09	91052	4626257510000
Mon Jan 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	EQ	496.4	509.9	535	491.7	495	497.2	509.86	83454	4255011195000.001
Tue Jan 11 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	EQ	497.2	514	537	510.1	537	532.8	527.14	250382	13198633825000
Wed Jan 12 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	EQ	532.8	540	550	490.2	490.2	490.25	515.33	136009	7008983525000
Thu Jan 13 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	EQ	490.25	516	520	465.5	502.5	499	500.01	85954	4297755935000
Fri Jan 14 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	EQ	499	500	525	490.1	519	519	510.06	79448	4052359510000


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