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)	INDHOTEL	218.85	220.65	220.7	214	216.55	3629097	7864.58	30451	1421988	39.18000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDHOTEL	216.55	217.3	218.55	211	211.8	3697144	7968.18	26361	690283	18.670000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDHOTEL	211.8	213.1	213.85	207.45	210.85	2914711	6130.5	18518	915671	31.420000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDHOTEL	210.85	212	215.65	211.6	212.7	3545796	7583.25	27449	1833966	51.720001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDHOTEL	215.25	214	214.8	205.25	206.6	4362462	9138.95	27076	1182705	27.11000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDHOTEL	212.7	213.7	216.5	210.7	215.25	2830030	6042.02	17326	960084	33.91999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDHOTEL	218.55	219	220.85	216.9	218.85	4093071	8963.08	22348	1894023	46.27000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDHOTEL	145	145	145.85	143.6	144.2	160775	232.34	1834	64165	39.91
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDHOTEL	144.2	144.6	151	143.55	147.6	1657880	2457.61	14333	1229388	74.15
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INDHOTEL	147.6	145.5	147.3	144.1	145.9	410983	599.15	4992	188237	45.8


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