Gold Price Prediction Dataset

Prediction Of Gold Rates Using ML Techniques

@kaggle.sid321axn_gold_price_prediction_dataset

Table List

1 table(700.24 KB)

Final Uso

@kaggle.sid321axn_gold_price_prediction_dataset.final_uso

700.24 KB
1718 rows
81 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume	sp_open SP Open	sp_high SP High	sp_low SP Low	sp_close SP Close	sp_ajclose SP Ajclose	sp_volume SP Volume	dj_open DJ Open	dj_high DJ High	dj_low DJ Low	dj_close DJ Close	dj_ajclose DJ Ajclose	dj_volume DJ Volume	eg_open EG Open	eg_high EG High	eg_low EG Low	eg_close EG Close	eg_ajclose EG Ajclose	eg_volume EG Volume	eu_price EU Price	eu_open EU Open	eu_high EU High	eu_low EU Low	eu_trend EU Trend	of_price OF Price	of_open OF Open	of_high OF High	of_low OF Low	of_volume OF Volume	of_trend OF Trend	os_price OS Price	os_open OS Open	os_high OS High	os_low OS Low	os_trend OS Trend	sf_price SF Price	sf_open SF Open	sf_high SF High	sf_low SF Low	sf_volume SF Volume	sf_trend SF Trend	usb_price USB Price	usb_open USB Open	usb_high USB High	usb_low USB Low	usb_trend USB Trend	plt_price PLT Price	plt_open PLT Open	plt_high PLT High	plt_low PLT Low	plt_trend PLT Trend	pld_price PLD Price	pld_open PLD Open	pld_high PLD High	pld_low PLD Low	pld_trend PLD Trend	rho_price RHO PRICE	usdi_price USDI Price	usdi_open USDI Open	usdi_high USDI High	usdi_low USDI Low	usdi_volume USDI Volume	usdi_trend USDI Trend	gdx_open GDX Open	gdx_high GDX High	gdx_low GDX Low	gdx_close GDX Close	gdx_adj_close GDX Adj Close	gdx_volume GDX Volume	uso_open USO Open	uso_high USO High	uso_low USO Low	uso_close USO Close	uso_adj_close USO Adj Close	uso_volume USO Volume
Thu Dec 15 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	154.740005	154.949997	151.71000700000005	152.330002	152.330002	21521900	123.029999	123.199997	121.989998	122.18	105.44123799999998	199109200	11825.29004	11967.83984	11825.21973	11868.80957	11868.80957	136930000	74.550003	76.150002	72.150002	72.900002	70.43175500000002	787900	1.3018	1.2982	1.3051	1.2957	1	105.09	104.88	106.5	104.88	14330	1	93.42	94.91	96	93.33		53604	54248	54248	52316	119440	1	1.911	1.911	1.911	1.911	1	1414.65	1420.3	1423.35	1376.85		618.85	614.7	615	614.6	1	1425	80.34100000000002	80.565	80.63	80.13	22850		53.009998	53.139999	51.57	51.68	48.973877	20605600	36.900002	36.939999	36.049999	36.130001	36.130001	12616700
Fri Dec 16 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	154.309998	155.369995	153.899994	155.229996	155.229996	18124300	122.230003	122.949997	121.300003	121.589996	105.597549	220481400	11870.25	11968.17969	11819.30957	11866.38965	11866.38965	389520000	73.599998	75.099998	73.349998	74.900002	72.364037	896600	1.3035	1.3019999999999998	1.3087	1.2997	1	103.35	103.51	104.56	102.46	140080		93.79	93.43	94.8	92.53	1	53458	53650	54030	52890	65390		1.851	1.851	1.851	1.851		1420.25	1414.75	1431.75	1400.7	1	623.65	622.6	623.45	622.3	1	1400	80.249	80.175	80.395	79.935	13150		52.5	53.18	52.040001	52.68	49.921513	16285400	36.18	36.5	35.73	36.27	36.27	12578800
Mon Dec 19 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	155.479996	155.860001	154.360001	154.869995	154.869995	12547200	122.059998	122.32	120.029999	120.290001	104.468536	183903000	11866.54004	11925.87988	11735.19043	11766.25977	11766.25977	135170000	69.099998	69.800003	64.199997	64.699997	62.509384	2096700	1.2995	1.3043	1.3044	1.2981		103.64	103.63	104.57	102.37	147880	1	94.09	93.77	94.43	92.55	1	52961	53400	53400	52544	67280		1.81	1.81	1.81	1.81		1411.1	1422.65	1427.6	1404.6		608.8	626	630	608.6		1400	80.207	80.3	80.47	80.125	970		52.490002	52.549999	51.029999	51.169998	48.490578	15120200	36.389999	36.450001	35.93	36.200001	36.200001	7418200
Tue Dec 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	156.820007	157.429993	156.580002	156.979996	156.979996	9136300	122.18	124.139999	120.370003	123.93	107.629784	225418100	11769.20996	12117.12988	11768.83008	12103.58008	12103.58008	165180000	66.449997	68.099998	66	67	64.731514	875300	1.3079	1.3003	1.3133	1.2994	1	106.73	104.3	107.27	103.91	170240	1	95.55	96.39	99.7	96.39	1	53487	52795	53575	52595	55130	1	1.927	1.927	1.927	1.927	1	1434.75	1408.95	1436.55	1408.15	1	626.65	622.45	622.45	622.45	1	1400	80.273	80.89	80.94	80.035	22950	1	52.380001	53.25	52.369999	52.990002	50.215282	11644900	37.299999	37.610001	37.220001	37.560001	37.560001	10041600
Wed Dec 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	156.979996	157.529999	156.130005	157.160004	157.160004	11996100	123.93	124.360001	122.75	124.169998	107.838242	194230900	12103.58008	12119.7002	11999.44043	12107.74023	12107.74023	163250000	67.099998	69.400002	66.900002	68.5	66.180725	837600	1.3045	1.3079	1.3197	1.3024		107.71	107.15	108.17	106.16	145090	1	99.01	97.54	99.26	96.81	1	53148	53519	54184	52937	75950		1.97	1.97	1.97	1.97	1	1429.05	1434.4	1453.75	1417.65		635.9	625.7	641.5	623.8	1	1400	80.35	80.105	80.445	79.55	24140	1	53.150002	53.43	52.419998	52.959999	50.186852	8724300	37.669998	38.240002	37.52	38.110001	38.110001	10728000
Thu Dec 22 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	156.350006	156.800003	155.330002	156.03999299999995	156.03999299999995	9888400	124.629997	125.400002	124.230003	125.269997	108.793526	119465400	12107.58984	12182.70996	12107.37012	12169.65039	12169.65039	151610000	68.400002	70	66.699997	69.75	67.388397	780600	1.3051	1.3047	1.3121	1.3018	1	107.89	107.92	108.5	107.29	111160	1	99.47	99.04	100.06	98.52	1	52894	53000	53460	52690	56530		1.953	1.953	1.953	1.953		1425.9	1429	1435.25	1415.9		652.45	632	650.8	632	1	1400	80.306	80.36	80.505	79.955	13240		52.560001	52.619999	51.77	52.400002	49.656178	13179600	38.27	38.549999	38.209999	38.279999	38.279999	5376800
Fri Dec 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	156.350006	156.490005	155.820007	156.309998	156.309998	3565100	125.669998	126.43	125.410004	126.389999	109.76622	92187200	12169.87988	12297.44043	12169.79981	12294	12294	80420000	70.050003	71.75	69.900002	71.599998	69.17576600000001	621200	1.3043	1.3051	1.3098	1.3026		107.96	107.77	108.55	107.4	64610	1	99.85	99.49	100.24	99.25	1	53067	53000	53348	52960	27510	1	2.021	2.021	2.021	2.021	1	1426.45	1425.55	1439.3	1424.2	1	665.55	664.95	665.05	664.95	1	1400	80.236	80.21	80.375	80.06	7170		52.59	52.790001	52.349998	52.790001	50.169365	4729000	38.470001	38.610001	38.369999	38.490002	38.490002	2162200
Tue Dec 27 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	155.080002	155.550003	154.53999299999995	154.910004	154.910004	4918600	126.169998	126.82	126.059998	126.489998	109.853065	86075700	12293.46973	12328.46973	12269.96973	12291.34961	12291.34961	95980000	70.800003	71.150002	67.550003	67.650002	65.359505	510500	1.3068	1.3062	1.3083	1.3041	1	109.27	108.16	109.5	107.85	50680	1	101.28	99.94	101.79	99.39	1	52711	53014	53099	52588	27450		2.002	2.002	2.002	2.002		1438.55	1438.3	1442.85	1424.75	1	663	658.5	668.8	651.8	1	1400	80.135	80.15	80.235	80.04	5660		52.369999	52.52	51.68	51.869999	49.295036	4786400	38.490002	39.209999	38.459999	39.060001	39.060001	7834100
Wed Dec 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	154.050003	154.259995	150.660004	151.029999	151.029999	16436100	126.510002	126.529999	124.730003	124.830002	108.411423	119107100	12288.84961	12299.11035	12140.16992	12151.41016	12151.41016	84010000	68.5	68.599998	66.050003	66.699997	64.441666	730700	1.2936	1.307	1.3081	1.291		107.56	108.93	109.5	106.77	114940		99.59	101.27	101.72	99.12		50636	52590	52806	50281	72550		1.921	1.921	1.921	1.921		1386.8	1437.35	1437.35	1384.65		638.8	662.6	667.2	631.6		1400	80.883	80.14	81.025	80.055	21110	1	51.77	51.869999	50.009998	50.060001	47.574883	14170400	38.880001	38.889999	38.189999	38.34	38.34	5654300
Thu Dec 29 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	149.089996	150.720001	148.270004	150.339996	150.339996	19812200	125.239998	126.25	124.860001	126.120003	109.531738	123507200	12152.32031	12293.95996	12152.08984	12287.04004	12287.04004	8410000	66	67.800003	64.699997	67.75	65.45611600000001	632700	1.2962	1.2939	1.2965	1.2857	1	108.01	107.41	108.1	106.5	108320	1	99.82	99.6	99.93	98.31	1	50218	50505	50505	48562	106590		1.899	1.899	1.899	1.899		1379	1385.3	1389.4	1348.05		631.6	636.9	639.1	622.1		1400	80.911	81.085	81.31	80.77	15450	1	49.52	51.200001	49.220001	51.200001	48.658298	12196600	38.389999	38.459999	37.869999	38.41	38.41	8924300


