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)	SHREECEM	24800.9	24805	25224	24625	24724.05	34121	8507.35	12490	7201	21.100000381469727
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	24724.05	24489	25125	24300	24865.55	39058	9665.43	14786	7102	18.18000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	24865.55	24920	25029.75	24507.05	24764	29111	7211	13995	10627	36.5099983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	24764	24925	25599	24677.85	25466.15	32205	8138.48	12185	12400	38.5
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	25247.4	24900	25174.55	24680.05	24900.3	19479	4840.77	8300	7449	38.2400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	25466.15	25467	25559.9	25183.15	25247.4	19294	4886.24	11103	7305	37.86000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	25265.45	25280	25399.95	24712.05	24800.9	21469	5362.52	9800	6106	28.440000534057617
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	20363.95	20375	20489	20287.05	20319.9	4879	994.28	1595	1281	26.26
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	20319.9	20320	21279.9	20320	21232.15	31788	6677.65	9022	11311	35.58
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHREECEM	21232.15	21200	21398.95	20950	21122.25	19053	4029.92	5781	7114	37.34


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