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)	SHRIRAMCIT	1823.25	1822.9	1827.65	1768.85	1778.7	21547	386.77	3664	7129	33.09000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHRIRAMCIT	1778.7	1780	1798.15	1743.1	1754.15	33135	585.59	5727	14954	45.130001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHRIRAMCIT	1754.15	1762.95	1794.95	1730	1785.45	32667	577.8	4486	18646	57.08000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHRIRAMCIT	1785.45	1793	1806.65	1775.75	1788.8	14985	268.83	1477	7905	52.75
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHRIRAMCIT	1822.9	1806.3	1814.2	1765	1774.35	14410	257.38	1585	3593	24.93000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHRIRAMCIT	1788.8	1790	1838.65	1772.65	1822.9	18516	336.96	1866	10291	55.58000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SHRIRAMCIT	1858.2	1847	1850	1815.8	1823.25	17269	316.42	2214	3262	18.88999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHRIRAMCIT	1402.2	1402.2	1405	1365	1378.2	614	8.52	137	351	57.17
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHRIRAMCIT	1378.2	1404.4	1435	1375	1385.85	1313	18.4	423	782	59.56
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SHRIRAMCIT	1385.85	1427	1569.95	1415.95	1430.65	37341	552.59	5657	12690	33.98


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