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)	JUSTDIAL	907.25	912	918.65	885.3	891.6	509965	4601.68	17739	77361	15.170000076293944
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUSTDIAL	891.6	894	905.6	877	888.3	464194	4140.54	18378	62965	13.5600004196167
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUSTDIAL	888.3	895.8	900	856.25	869.25	408428	3570.38	18022	65113	15.9399995803833
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUSTDIAL	869.25	878	885.85	855.1	862.6	332555	2894.59	13038	63889	19.209999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUSTDIAL	859.9	855	859.45	842.1	848.6	247192	2097.95	9966	44112	17.850000381469727
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUSTDIAL	862.6	867.1	870.05	850.4	859.9	288471	2480.65	11511	40843	14.15999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUSTDIAL	905.75	894	925	890	907.25	721734	6583.52	23188	96590	13.380000114440918
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JUSTDIAL	571.35	574.85	577.5	562.45	565.1	1483500	8434.34	22320	100306	6.76
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JUSTDIAL	565.1	565.1	565.5	554.6	560.85	1953594	10919.52	27821	115108	5.89
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JUSTDIAL	560.85	562.95	563.95	549.8	553.2	1744829	9669.63	29002	211404	12.12


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