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)	LICHSGFIN	399.15	400.95	403.55	393.85	394.85	3262801	13018.58	39565	777184	23.81999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LICHSGFIN	394.85	393	398.85	386.1	388.95	3070642	12007.03	39397	683106	22.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LICHSGFIN	388.95	390.75	395	378.95	387.65	2912240	11272.16	39572	348532	11.970000267028809
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LICHSGFIN	387.65	391.8	393.35	386.15	391.85	2142290	8365.55	31541	462545	21.59000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LICHSGFIN	403.15	403.15	406.45	389	390.65	4343501	17304.87	53069	923372	21.26000022888184
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LICHSGFIN	391.85	393.9	408	391.6	403.15	5990222	24069.69	79159	1523269	25.43000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LICHSGFIN	403.6	405.2	405.5	397.35	399.15	3509709	14049.49	42330	1135417	32.349998474121094
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LICHSGFIN	434.15	436	438.45	430.4	431.8	1472079	6377.35	13828	285683	19.41
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LICHSGFIN	431.8	433.9	457.75	432.65	456.25	4129562	18490.98	45873	937263	22.7
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LICHSGFIN	456.25	456	456	437.55	439.4	2964293	13156.11	39197	709810	23.95


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