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)	KSB	1189.25	1192.85	1201.9	1185	1196.2	4622	55.26	718	2564	55.470001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSB	1196.2	1218.9	1218.9	1185	1188.35	7193	85.61	1003	5322	73.98999786376953
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSB	1188.35	1185	1193.6	1140.4	1147.3	15964	184.52	2331	9463	59.27999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSB	1147.3	1153	1179.1	1145	1152.9	13173	152.25	1991	9293	70.55000305175781
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSB	1151.15	1136.8	1148.5	1127.05	1133.75	8841	100.77	1226	6654	75.26000213623047
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSB	1152.9	1155.8	1169	1136.45	1151.15	12051	138.69	1530	7392	61.34000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSB	1209.95	1209.95	1216.2	1183	1189.25	17829	213.63	3012	12891	72.30000305175781
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KSB	674.8	673.3	685	668.75	676.5	3078	20.87	313	1529	49.68
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KSB	676.5	674.05	689	674	685.25	2309	15.82	188	1361	58.94
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KSB	685.25	682.3	692.45	674	681.1	2892	19.84	305	2041	70.57


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