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)	COLPAL	1470.35	1471	1477.8	1451.85	1455.1	380906	5552.43	15948	265242	69.62999725341797
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COLPAL	1455.1	1455.1	1466.25	1433	1437.15	224018	3226.69	14871	138735	61.93000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COLPAL	1437.15	1438	1444.9	1431.05	1438.6	180086	2589.96	12877	108851	60.43999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COLPAL	1438.6	1447	1469.95	1441	1464.95	567872	8264.37	13691	459829	80.97000122070312
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COLPAL	1458.85	1455	1464	1442.05	1455.5	164776	2393.82	12483	82535	50.09000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COLPAL	1464.95	1463.9	1468.95	1448	1458.85	238551	3474.73	28539	128614	53.90999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COLPAL	1461.75	1461	1473.75	1445	1470.35	386232	5630.31	45002	224752	58.18999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COLPAL	1462.9	1455.65	1470	1454.05	1461.1	184535	2697.81	9318	89529	48.52
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COLPAL	1461.1	1466.9	1466.9	1454.25	1459.9	224986	3282.93	15748	133811	59.48
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COLPAL	1459.9	1463	1474.95	1457	1460	471643	6911.41	26134	258066	54.72


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