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)	NILKAMAL	2366.1	2377.95	2384.9	2341.2	2351.8	1432	33.84	492	664	46.369998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NILKAMAL	2351.8	2325.05	2347.1	2291	2319.4	2285	52.94	802	1090	47.70000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NILKAMAL	2319.4	2310	2326	2256.25	2291.25	2703	61.66	1084	1684	62.29999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NILKAMAL	2291.25	2292.55	2338.95	2285	2311.8	2774	64.08	779	1092	39.369998931884766
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NILKAMAL	2317.25	2328	2334	2231.15	2246.95	4236	96.29	924	2099	49.54999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NILKAMAL	2311.8	2312.15	2375	2225.05	2317.25	11029	251.72	2292	1536	13.93000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NILKAMAL	2434.95	2447.15	2451.9	2351.05	2366.1	2801	67.15	742	1446	51.619998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NILKAMAL	1303.9	1317	1317	1287	1297.35	7346	95.43	1033	3278	44.62
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NILKAMAL	1297.35	1297.35	1339	1285	1326.45	14756	195.19	1879	9372	63.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NILKAMAL	1326.45	1326.45	1337.95	1300.9	1306.45	8866	116.36	837	3889	43.86


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