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)	CROMPTON	411.65	412	417.8	410.5	413	665129	2759.09	19382	285086	42.86000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CROMPTON	413	414	414.65	408.6	409.7	919414	3776.32	25957	469831	51.09999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CROMPTON	409.7	410	411.3	404.35	406.2	849599	3457.02	23346	422118	49.68000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CROMPTON	406.2	407.4	412	405.85	406.85	1492958	6090.08	39473	995676	66.69000244140625
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CROMPTON	398.05	398	398.05	382.65	385.2	1298647	5048.6	58522	623858	48.040000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CROMPTON	406.85	407	407.4	396.05	398.05	1351120	5401.98	37160	875773	64.81999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CROMPTON	412.55	414	414	405.7	411.65	1657387	6781.78	41058	1019146	61.4900016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CROMPTON	239.85	239.95	243	239.75	242.5	196029	473.44	4989	142636	72.76
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CROMPTON	242.5	243	243.2	240	240.55	2590099	6249.84	9502	2466833	95.24
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CROMPTON	240.55	241.5	242.8	238	240.65	2072976	4986.15	25343	1766241	85.2


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