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)	EXIDEIND	173.55	174.3	175.3	170.55	171.15	3406622	5885.92	30114	1998559	58.66999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EXIDEIND	171.15	170.5	171.15	166.5	167	3368057	5656.63	55399	1541720	45.77000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EXIDEIND	167	168.3	169.25	165.25	166.55	3906146	6511.77	36213	2087370	53.43999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EXIDEIND	166.55	167.4	168	166.4	167.25	2270689	3795.85	32010	1192997	52.540000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EXIDEIND	166.3	165.55	166.6	163.15	163.75	2377545	3917.67	28005	1265647	53.22999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EXIDEIND	167.25	167.7	167.75	165.7	166.3	2019215	3363.17	22672	1076671	53.31999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EXIDEIND	175.05	175.05	176.35	173.1	173.55	1537584	2684.44	24495	576444	37.4900016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EXIDEIND	186.5	186.9	186.9	184.25	186	619586	1150.74	6317	159890	25.81
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EXIDEIND	186	186.7	189.9	185.35	189.1	1061353	2002.77	12016	400042	37.69
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EXIDEIND	189.1	188.8	188.9	182	184.1	1347418	2498.43	13235	495130	36.75


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