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)	ALOKINDS	29.25	29.55	29.7	29.05	29.45	14874199	4371.21	17396	3239521	21.780000686645508
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALOKINDS	29.45	29.5	29.75	28.4	28.65	13990301	4047.43	20078	4346075	31.059999465942383
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALOKINDS	28.65	28.85	29.1	27.65	28.1	17072690	4809.72	19661	4611401	27.01000022888184
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALOKINDS	28.1	28.4	28.65	27.65	27.8	13611035	3804.14	15594	3806979	27.96999931335449
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALOKINDS	29.5	29	30.35	28.6	29.35	34129648	10131.92	35834	6674141	19.559999465942383
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALOKINDS	27.8	28	29.8	27.3	29.5	34603651	9987.76	35388	8109983	23.440000534057617
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ALOKINDS	28.55	28.7	29.65	28.4	29.25	27886117	8105.34	32120	5931921	21.270000457763672
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALOKINDS	3.3	17.7	17.7	16.85	16.85	1710857	292.37	2449
Thu Feb 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALOKINDS	16.85	16.05	16.05	16.05	16.05	383712	61.59	1368
Mon Feb 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ALOKINDS	16.05	15.25	15.25	15.25	15.25	134852	20.56	631


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