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)	FORTIS	268.5	268.6	270.35	263.9	264.8	633499	1686.21	8082	291505	46.02000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FORTIS	264.8	263.95	266.55	261.3	263.6	1046332	2749.38	10266	460906	44.04999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FORTIS	263.6	264.9	265.9	257.75	260.85	851145	2222.71	10348	366113	43.0099983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FORTIS	260.85	262.05	263.7	258	258.6	657786	1709.13	9695	375377	57.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FORTIS	261.9	256	260.5	254.7	259.2	788664	2036.06	10702	378716	48.02000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FORTIS	258.6	260	263.2	255.25	261.9	1676825	4328.99	17029	1137231	67.81999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FORTIS	277.65	277.5	277.5	268	268.5	1119001	3024.56	14164	517933	46.290000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FORTIS	131.9	132.4	133.4	131.3	132.95	199669	264.74	2541	113531	56.86
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FORTIS	132.95	133.45	136.35	132.55	134.15	637088	854.96	4173	402988	63.25
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FORTIS	134.15	133.6	136	133.4	135.05	659414	891.21	9083	400828	60.79


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