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)	LAURUSLABS	532.8	535.7	536.6	525.5	529	1177855	6253.29	18387	349944	29.709999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAURUSLABS	529	527.75	538.5	521.6	528.65	2033838	10795.68	40941	706869	34.7599983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAURUSLABS	528.65	527.3	534.4	513.25	524.45	1829786	9589.35	27533	674332	36.84999847412109
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAURUSLABS	524.45	525	534	518.35	526.1	1220503	6419.82	20348	395070	32.369998931884766
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAURUSLABS	540	539.95	568	536.6	549.95	7764604	43145.13	112053	2323759	29.93000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAURUSLABS	526.1	523.1	545.9	523.1	540	3867685	20868.32	51822	1363151	35.2400016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LAURUSLABS	525.4	525.4	539.8	520.8	532.8	3358007	17826.2	38770	1054296	31.39999961853028
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LAURUSLABS	359.75	358	370.95	358	368.25	33755	123.49	1169	22931	67.93
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LAURUSLABS	368.25	370	377.7	368.25	373.65	62173	232.44	1842	32966	53.02
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LAURUSLABS	373.65	370	391.45	370	379.85	157970	605.06	4608	72827	46.1


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