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)	UTIAMC	890	890	890	834.35	842.25	845960	7213.18	53934	566687	66.98999786376953
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIAMC	842.25	865	874	815.25	827	463795	3893.21	18882	296101	63.84000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIAMC	827	829.95	846	809.15	819.9	285189	2326.31	17100	186487	65.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIAMC	819.9	810	839.6	809.95	824.3	260726	2142.73	34114	168305	64.55000305175781
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIAMC	888.5	876	909	870	898.7	192949	1728.65	20354	66709	34.56999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIAMC	824.3	844	897.9	832	888.5	445559	3888.09	33626	154643	34.709999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIAMC	881.6	884	893	876	890	112923	1001.03	10496	73508	65.0999984741211
Mon Oct 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIAMC	554	500	529.95	471.1	476.2	10808276	54742.1	428887	5403693	50
Tue Oct 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIAMC	476.2	477.9	517.5	477	514.5	3544992	17808.92	112115	1262863	35.62
Wed Oct 14 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UTIAMC	514.5	517.9	517.9	500.2	509.1	766545	3898.15	38227	258799	33.76


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