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)	IRCON	45.45	45.65	45.65	45	45.1	870620	394.17	5465	553771	63.61000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCON	45.1	45.15	45.45	44.75	44.9	895300	403.42	6561	607788	67.88999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCON	44.9	45	45.3	44.2	44.65	1137646	507.5	7792	652935	57.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCON	44.65	44.85	45.15	44.65	45	613064	275.61	4663	388201	63.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCON	45.1	44.8	45.15	44.75	44.8	912089	410.02	5227	573870	62.91999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCON	45	45	45.5	44.8	45.1	946585	427.11	6021	509087	53.77999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCON	45.85	46	46.1	45.35	45.45	781532	356.95	5687	491476	62.88999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCON	401.95	407	415.9	404.95	412.2	86177	353.37	1858	43195	50.12
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCON	412.2	413	434	413	427.9	286974	1228.46	9540	113524	39.56
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IRCON	427.9	429	431.9	420	424.8	133679	571.26	3409	82851	61.98


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