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)	MAHLOG	569.2	574	583.95	570	573.65	90315	520.29	7040	40819	45.20000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHLOG	573.65	572	576.9	538.05	540.6	175115	960.54	12358	86091	49.15999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHLOG	540.6	548.65	554.6	524.2	534.5	169893	909.93	12762	69735	41.04999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHLOG	534.5	537.95	538.1	523	527.85	77202	409.21	8748	35509	45.9900016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHLOG	513.1	513.5	514.5	485	489.45	262840	1305.31	20866	132332	50.34999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHLOG	527.85	533	534.5	511.5	513.1	129511	670.76	10274	62496	48.2599983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHLOG	576.1	578.8	580	568	569.2	79242	452.85	4818	40866	51.56999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHLOG	402.2	405.15	405.25	400	400.9	16528	66.16	834	14023	84.84
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHLOG	400.9	402	420	402	418.8	37585	155.29	1715	25203	67.06
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHLOG	418.8	417	428.95	408.2	426.45	19576	82.52	1128	13811	70.55


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