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)	CGCL	580.55	578	584.9	565	574.6	75743	434.09	6155	28032	37.0099983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGCL	574.6	599	619	580.15	590.1	345310	2086.02	16383	100588	29.1299991607666
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGCL	590.1	589.9	594.4	575.15	579.2	39313	229.44	3955	15593	39.65999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGCL	579.2	579.9	593.5	576.15	579.4	42063	245.84	5861	11176	26.56999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGCL	576.9	576.9	583.7	571.15	574.4	38608	223.19	4209	17095	44.27999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGCL	579.4	582.3	586.6	575	576.9	25525	147.65	2293	11989	46.970001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CGCL	598.3	599.4	604.9	570.05	580.55	108805	643.82	8322	36229	33.29999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CGCL	202.7	203.5	204.8	200.15	203.6	315157	635.99	4762	23066	7.32
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CGCL	203.6	203.8	203.95	201.1	202.2	311115	629.59	4153	24440	7.86
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CGCL	202.2	201.9	203	199	199.75	253940	509.41	4161	27411	10.79


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