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)	SKFINDIA	3718.45	3737.05	3780	3652.25	3667.35	17838	661.38	4717	8202	45.97999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SKFINDIA	3667.35	3719.95	3719.95	3580	3653.3	23789	860.81	7902	9448	39.720001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SKFINDIA	3653.3	3680	3687.15	3570.3	3610.1	17031	614.23	4370	8155	47.880001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SKFINDIA	3610.1	3629.1	3697.45	3570.05	3593.3	19574	707.96	4386	11949	61.04999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SKFINDIA	3555.25	3522	3533.05	3420	3498.6	30184	1052.76	6349	17990	59.59999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SKFINDIA	3593.3	3540	3624	3466	3555.25	63481	2252.64	10654	34135	53.77000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SKFINDIA	3781.25	3799.75	3840	3705	3718.45	18051	673.58	4058	8378	46.40999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SKFINDIA	2175.45	2179.4	2200	2153.3	2195.85	53956	1166.33	1004	51538	95.52
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SKFINDIA	2195.85	2236.9	2238.05	2195.5	2216.1	11104	246.45	673	9868	88.87
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SKFINDIA	2216.1	2206.7	2221.2	2180	2196.15	2072	45.66	627	1179	56.9


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