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)	CIPLA	952.75	951.25	957.75	940	946.1	1428601	13520.92	49334	679770	47.58000183105469
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	946.1	946.2	947	927.05	933.3	949273	8869.86	48087	333381	35.119998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	933.3	933.3	951	931.1	948.05	1812035	17097.62	73666	750260	41.400001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	948.05	954.8	972.5	950.25	968.25	2513281	24259.26	85538	1153624	45.900001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	975.05	956.5	976.05	953	958.5	1292417	12392.48	53838	516441	39.959999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	968.25	969	977.35	963	975.05	2044733	19896.48	93541	1150576	56.27000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	951.8	953	957	944.55	952.75	1116446	10628.96	76183	429153	38.43999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	478.2	481	481	474.45	475.9	1316812	6284.56	18642	392838	29.83
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	475.9	478.85	479.9	472.3	473.5	1406381	6689.22	23644	508693	36.17
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CIPLA	473.5	475.8	475.8	467.25	469.95	2252752	10615.92	44368	524988	23.3


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