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)	CARBORUNIV	870.9	878.05	912	870.9	903.4	235183	2110.21	23782	104687	44.5099983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CARBORUNIV	903.4	903.4	905	865.35	887.7	185017	1626.98	17017	87414	47.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CARBORUNIV	887.7	873.55	889.5	857.05	863.65	129770	1122.65	16489	63603	49.0099983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CARBORUNIV	863.65	869	878	844.05	869.4	119004	1022.2	14524	60421	50.77000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CARBORUNIV	871.2	870	872.25	842.4	858.35	148886	1272.28	12584	72355	48.59999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CARBORUNIV	869.4	870.15	880.65	851	871.2	177341	1535.66	14443	43111	24.309999465942383
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CARBORUNIV	879.9	883.05	885.15	863.6	870.9	73406	640.61	7905	25296	34.459999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CARBORUNIV	320.4	319	320	315.2	316.1	39550	125.49	2104	27114	68.56
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CARBORUNIV	316.1	315.5	322.2	315.5	320.55	29826	94.97	1207	21410	71.78
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CARBORUNIV	320.55	324.35	336.6	320.6	329.45	52276	172.84	1846	22397	42.84


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