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)	VINATIORGA	1923.7	1921.9	1924.95	1894	1900.2	34020	649.71	5994	21219	62.369998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VINATIORGA	1900.2	1913	1950	1891.55	1943.8	42564	818.11	6331	22985	54
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VINATIORGA	1943.8	1943	1984	1910.75	1932.1	23691	460.34	4259	9041	38.15999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VINATIORGA	1932.1	1932	1947.65	1913.8	1925.95	9614	185.67	1949	5244	54.54999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VINATIORGA	1921.8	1905	1929	1898.15	1907.65	10306	197.04	2420	4344	42.150001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VINATIORGA	1925.95	1925.95	1934.5	1907.65	1921.8	8065	154.97	2131	3785	46.93000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VINATIORGA	1948	1950.55	1954.15	1915	1923.7	28833	557.36	5274	14790	51.29999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VINATIORGA	1983.8	1957.8	2009	1950.1	1963	26412	524.54	3740	14880	56.34
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VINATIORGA	1963	1976.6	1984.35	1952	1959.7	88281	1741.98	2271	83036	94.06
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VINATIORGA	1959.7	1966	1995.25	1940.5	1982	21231	419.47	2819	11464	54


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