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)	EPL	193.15	193.15	193.15	189.1	189.65	702424	1334.83	2951	645275	91.86000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EPL	189.65	189.7	191.9	186.35	186.85	125540	235.35	5172	80599	64.19999694824219
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EPL	186.85	187.2	189.8	185.25	187.1	84925	159.38	3166	30785	36.25
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EPL	187.1	187.9	191	186	186.85	78227	146.38	5807	39691	50.7400016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EPL	179.7	179.5	181	173.4	174.35	246604	433.42	7981	145987	59.20000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EPL	186.85	184.15	185.7	179.05	179.7	436514	791.96	12311	307485	70.44000244140625
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EPL	196.6	197.7	197.7	192.65	193.15	68583	133.59	3630	39263	57.25
Mon Oct 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EPL	253.75	253.75	258.3	250.75	255.2	87350	222.72	2006	62088	71.08
Tue Oct 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EPL	255.2	256	265.3	254.3	261.8	397703	1039.34	7760	254397	63.97
Wed Oct 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EPL	261.8	261	264	258	259	162667	424.32	5315	98163	60.35


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