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)	NH	642.65	642.65	659.9	635	645.5	123614	795.82	9225	54289	43.91999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	645.5	659	679	644	660.85	360183	2368.64	19980	131801	36.59000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	660.85	673.9	675	641	656.95	165725	1080.14	20824	66514	40.13999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	656.95	665.95	666.9	637.55	640.75	99086	643.03	8466	55492	56
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	649.2	645	662	638	646.85	232853	1498.21	11746	154237	66.23999786376953
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	640.75	645.45	652.9	641	649.2	78899	509.91	5612	30333	38.45000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	633.9	640	650	634.75	642.65	125507	808.04	10928	60262	48.0099983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	307.3	309.6	331.8	306.3	326	775112	2505.5	23768	236770	30.55
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	326	329	333	321.3	329.75	226542	741.21	6804	95487	42.15
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	329.75	333	340.25	325.25	328.35	418178	1395.79	18600	176438	42.19


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