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)	KSCL	551.7	554	556.05	548.5	550.45	42920	236.95	2952	17281	40.2599983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSCL	550.45	546.25	551	537.05	538.6	67295	365.5	3471	37713	56.040000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSCL	538.6	539.15	542	529	532.2	63554	338.76	3387	32688	51.43000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSCL	532.2	534	535.5	527.1	529.8	45704	242.62	2457	26525	58.040000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSCL	527.15	525	529.8	475.45	505.25	207759	1072.07	6289	70805	34.08000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSCL	529.8	530	537	525.2	527.15	65027	345.08	3312	30552	46.97999954223633
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KSCL	553.3	551.05	557	546.45	551.7	80624	445.06	3379	42670	52.91999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KSCL	508.55	508.75	512	498	500.75	127233	642.37	5273	33272	26.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KSCL	500.75	501	504.7	496	502	99092	496.36	4209	22886	23.1
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KSCL	502	500	508.75	497.5	500.15	77636	390	4468	24340	31.35


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