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)	MFSL	907.05	908	909.95	880.5	884.4	740569	6585.28	77794	512866	69.25
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MFSL	884.4	875	884.4	851.05	869.3	1157647	9965.49	32901	834674	72.0999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MFSL	869.3	865	881.25	855.3	858.85	398616	3468.84	16015	197259	49.4900016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MFSL	858.85	863.95	880	861.95	879.15	384437	3358.73	15987	231610	60.25
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MFSL	878.3	875	878.7	857.35	861.05	376602	3250.48	14406	207765	55.16999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MFSL	879.15	879.5	885	858.15	878.3	1737453	15222.94	14223	1485260	85.4800033569336
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MFSL	925.15	925	925	899	907.05	497782	4512.71	18343	277162	55.68000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MFSL	534.45	537	545.95	535	542.2	1947334	10554.28	32335	830547	42.65
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MFSL	542.2	543	556	542.25	553.15	1282447	7064.93	19600	221185	17.25
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MFSL	553.15	550	567.7	547	564.05	2368674	13208.56	33531	658525	27.8


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