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)	COCHINSHIP	342.35	342.85	344.9	339	339.75	101352	345.58	4957	64612	63.75
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COCHINSHIP	339.75	340.9	344.95	338.5	339.6	74876	254.94	3354	39138	52.27000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COCHINSHIP	339.6	340.9	344.9	335.1	339.75	125416	424.54	5570	52305	41.709999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COCHINSHIP	339.75	339.85	341.7	338.05	339.5	44738	151.95	2008	24706	55.220001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COCHINSHIP	340.85	334.1	336.35	328.4	329	330026	1094.33	14710	200835	60.84999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COCHINSHIP	339.5	340.9	342.65	339.15	340.85	63693	217.28	3006	37498	58.869998931884766
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COCHINSHIP	344.65	346	347.2	339.8	342.35	111382	381.61	4813	57824	51.91999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COCHINSHIP	402.85	404.9	405.45	400	403.05	32077	129.12	1294	18188	56.7
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COCHINSHIP	403.05	404	411.9	401.1	409.35	81809	333.58	2663	44249	54.09
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COCHINSHIP	409.35	410.95	412	404	408.5	45866	187.05	3222	25314	55.19


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