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)	HAVELLS	1206.65	1208	1222	1201	1209.55	858263	10410	36538	495468	57.72999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAVELLS	1209.55	1212.8	1217.65	1185.1	1194.95	1031295	12363.83	45766	540174	52.380001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAVELLS	1194.95	1194.8	1200.6	1175	1186.8	608655	7229.49	32763	297231	48.83000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAVELLS	1186.8	1192.7	1229.55	1187.75	1223.9	613698	7435.49	22878	158085	25.76000022888184
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAVELLS	1219.3	1206.5	1207	1165.35	1174.75	1216283	14364.13	57679	676726	55.63999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAVELLS	1223.9	1229	1229	1199.8	1219.3	704743	8560.4	32621	318749	45.22999954223633
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAVELLS	1209.95	1215	1218.8	1197.05	1206.65	809138	9771.83	39929	403219	49.83000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HAVELLS	647.15	649.75	653.35	645.65	649.5	492348	3195.9	18862	97747	19.85
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HAVELLS	649.5	650	655.75	647.8	654.45	435382	2843.72	9504	101856	23.39
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HAVELLS	654.45	654	665.65	651.15	660.5	1316546	8711.25	28173	203670	15.47


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