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)	PVR	1598.9	1600	1618	1592	1608.6	497604	7998.82	17824	77659	15.609999656677246
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PVR	1608.6	1608	1642	1587.35	1604.6	881513	14217.8	31946	139389	15.8100004196167
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PVR	1604.6	1611.7	1631.35	1588	1618.15	795181	12814	32378	146195	18.38999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PVR	1618.15	1635.8	1663	1606	1647.8	1195996	19577.9	44586	258620	21.6200008392334
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PVR	1669.75	1665.8	1674.9	1615.6	1620.55	620521	10211.6	23912	97598	15.729999542236328
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PVR	1647.8	1657.8	1681.4	1645.35	1669.75	660553	10991.5	29170	185715	28.1200008392334
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	PVR	1600.95	1609	1618	1586.95	1598.9	541711	8675.87	21634	111257	20.540000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PVR	1898.4	1907	1910.25	1881.1	1900	297304	5632.73	10441	48139	16.19
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PVR	1900	1900	1913.95	1871.25	1879.35	668647	12651.09	19268	252009	37.69
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	PVR	1879.35	1875	1884.85	1862.7	1875.15	253822	4754.22	10442	46366	18.27


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