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)	CCL	500.2	495.45	508.5	491.2	500.8	693906	3454.11	23190	269591	38.84999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CCL	500.8	503.55	504	476.35	480.65	387398	1894.21	13783	154314	39.83000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CCL	480.65	483.3	484.45	465	469.95	289856	1370.12	11946	70301	24.25
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CCL	469.95	475	489.9	474.2	485.2	376117	1813.38	20326	106266	28.25
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CCL	477.15	474.8	480	467.45	475.45	212856	1011.38	11049	64964	30.520000457763672
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CCL	485.2	489.1	496.8	470.3	477.15	340355	1653.38	11941	91858	26.989999771118164
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CCL	510.1	508.7	510.4	486.55	500.2	1145713	5728.17	30315	352699	30.780000686645508
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CCL	201.3	202.9	204.7	198	200.7	18611	37.71	764	8749	47.01
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CCL	200.7	200.1	200.1	196.2	199	37355	74.02	1581	25893	69.32
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CCL	199	198.7	204	198.05	198.95	658098	1318.39	2023	644733	97.97


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