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)	PNB	42.6	42.5	42.9	41.35	41.5	57040478	23967.96	66383	10647884	18.670000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNB	41.5	41.5	43	41.3	41.7	94193766	39766.78	106194	14258440	15.140000343322754
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNB	41.7	41.9	42.2	40.55	42	82898920	34397.89	81632	7702586	9.289999961853027
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNB	42	42.1	42.2	41.3	41.6	36405347	15172.2	46673	5533949	15.199999809265137
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNB	40.8	40.6	40.75	39.6	39.75	38771131	15559.79	57013	11389576	29.3799991607666
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNB	41.6	41.7	41.8	40.7	40.8	34712483	14314.63	52358	10604220	30.549999237060547
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PNB	42.8	42.9	43.35	42.35	42.6	85013403	36482.69	111669	21085278	24.799999237060547
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PNB	64.35	64.5	65.05	63.95	64.7	8568946	5524.66	21453	1022635	11.93
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PNB	64.7	65	67	64.55	66.7	26059066	17239.48	51834	4549023	17.46
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PNB	66.7	66.55	66.55	64.6	65.05	14906983	9758.59	31813	2386870	16.01


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