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)	HINDCOPPER	129.35	130	138.5	129.5	137.7	17477979	23623.47	72721	5040278	28.84000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDCOPPER	137.7	137.6	143	135.4	141.45	16060563	22569.51	75732	4904893	30.540000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDCOPPER	141.45	142.2	143.7	134.15	137.1	9982439	13793.2	45666	2393267	23.96999931335449
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDCOPPER	137.1	138.2	141.65	137.4	139.35	5956235	8301.43	25811	1913240	32.119998931884766
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDCOPPER	142.25	141	143.55	137.5	138.85	6485085	9131.51	31289	1780226	27.450000762939453
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDCOPPER	139.35	140.5	146.35	140.5	142.25	16068827	23135.25	75696	5119197	31.86000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDCOPPER	127.65	128.35	130.4	127.45	129.35	5622216	7252.36	22255	2059240	36.630001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDCOPPER	39.25	39.4	40.85	39.25	40.45	1800482	721.09	4982	830394	46.12
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDCOPPER	40.45	40.85	48.5	40.75	48.5	18450531	8653.7	49889	5262726	28.52
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDCOPPER	48.5	50	51	46.2	46.75	9379034	4494.16	27029	2919922	31.13


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