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)	POLYPLEX	1896.65	1897	1923	1881	1889.55	57744	1098.92	7887	23583	40.84000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYPLEX	1889.55	1896.8	1928	1886	1922.8	76691	1466.78	10531	38234	49.84999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYPLEX	1922.8	1955	2046	1932	1997.45	556846	11122.34	47984	163620	29.3799991607666
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYPLEX	1997.45	2010	2140	1987	2089.8	557624	11578.18	39706	159135	28.540000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYPLEX	2074.55	2066	2148	2034.65	2099.4	273137	5746.61	23724	73272	26.82999992370605
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYPLEX	2089.8	2135	2149.9	2058.65	2074.55	260386	5508.55	25754	98313	37.7599983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYPLEX	1927.05	1929.8	1934	1890	1896.65	80915	1543.39	8610	35423	43.77999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYPLEX	510.15	511.5	519.8	502.55	506.2	26166	133.26	2097	11358	43.41
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYPLEX	506.2	512	527.8	504.55	524.15	92784	480.33	3666	54765	59.02
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POLYPLEX	524.15	524.2	536.8	516.35	522.75	102427	542.74	4912	58622	57.23


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