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)	APOLLOTYRE	224.95	220.2	230.5	220.2	223.8	5753713	12999.87	47614	805160	13.989999771118164
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOTYRE	223.8	220	226.5	219.1	224.1	5218368	11642.53	51644	866067	16.600000381469727
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOTYRE	224.1	225.45	227.25	221	224.95	2405339	5382.67	20090	253221	10.529999732971191
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOTYRE	224.95	226.5	228.8	225	227.65	2082831	4731.92	16412	397234	19.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOTYRE	226.65	224.7	226.45	218.95	219.5	2542780	5650.85	23641	535857	21.06999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOTYRE	227.65	228	229.15	226.2	226.65	1680142	3819.89	16922	384399	22.8799991607666
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOTYRE	225.35	217.05	228.9	215.85	224.95	12257995	27440.69	89151	953042	7.769999980926514
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOTYRE	163.9	164.5	164.95	163	163.35	642850	1052.36	5110	103848	16.15
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOTYRE	163.35	163.7	170.9	163.35	170.35	2954927	4947.27	17851	1089006	36.85
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOTYRE	170.35	169.8	169.8	164	165.15	2231107	3711.46	14759	414286	18.57


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