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)	CAMS	2897.85	2880	2889.85	2802.8	2817.2	114294	3233.68	16452	54016	47.2599983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAMS	2817.2	2817	2817	2745.45	2796.95	85043	2360.31	15245	34856	40.9900016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAMS	2796.95	2796.95	2830	2681.2	2709.35	142729	3906.78	19446	73232	51.310001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAMS	2709.35	2738	2738	2636.3	2658.8	228957	6080.4	42280	130150	56.84000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAMS	2598.35	2598.35	2618.05	2520	2529.35	378618	9659.91	49834	213544	56.400001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAMS	2658.8	2680	2707.95	2580	2598.35	433245	11339.54	61150	231028	53.33000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CAMS	2901.9	2938	2938.9	2890	2897.85	280073	8122.58	19790	216097	77.16000366210938
Mon Oct 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CAMS	1401.6	1420	1489	1371	1401.4	638095	9003.13	63974	277538	43.49
Tue Oct 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CAMS	1401.4	1410	1441.85	1401.25	1419.4	542590	7705	59552	262193	48.32
Wed Oct 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CAMS	1419.4	1421	1423.65	1355.75	1381.45	283120	3930.41	28409	117207	41.4


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