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)	INDUSTOWER	257.35	261.35	263.25	254.15	255.2	3110266	8009.88	32637	791025	25.43000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSTOWER	255.2	257	258.35	250.55	253	2823052	7160.13	24267	939991	33.29999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSTOWER	253	253	255.55	250.5	252.85	1437733	3631.12	17344	635652	44.209999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSTOWER	252.85	255.55	256	250.4	251.95	1765080	4453.28	22024	750608	42.52999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSTOWER	252.9	251.8	254.9	249.45	252.6	1992805	5027.21	29630	998370	50.09999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSTOWER	251.95	252	253.8	250.7	252.9	1777969	4488.22	35642	980381	55.13999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSTOWER	259.75	261.1	261.1	255.35	257.35	1090467	2808.83	19394	254282	23.31999969482422
Fri Dec 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSTOWER	241.65	242.9	242.9	230	231.15	4581029	10718.47	58267	1848985	40.36
Mon Dec 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSTOWER	231.15	231.15	247.3	227.75	232.95	9342277	22193.45	83293	1283634	13.74
Tue Dec 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDUSTOWER	232.95	231	234.25	224.2	232.75	3443881	7946.28	24334	1269046	36.85


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