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)	AJANTPHARM	2118.1	2118	2155	2094.3	2118.15	27132	576.95	6404	8628	31.799999237060547
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AJANTPHARM	2118.15	2118	2140.5	2100.05	2122.35	22661	480.85	4550	6342	27.989999771118164
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AJANTPHARM	2122.35	2122.35	2128.65	2086.35	2114.6	17393	367.38	4452	7384	42.45000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AJANTPHARM	2114.6	2110.05	2122	2068	2075.7	37787	789.63	5478	21623	57.220001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AJANTPHARM	2058.85	2058.85	2084.65	2002.55	2064.9	47503	970.48	9888	22527	47.41999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AJANTPHARM	2075.7	2076	2080	2051.25	2058.85	21692	448.05	4281	8641	39.83000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AJANTPHARM	2160.35	2170.1	2177.1	2112	2118.1	33922	723.68	8144	14039	41.38999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AJANTPHARM	974.55	975	987.35	971.2	978.45	29557	290.07	2684	11218	37.95
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AJANTPHARM	978.45	978.45	984	972	979.95	857339	8360.83	1869	805887	94
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AJANTPHARM	979.95	980	984.85	972	977.65	23013	225.73	1579	6915	30.05


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