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)	SUPPETRO	702.9	709.85	709.85	685.55	691.35	28154	194.77	2599	16634	59.08000183105469
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPPETRO	691.35	700	700	676	689.9	52165	357.32	4600	33284	63.810001373291016
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPPETRO	689.9	699.9	699.9	675	687.75	37311	255.43	7879	19670	52.720001220703125
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPPETRO	687.75	691	698	686.05	687.3	23733	163.78	2799	14621	61.61000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPPETRO	687.7	685	693	635	645.2	134525	889.18	13706	70448	52.369998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPPETRO	687.3	694.9	694.9	684.65	687.7	17831	122.81	1906	10491	58.84000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPPETRO	703.05	703.05	707.5	699.05	702.9	17120	120.41	1816	9587	56
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPPETRO	155.8	155.65	158	152	155.7	6689	10.39	322	5684	84.98
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPPETRO	155.7	155.3	164.8	153.85	164.1	28000	45.26	693	16730	59.75
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPPETRO	164.1	164	167.5	157.05	161.55	12689	20.66	744	6640	52.33


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