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)	CERA	4496.4	4525	4591	4485	4537.85	11317	512.87	3308	5588	49.380001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CERA	4537.85	4599	4634.9	4505.2	4565.75	11217	512.14	3552	5913	52.709999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CERA	4565.75	4588.6	4648	4520	4578.45	4820	220.71	2379	2240	46.470001220703125
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CERA	4578.45	4597.75	4606	4484.9	4506.5	6114	278.03	2586	3033	49.61000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CERA	4488.45	4470	4495	4412	4424.65	3670	163.36	1779	2123	57.84999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CERA	4506.5	4529.05	4593.95	4455.2	4488.45	5804	262.5	2348	3059	52.709999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CERA	4631.05	4654.25	4680	4472	4496.4	39859	1822.26	9744	25690	64.44999694824219
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CERA	2697.55	2740.9	2740.95	2679.95	2687.5	1522	41.14	448	749	49.21
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CERA	2687.5	2749	2749	2615.3	2655.25	2071	55.37	492	1419	68.52
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CERA	2655.25	2655.25	2720	2642	2676	2062	55.3	757	1070	51.89


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