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&MFIN	160.1	161	161.7	153.15	153.75	14291090	22254.56	66730	6184173	43.27000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&MFIN	153.75	154.7	157.2	151.75	154.8	5985160	9246.73	36872	1248630	20.86000061035156
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&MFIN	154.8	155.6	156.2	150.75	154	4527402	6963.39	28350	946806	20.90999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&MFIN	154	154.75	156.2	153.65	155.65	2191384	3403.98	12292	661915	30.209999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&MFIN	157.4	156	157.4	154	154.6	3308524	5147.26	18727	1442365	43.59999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&MFIN	155.65	156.4	159	154.1	157.4	5316155	8368.31	23778	2563187	48.220001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	M&MFIN	169	164.4	164.4	156.15	160.1	28052919	44946.52	145170	10245348	36.52000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	M&MFIN	322.45	323.5	333.2	322	332.3	1690609	5566.25	16013	351594	20.8
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	M&MFIN	332.3	333.25	340.5	329.6	339.15	2425060	8149.74	34809	789645	32.56
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	M&MFIN	339.15	336.3	338.95	333.6	335.25	1673150	5623.33	25584	718589	42.95


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