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)	HINDUNILVR	2298.15	2306	2312.75	2283	2306.6	1014561	23322.97	74364	608295	59.959999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDUNILVR	2306.6	2295.25	2316.7	2237	2257.6	1207402	27316.85	112445	734718	60.84999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDUNILVR	2257.6	2268	2268	2246.55	2264.35	1190660	26886.34	84586	759625	63.79999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDUNILVR	2264.35	2267.55	2280.35	2255.6	2277.65	1049611	23819.96	50217	733048	69.83999633789062
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDUNILVR	2283.15	2279	2279	2249	2258	2100036	47502.43	122702	1552468	73.93000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDUNILVR	2277.65	2280	2285	2255.85	2283.15	1195100	27178	91393	830166	69.45999908447266
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDUNILVR	2327.9	2329	2331.95	2290	2298.15	1448039	33379.06	83117	1002903	69.26000213623047
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDUNILVR	1923	1930	1939.9	1918	1936.55	543035	10493.23	26908	238901	43.99
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDUNILVR	1936.55	1940	1952.6	1930	1938.05	663275	12863.86	65620	353768	53.34
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDUNILVR	1938.05	1937.9	1940	1918.75	1927.45	1598825	30801.89	85043	1117706	69.91


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