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)	JUBLPHARMA	524.35	524.9	531.9	521.5	526.55	81163	426.77	4533	38725	47.709999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLPHARMA	526.55	479	495	473.05	489.2	644314	3137.35	25829	296895	46.08000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLPHARMA	489.2	492	498.5	468.05	470.75	293939	1404.79	14629	150213	51.09999847412109
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLPHARMA	470.75	474.95	476.9	462.4	464.6	168711	787.42	8239	83749	49.63999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLPHARMA	466.05	466.05	466.5	454.7	461.25	155939	717.62	6929	85309	54.709999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLPHARMA	464.6	464.6	475	464	466.05	131505	617.06	6589	57192	43.4900016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLPHARMA	528.6	529.85	534.4	520.7	524.35	60946	321.88	3772	39434	64.69999694824219
Fri Feb 12 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLPHARMA	903.6	900	912	885	892.9	36229	324.29	1935
Mon Feb 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLPHARMA	892.9	892.9	905	850	854.75	53356	461.41	3051
Tue Feb 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBLPHARMA	854.75	868.85	868.85	830.05	843.45	31668	266.89	1633


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