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)	HEIDELBERG	227.5	227.5	230.6	227.5	228.05	48747	111.69	2225	26240	53.83000183105469
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEIDELBERG	228.05	229.55	232	224	227.9	107148	243.82	6244	35354	33
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEIDELBERG	227.9	228	229.05	217.6	220.8	386194	852.16	12519	112947	29.25
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEIDELBERG	220.8	218	219.95	215.05	215.8	163982	355.77	5245	84500	51.52999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEIDELBERG	214.8	214	216.95	211	212.65	126790	269.09	6778	67487	53.22999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEIDELBERG	215.8	215.15	215.9	212.15	214.8	90902	194.71	5550	51357	56.5
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEIDELBERG	231.35	231.35	233.65	226.6	227.5	77759	178.37	3443	45624	58.66999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEIDELBERG	174.95	175.85	176.95	174.5	174.95	127196	222.91	2648	82433	64.81
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEIDELBERG	174.95	175.4	184.4	175.15	182.25	962061	1748.04	7963	476054	49.48
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEIDELBERG	182.25	183.45	184.8	182	183.65	405570	743.79	3589	298799	73.67


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