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)	TORNTPHARM	2707.35	2718.95	2719.3	2668	2682.9	176440	4738.93	19430	112587	63.810001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPHARM	2682.9	2680	2682.85	2590.25	2614.35	158464	4160.14	19841	66058	41.68999862670898
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPHARM	2614.35	2628	2638.4	2580.1	2600.3	357202	9307.38	27342	214850	60.150001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPHARM	2600.3	2608.5	2620.2	2572	2601.15	250400	6501.26	18762	114046	45.54999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPHARM	2597.15	2585	2598	2561	2590.6	60231	1553.9	6383	19381	32.18000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPHARM	2601.15	2616.95	2632.9	2576.25	2597.15	261929	6832.09	18952	137377	52.45000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPHARM	2738.55	2732.35	2734.4	2692	2707.35	108990	2950.32	14673	48710	44.68999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPHARM	1849.05	1854.9	1860	1840.05	1843.7	22477	415.64	1775	5133	22.84
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPHARM	1843.7	1844.05	1872	1844.05	1865.65	86530	1609.73	4092	18400	21.26
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPHARM	1865.65	1870	1919.8	1861.05	1900.1	504421	9563.06	18306	110983	22


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