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)	NOCIL	233.25	234.95	234.95	228	229	316511	732.25	7490	147001	46.43999862670898
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NOCIL	229	229	232.4	225.15	226.6	612015	1400.16	12008	224730	36.720001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NOCIL	226.6	227.8	229.6	218.95	222.8	485814	1086.14	10423	193469	39.81999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NOCIL	222.8	224.25	225.75	220.65	223.1	326411	727.5	8425	135372	41.470001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NOCIL	222.9	221.55	223.45	220	220.65	375571	831.97	8769	147601	39.29999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NOCIL	223.1	223.35	224.8	221.65	222.9	324544	724.8	7037	124108	38.2400016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NOCIL	236.55	235.95	237.65	232.4	233.25	400963	938.34	7878	151074	37.68000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NOCIL	101.5	102.2	106.75	101.6	105.45	2181274	2283.02	13184	804532	36.88
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NOCIL	105.45	107.5	110.9	106.5	109.75	3161523	3446.34	25777	1091443	34.52
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NOCIL	109.75	110	115.3	109.65	110.95	4166478	4709.58	28408	1265560	30.37


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