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)	IFBIND	967.4	972.25	990	969.25	981.55	27953	274.68	2166	16756	59.93999862670898
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IFBIND	981.55	1015.55	1015.55	952.1	961.4	31277	306.2	2036	11955	38.220001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IFBIND	961.4	961.4	979.5	945	958.3	12253	117.62	1407	4817	39.310001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IFBIND	958.3	960	970.3	943	946.15	11296	107.4	1408	4999	44.25
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IFBIND	941.45	940	940	908.55	917.8	18472	170.38	1856	8152	44.130001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IFBIND	946.15	950	950	932.7	941.45	12754	119.9	1374	5603	43.93000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IFBIND	973.7	977	995	965	967.4	36854	359.9	3195	20267	54.9900016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IFBIND	668.7	669.05	682	665	669.35	5025	33.8	423	2614	52.02
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IFBIND	669.35	677.25	681.1	670	673.4	6335	42.85	512	3528	55.69
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IFBIND	673.4	674	733	673.4	696.85	57434	406.26	3838	12329	21.47


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