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)	BHARATFORG	742.05	740	747.4	728.3	730.65	372365	2746.57	13585	74633	20.040000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATFORG	730.65	731.3	737.05	711.3	723.9	875013	6334.74	23351	183874	21.01000022888184
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATFORG	723.9	729.6	739.9	714	723.4	1610975	11714.79	37726	596411	37.02000045776367
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATFORG	723.4	733	750	726	747.9	656286	4865.56	16891	118932	18.1200008392334
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATFORG	729.9	729	757.25	716.35	732.35	3758227	27613.22	77569	894908	23.809999465942383
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATFORG	747.9	749.7	767.15	712	729.9	4738129	35076.45	114606	1113222	23.489999771118164
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATFORG	753.2	755	763	739.5	742.05	595479	4470.93	16472	141136	23.700000762939453
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATFORG	483.15	486.1	489.4	482.65	485.15	925007	4501.94	10576	134263	14.51
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATFORG	485.15	486.9	492.3	485.9	491.1	1047050	5124.85	16157	446912	42.68
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARATFORG	491.1	491	493.15	482.55	486.55	613158	2990.52	14453	253436	41.33


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