NIFTY ALL STOCK Dataset

date Date	symbol Symbol	pre_close Pre Close	open Open	high High	low Low	close Close	volume Volume	turnover_lacs Turnover Lacs	no_of_trades No Of Trades	deliv_volume Deliv Volume	deliv Deliv %
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	856.2	861.4	861.4	836.15	841.7	2080640	17600.25	89041	913043	43.880001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	841.7	841	844.7	822.2	829.5	1801701	14959.71	72130	585233	32.47999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	829.5	830	837.7	817.15	832.05	2729631	22568.18	74665	942784	34.540000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	832.05	838	845.95	833.15	840.2	2165223	18182.07	70123	1216124	56.16999816894531
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	853.05	853	861.95	835.6	853.65	5146850	43721.85	109476	1943537	37.7599983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	840.2	844	857.75	830.15	853.05	6949276	58825.5	164837	3708261	53.36000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	869.35	868	882.4	852.15	856.2	2630289	22816.74	65866	1137112	43.22999954223633
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	531.55	532.9	538	529.55	536.6	2611808	13945.82	27497	332332	12.72
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	536.6	537	541	533.5	539.85	2776519	14957.3	43016	738407	26.59
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	M&M	539.85	538.95	539	530.4	532.75	1930883	10307.41	30030	698561	36.18


CREATE TABLE m_m (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE
);