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)	NAVINFLUOR	4122.15	4163.05	4259.95	4111.3	4136.75	300633	12581.38	33960	60530	20.1299991607666
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAVINFLUOR	4136.75	4156.7	4156.7	4008.2	4033.45	98773	4030.91	12950	25970	26.290000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAVINFLUOR	4033.45	4034	4075.6	3930.15	4045.65	101908	4090.85	12706	19859	19.489999771118164
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAVINFLUOR	4045.65	4100	4116.95	4025	4037.55	128963	5224.78	9873	73169	56.7400016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAVINFLUOR	4091.2	4069.95	4069.95	3921.65	3937.7	101320	4028.53	12226	35275	34.81999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAVINFLUOR	4037.55	4049	4110.5	4006.1	4091.2	77212	3137.92	8377	29170	37.77999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAVINFLUOR	4227.75	4225	4225	4101.05	4122.15	178138	7379.51	17934	55786	31.31999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NAVINFLUOR	1006.95	1009	1009	995.75	1003.2	35812	359.72	3095	21968	61.34
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NAVINFLUOR	1003.2	1006.45	1010	999.55	1005.65	30113	302.84	1921	22929	76.14
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NAVINFLUOR	1005.65	999	1014.9	992	999.35	26837	268.61	2308	11318	42.17


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