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)	AARTIIND	994.15	993.95	1016.25	989.05	1002.9	391576	3920.4	14800	131394	33.560001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIIND	1002.9	1038	1038	978.05	999.85	2266844	22731.35	84595	476788	21.030000686645508
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIIND	999.85	1005	1013.75	960.4	979.3	916502	9012.42	42854	240721	26.270000457763672
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIIND	979.3	985	1015.15	985	1009.75	709530	7106.36	28727	314777	44.36000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIIND	1022.2	1010	1013.4	985	987.65	540473	5389.34	20543	224171	41.47999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIIND	1009.75	1013.6	1027	1009.5	1022.2	700879	7150.49	24539	328577	46.880001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIIND	1010.55	1010.55	1018.5	989	994.15	372140	3740.87	16172	133016	35.7400016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIIND	830.75	836	843	831.1	837.8	87969	736.51	2841	66232	75.29
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIIND	837.8	840	845	838.15	840.25	85373	717.29	7202	66666	78.09
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AARTIIND	840.25	844.8	844.8	834	840.7	91994	773.19	8510	69349	75.38


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