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)	JYOTHYLAB	142.2	143.6	143.6	139	139.8	206789	290.93	3963	109344	52.880001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JYOTHYLAB	139.8	140.05	141	138.05	139.9	220620	307.58	4429	119728	54.27000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JYOTHYLAB	139.9	140.6	140.8	138.25	139.95	188530	263.05	4001	81181	43.060001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JYOTHYLAB	139.95	140.85	141.6	139.15	140.8	189712	267.3	4060	92984	49.0099983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JYOTHYLAB	139.25	139.95	139.95	137.6	138.15	105041	145.67	2255	55157	52.5099983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JYOTHYLAB	140.8	140.8	140.95	138.3	139.25	119854	167.44	2027	72852	60.77999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JYOTHYLAB	140.9	141.4	144	140.9	142.2	334680	478.52	9846	137769	41.15999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JYOTHYLAB	147	148.2	149.9	147	148.65	135660	200.76	1682	78620	57.95
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JYOTHYLAB	148.65	151.1	152.6	149.2	151.1	259165	390.73	6019	113966	43.97
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JYOTHYLAB	151.1	151.9	151.9	150	150.65	121589	183.57	3489	60677	49.9


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