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)	PHOENIXLTD	981.4	971	1003	964.25	997.9	105700	1042.94	11655	44466	42.06999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PHOENIXLTD	997.9	980	994	962.85	970.35	92152	896.01	12387	40318	43.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PHOENIXLTD	970.35	1004.5	1004.5	936.25	942.9	181860	1756.35	17469	72614	39.93000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PHOENIXLTD	942.9	952.1	997.75	946	976.45	182935	1779.33	24109	91147	49.81999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PHOENIXLTD	977.9	969	980.05	955.25	969.3	90906	879.11	10123	49555	54.5099983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PHOENIXLTD	976.45	981	991.15	975.4	977.9	122113	1196.27	15627	73192	59.93999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PHOENIXLTD	1011.75	1002	1007.4	973.05	981.4	106479	1046.42	8970	46664	43.81999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PHOENIXLTD	832.7	834.5	855.9	831.55	843.85	18099	153.02	2188	8576	47.38
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PHOENIXLTD	843.85	849.85	864	835.1	838.75	22920	194.82	2349	11133	48.57
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PHOENIXLTD	838.75	841.95	863.15	836.05	857	32291	275.61	5133	16786	51.98


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