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)	NESTLEIND	18306.6	18400	18400	18202.8	18331.65	44924	8231.9	15444	26945	59.97999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	18331.65	18331.65	18420	17911	18072.75	48469	8756.77	17590	24478	50.5
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	18072.75	18205	18214.25	17990	18087.15	39385	7117.76	15260	23278	59.09999847412109
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	18087.15	18090	18237.15	18021.45	18135.05	48243	8739.21	16014	31754	65.81999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	18139.85	18135	18135	17620	17815.2	95980	17025.53	31410	62558	65.18000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	18135.05	18101	18212.9	18010	18139.85	50422	9132.86	17146	33118	65.68000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	18500.65	18420	18579.65	18261.1	18306.6	34354	6299.68	14607	17789	51.77999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	14785.35	14819	14849.35	14712.25	14779.05	23859	3525.05	5858	6540	27.41
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	14779.05	14848.9	14852.95	14687.15	14729.35	46116	6798.66	12734	26831	58.18
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NESTLEIND	14729.35	14750	14795	14556.1	14593.6	40000	5849.64	12777	19845	49.61


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