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)	KPITTECH	621.8	624	630.45	615	623.5	1092654	6803.15	55931	506019	46.310001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPITTECH	623.5	626.65	638	621	626.8	1483326	9314.52	65130	818416	55.16999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPITTECH	626.8	629.7	631.9	605.5	613.9	1260852	7765.96	60496	669365	53.09000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPITTECH	613.9	615.2	622.9	602	606.7	1129625	6897.68	52394	613727	54.33000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPITTECH	608.35	596	603.35	576.5	578.2	1717365	10063.79	97557	961541	55.9900016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPITTECH	606.7	609	612	600.5	608.35	867617	5267.66	36302	386614	44.560001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KPITTECH	629.65	631.7	635	620.15	621.8	1211245	7581.75	69653	644642	53.220001220703125
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KPITTECH	93.7	92.75	93.7	91.05	91.45	83742	77.03	1171	60396	72.12
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KPITTECH	91.45	93	93	89	89.35	379118	345.28	1405	347711	91.72
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KPITTECH	89.35	89.45	93.4	89.45	91.25	85097	77.92	1778	46852	55.06


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