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)	PNBHOUSING	440.1	441	454.2	436.8	437.95	293708	1302.25	6529	132713	45.18999862670898
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNBHOUSING	437.95	445	449.9	428	430.8	230811	1010.23	6050	109498	47.43999862670898
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNBHOUSING	430.8	428.2	435.3	415.5	420.75	178930	758.63	6978	71390	39.900001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNBHOUSING	420.75	422.4	428.65	421.2	423.6	90091	381.5	3344	46668	51.79999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNBHOUSING	428.9	426	427	417.65	418.4	118739	500	3565	68620	57.790000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNBHOUSING	423.6	425.9	439.15	422.3	428.9	234590	1010.34	5316	129368	55.150001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNBHOUSING	446	446	452	432.85	440.1	278831	1233.4	6335	97011	34.790000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PNBHOUSING	434.2	435.7	449	433.2	445.05	420916	1857.03	10560	143376	34.06
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PNBHOUSING	445.05	450.8	499.5	449.9	492.2	4971019	24286.33	78724	549193	11.05
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PNBHOUSING	492.2	488.9	493.75	472.5	485.35	1462390	7057.2	27965	167726	11.47


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