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)	BOSCHLTD	16585.55	16618.7	16696.85	16400	16432.3	9011	1488.75	3154	2839	31.51000022888184
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BOSCHLTD	16432.3	16415.6	16441	15960	16062.35	15529	2506.63	5688	5497	35.400001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BOSCHLTD	16062.35	16118.55	16219.95	15960.05	16058.35	13313	2138.17	4572	3807	28.600000381469727
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BOSCHLTD	16058.35	16170.75	16716.55	16040	16220.1	67238	10947.74	16184	13457	20.01000022888184
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BOSCHLTD	16634.85	16398	16458.35	16230	16260.25	25471	4154.73	7593	8125	31.899999618530277
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BOSCHLTD	16220.1	16320.1	16724.95	16037.6	16634.85	33726	5524.02	9029	9073	26.899999618530277
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BOSCHLTD	16697.25	16690	16873.25	16549.05	16585.55	22185	3709.89	8375	8377	37.7599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BOSCHLTD	15374.6	15399.65	15539.7	15250	15284.8	10221	1572.8	3184	2178	21.31
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BOSCHLTD	15284.8	15320.95	15450	15200	15411.85	12982	1990.71	3988	4379	33.73
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BOSCHLTD	15411.85	15385	15463.9	15130	15172.9	12150	1853.11	3928	4317	35.53


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