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)	SUMICHEM	394.55	412.9	420	402.45	418.45	3015972	12452.55	62909	1085381	35.9900016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUMICHEM	418.45	422.8	424.55	408.1	417.4	836544	3486.89	24670	272707	32.599998474121094
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUMICHEM	417.4	419.2	423	405	407.7	392780	1616.33	12556	154925	39.43999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUMICHEM	407.7	411.3	419.7	410.1	412.4	331565	1374.2	9730	193687	58.41999816894531
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUMICHEM	410.7	408.4	409.85	399.3	403	240691	972.21	7276	109878	45.650001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUMICHEM	412.4	412.8	413	405.4	410.7	191185	781.95	6568	79925	41.810001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUMICHEM	394.35	394.5	398.35	391.75	394.55	167879	662.7	5364	79374	47.27999877929688
Mon Jan 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUMICHEM	3194.2	191.15	200.7	191.15	200.7	278487	549.01	306
Tue Jan 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUMICHEM	200.7	210.7	210.7	210.7	210.7	11605	24.45	34
Wed Jan 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUMICHEM	210.7	221.2	221.2	211.15	221.2	411876	907.07	2296


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