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)	NFL	55.2	56.45	56.45	54.95	55.1	843432	468.35	7028	296590	35.15999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NFL	55.1	55	56.15	54.7	54.95	757969	419.3	3932	285077	37.61000061035156
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NFL	54.95	55.15	55.3	53.3	53.85	486062	262.8	3974	143970	29.6200008392334
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NFL	53.85	54.15	54.5	53.6	53.85	343310	185.06	2762	163710	47.68999862670898
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NFL	54	53.5	55.2	53.25	53.7	1207480	655.91	9520	257837	21.350000381469727
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NFL	53.85	53.9	54.75	53.5	54	394977	212.97	3001	176870	44.77999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NFL	55.9	56.2	56.2	54.9	55.2	516107	287.02	3013	281272	54.5
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NFL	26	26.2	26.4	25.9	26.2	179370	46.86	601	108685	60.59
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NFL	26.2	26.2	27.4	26.2	27.1	831311	224.26	2378	429454	51.66
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NFL	27.1	26.85	27.6	26.75	26.9	570010	154.97	2321	198819	34.88


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