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)	BALKRISIND	2333.55	2344.1	2345.2	2276.4	2290.5	75715	1743.09	10835	20344	26.8700008392334
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALKRISIND	2290.5	2298.9	2304.85	2236	2245.2	67721	1530.46	11242	20042	29.59000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALKRISIND	2245.2	2262.8	2279.9	2224.75	2246.15	95043	2135.49	16798	33979	35.75
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALKRISIND	2246.15	2259.9	2298.5	2246.4	2293.5	80941	1844.8	9880	28882	35.68000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALKRISIND	2271.35	2250	2257.85	2166	2179.05	230260	5063.09	36137	92074	39.9900016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALKRISIND	2293.5	2309.7	2309.9	2248.5	2271.35	140576	3192.91	18492	61277	43.59000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALKRISIND	2320.75	2280.05	2355	2280.05	2333.55	148853	3481.25	18676	48687	32.709999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BALKRISIND	990.55	991.85	997	985	987.25	276090	2735.31	5895	27971	10.13
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BALKRISIND	987.25	987.25	989.7	974	978.6	745960	7310.37	12732	448915	60.18
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BALKRISIND	978.6	979	983.5	968.6	971.7	410943	3999.09	6232	248048	60.36


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