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)	APOLLOHOSP	4642.8	4640	4794	4601.75	4687.9	829635	39100.92	65409	229132	27.6200008392334
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOHOSP	4687.9	4687.4	4724.55	4450.05	4475.15	597040	27134.01	51135	205322	34.38999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOHOSP	4475.15	4497.5	4529.7	4380	4399.5	628869	28104.43	43825	223233	35.5
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOHOSP	4399.5	4514.7	4587	4430.05	4577.25	842211	38281.74	62164	356516	42.33000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOHOSP	4590.65	4610	4613.45	4476.45	4514.9	572726	25899.6	37029	183718	32.08000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOHOSP	4577.25	4576.05	4623	4528.1	4590.65	487802	22331.37	51815	180971	37.09999847412109
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOHOSP	4666.3	4667.95	4704.75	4602.8	4642.8	777217	36046.87	81265	414983	53.38999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOHOSP	1442	1440	1442	1422.2	1426.35	268255	3833.54	8723	35752	13.33
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOHOSP	1426.35	1428	1509.2	1428	1494.65	2000143	29699.65	67435	406711	20.33
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	APOLLOHOSP	1494.65	1494.65	1505	1481.55	1486.1	629443	9393.64	20969	70408	11.19


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