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)	GICRE	139.75	140.5	140.5	138.6	139.15	296676	413.35	3594	169950	57.27999877929688
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GICRE	139.15	139.9	139.9	136.6	137.65	237268	327.02	4092	111674	47.06999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GICRE	137.65	137.65	138.4	135.35	136.3	216466	295.63	3639	104644	48.34000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GICRE	136.3	136.8	138	135.55	137.35	211249	289.66	3557	92846	43.95000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GICRE	140	135.5	136.9	134.5	135.3	877897	1190.69	11278	470604	53.61000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GICRE	137.35	139	144.2	137.3	140	1715753	2417.18	22543	239981	13.989999771118164
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GICRE	141.55	140.5	141.6	139.15	139.75	295776	415.32	4494	127007	42.93999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GICRE	226.4	226	231.95	226	227.35	148723	339.31	2840	57596	38.73
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GICRE	227.35	228.4	251.7	227.1	245	1277175	3083.17	24447	376377	29.47
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GICRE	245	244	253.45	241	242.2	518633	1277.73	11786	133326	25.71


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