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)	CEATLTD	1098.7	1100	1110.85	1074.2	1077.25	84294	915.25	7307	34195	40.56999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CEATLTD	1077.25	1078	1086.4	1072.35	1082.5	49222	531.29	4240	18011	36.59000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CEATLTD	1082.5	1082.5	1090.25	1068	1078.15	39086	421.46	4934	14167	36.25
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CEATLTD	1078.15	1083.55	1085.2	1073.1	1080.25	22464	242.48	3275	9147	40.720001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CEATLTD	1064.25	1058	1072.95	1055	1061.9	44221	470.87	5287	15364	34.7400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CEATLTD	1080.25	1085.7	1087.35	1060	1064.25	43493	466.03	4808	21671	49.83000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CEATLTD	1095.3	1065.1	1110	1062.05	1098.7	173061	1882.28	13448	24561	14.1899995803833
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CEATLTD	988.85	991.95	999	988	996.35	44293	440.23	2258	12947	29.23
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CEATLTD	996.35	1000	1044.9	995	1031.85	308369	3136.57	8583	134300	43.55
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CEATLTD	1031.85	1031.85	1052.85	1014.35	1021.85	191652	1985	7972	38151	19.91


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