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)	SCHNEIDER	108.15	108.7	109.2	107	107.55	223030	240.75	3321	103067	46.209999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHNEIDER	107.55	108	108.4	105.25	106.4	161010	171.53	3035	73570	45.68999862670898
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHNEIDER	106.4	107.05	107.7	104.65	106.05	213544	225.96	3853	94345	44.18000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHNEIDER	106.05	106.55	109	105.8	107.95	244657	263	3812	119806	48.970001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHNEIDER	107.2	112.9	128.6	112.6	128.35	12974995	16011.39	96591	3285899	25.31999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHNEIDER	107.95	108.9	108.9	106.55	107.2	129390	138.81	2705	75335	58.220001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHNEIDER	108.75	109	109.9	106.8	108.15	231558	251.38	3744	96077	41.4900016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHNEIDER	66.35	67.4	68.35	66.2	66.4	41901	28.03	1439	15944	38.05
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHNEIDER	66.4	67.85	69.8	66.5	68.8	98666	67.77	1050	60152	60.97
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SCHNEIDER	68.8	69.1	70.4	67.5	68.05	77698	53.46	1457	34838	44.84


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