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)	SUNTECK	527	531.95	545	520.15	523.6	433893	2291.34	17771	106858	24.6299991607666
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTECK	523.6	522.95	526.05	488.65	493.35	580273	2895.95	16994	222004	38.2599983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTECK	493.35	494	498.35	479.2	489.1	330745	1615.84	10531	113910	34.439998626708984
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTECK	489.1	491.9	497.9	475.05	477.85	285699	1377.56	10559	93542	32.7400016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTECK	474.35	462	479	458.05	472.85	480985	2255.97	20747	98551	20.489999771118164
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTECK	477.85	482	489.8	471.15	474.35	321451	1537.61	13014	91083	28.32999992370605
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTECK	515.9	517.8	534.9	514.1	527	607093	3200.49	20433	152304	25.09000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTECK	416.2	416.2	424.85	412.1	418.1	96706	403.15	2137	3192	3.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTECK	418.1	420.25	431.4	420.2	429.4	111994	478.16	2243	18491	16.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNTECK	429.4	421.85	437	420.05	424.65	117876	500.97	2270	12789	10.85


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