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)	WESTLIFE	497.45	521	526	492.9	496.75	998394	5037.18	26501	544492	54.540000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WESTLIFE	496.75	491.25	500	471.5	477.3	147336	713.44	7427	65599	44.52000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WESTLIFE	477.3	481.9	487	472.9	483.2	178471	857.13	7660	137373	76.97000122070312
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WESTLIFE	483.2	488.95	494.95	484.05	487.65	82868	404.9	6249	40049	48.33000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WESTLIFE	481.65	477	479.5	471.25	474.55	117909	561.33	3419	89456	75.87000274658203
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WESTLIFE	487.65	492	492.8	477	481.65	52087	251.64	4187	23845	45.77999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WESTLIFE	492.3	495.5	510	485.55	497.45	1607950	8068.32	36368	405800	25.239999771118164
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WESTLIFE	343.2	346.45	346.7	341.75	344.75	17090	58.8	550	12760	74.66
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WESTLIFE	344.75	349	372	342.55	365.7	145132	515.4	4705	99705	68.7
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WESTLIFE	365.7	366	368	355.75	360.15	30860	111.31	2214	20945	67.87


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