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)	GUJALKALI	741.2	747.8	754	731.55	744	289199	2152.84	12614	93041	32.16999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJALKALI	744	740.6	769.7	737	756.25	806776	6115.87	30277	260764	32.31999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJALKALI	756.25	762.2	808	732.2	776.4	2922029	22898.73	103841	537717	18.399999618530277
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJALKALI	776.4	784.9	792	751	755.5	631876	4858.72	22824	189232	29.950000762939453
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJALKALI	778.6	765	779.7	742.2	748.05	425569	3240.01	17714	143282	33.66999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJALKALI	755.5	757	792	744.9	778.6	1087019	8422.94	36486	226955	20.8799991607666
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJALKALI	721.9	724.9	759.9	722.05	741.2	911502	6805.59	33635	228828	25.100000381469727
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJALKALI	418.5	418.5	422.2	415	417.5	18363	77.04	1044	8700	47.38
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJALKALI	417.5	421.85	431.05	416.05	426.85	53589	227.72	2420	28645	53.45
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJALKALI	426.85	429.5	442	427	431.4	53584	232.56	3179	29332	54.74


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