CREATE TABLE final_uso (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "sp_open" DOUBLE,
  "sp_high" DOUBLE,
  "sp_low" DOUBLE,
  "sp_close" DOUBLE,
  "sp_ajclose" DOUBLE,
  "sp_volume" BIGINT,
  "dj_open" DOUBLE,
  "dj_high" DOUBLE,
  "dj_low" DOUBLE,
  "dj_close" DOUBLE,
  "dj_ajclose" DOUBLE,
  "dj_volume" BIGINT,
  "eg_open" DOUBLE,
  "eg_high" DOUBLE,
  "eg_low" DOUBLE,
  "eg_close" DOUBLE,
  "eg_ajclose" DOUBLE,
  "eg_volume" BIGINT,
  "eu_price" DOUBLE,
  "eu_open" DOUBLE,
  "eu_high" DOUBLE,
  "eu_low" DOUBLE,
  "eu_trend" BIGINT,
  "of_price" DOUBLE,
  "of_open" DOUBLE,
  "of_high" DOUBLE,
  "of_low" DOUBLE,
  "of_volume" BIGINT,
  "of_trend" BIGINT,
  "os_price" DOUBLE,
  "os_open" DOUBLE,
  "os_high" DOUBLE,
  "os_low" DOUBLE,
  "os_trend" BIGINT,
  "sf_price" BIGINT,
  "sf_open" BIGINT,
  "sf_high" BIGINT,
  "sf_low" BIGINT,
  "sf_volume" BIGINT,
  "sf_trend" BIGINT,
  "usb_price" DOUBLE,
  "usb_open" DOUBLE,
  "usb_high" DOUBLE,
  "usb_low" DOUBLE,
  "usb_trend" BIGINT,
  "plt_price" DOUBLE,
  "plt_open" DOUBLE,
  "plt_high" DOUBLE,
  "plt_low" DOUBLE,
  "plt_trend" BIGINT,
  "pld_price" DOUBLE,
  "pld_open" DOUBLE,
  "pld_high" DOUBLE,
  "pld_low" DOUBLE,
  "pld_trend" BIGINT,
  "rho_price" BIGINT,
  "usdi_price" DOUBLE,
  "usdi_open" DOUBLE,
  "usdi_high" DOUBLE,
  "usdi_low" DOUBLE,
  "usdi_volume" BIGINT,
  "usdi_trend" BIGINT,
  "gdx_open" DOUBLE,
  "gdx_high" DOUBLE,
  "gdx_low" DOUBLE,
  "gdx_close" DOUBLE,
  "gdx_adj_close" DOUBLE,
  "gdx_volume" BIGINT,
  "uso_open" DOUBLE,
  "uso_high" DOUBLE,
  "uso_low" DOUBLE,
  "uso_close" DOUBLE,
  "uso_adj_close" DOUBLE,
  "uso_volume" BIGINT
);