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)	SCHAEFFLER	9195.65	9245	9333.15	8951.3	9024.3	14469	1319.73	5808	7993	55.2400016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHAEFFLER	9024.3	9000.05	9072.25	8875	8933.3	24038	2157.65	7760	14617	60.810001373291016
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHAEFFLER	8933.3	1790	1825	1755	1764.9	74878	1338.75	9446	32333	43.18000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHAEFFLER	1764.9	1772.55	1777	1691	1702.5	121797	2087.16	17840	77358	63.5099983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHAEFFLER	1710.45	1710	1722.55	1671	1706.9	75926	1287.83	14793	45994	60.58000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHAEFFLER	1702.5	1700	1736.9	1648.6	1710.45	112099	1885.28	26109	56457	50.36000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHAEFFLER	9185.2	9130.2	9265.45	9093.1	9195.65	13031	1195.03	5928	5784	44.38999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHAEFFLER	4701.75	4638.05	4740.35	4621.6	4649.25	1498	70.01	520	931	62.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHAEFFLER	4649.25	4601.55	4665.55	4580	4621.85	947	43.81	402	629	66.42
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHAEFFLER	4621.85	4614.05	4660	4521	4635.7	2319	106.54	828	1098	47.35


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