Gold Price Regression

Dataset with financial information ideal for regression tasks

@kaggle.franciscogcc_financial_data

Table List

1 table(915.28 KB)

Financial Regression

@kaggle.franciscogcc_financial_data.financial_regression

915.28 KB
3904 rows
47 columns

date Date	sp500_open Sp500 Open	sp500_high Sp500 High	sp500_low Sp500 Low	sp500_close Sp500 Close	sp500_volume Sp500 Volume	sp500_high_low Sp500 High-low	nasdaq_open Nasdaq Open	nasdaq_high Nasdaq High	nasdaq_low Nasdaq Low	nasdaq_close Nasdaq Close	nasdaq_volume Nasdaq Volume	nasdaq_high_low Nasdaq High-low	usd_chf Usd Chf	eur_usd Eur Usd	silver_open Silver Open	silver_high Silver High	silver_low Silver Low	silver_close Silver Close	silver_volume Silver Volume	silver_high_low Silver High-low	oil_open Oil Open	oil_high Oil High	oil_low Oil Low	oil_close Oil Close	oil_volume Oil Volume	oil_high_low Oil High-low	platinum_open Platinum Open	platinum_high Platinum High	platinum_low Platinum Low	platinum_close Platinum Close	platinum_volume Platinum Volume	platinum_high_low Platinum High-low	palladium_open Palladium Open	palladium_high Palladium High	palladium_low Palladium Low	palladium_close Palladium Close	palladium_volume Palladium Volume	palladium_high_low Palladium High-low	gold_open Gold Open	gold_high Gold High	gold_low Gold Low	gold_close Gold Close	gold_volume Gold Volume
Thu Jan 14 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	114.49	115.14	114.42	114.93	115646960	0.7199999999999989	46.26	46.52	46.22	46.39	75209000	0.3000000000000042	1.0206	1.4478	18.58	18.7	18.45	18.66	69804	0.25	39.3	39.44	38.88	39.06	8575821	0.5599999999999952	160.13	161.85	159.72	161.45	228500	2.1299999999999955	43.93	45.02	43.86	44.84	364528	1.1600000000000037	111.51	112.37	110.79	112.03	18305238
Fri Jan 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	114.73	114.84	113.2	113.64	212252769	1.6400000000000006	46.46	46.55	45.65	45.85	126849300	0.8999999999999986	1.0264	1.4376	18.54	18.54	18.36	18.41	205106	0.1799999999999997	38.97	39.02	38.28	38.4	12615299	0.740000000000002	160.68	161.25	159.5	160.25	189900	1.75	45.18	45.76	44.4	45.76	442210	1.3599999999999994	111.35	112.01	110.38	110.86	18000724
Mon Jan 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)
Tue Jan 19 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	113.62	115.13	113.59	115.06	138671890	1.539999999999992	45.96	46.64	45.95	46.59	84388200	0.6899999999999977	1.034	1.4269	18.53	18.79	18.5	18.79	130552	0.2899999999999991	38.07	38.9499	38.03	38.93	8180157	0.9198999999999984	162.23	165.2	162.1722	165.12	295900	3.027799999999985	46.01	47.08	45.7	46.94	629150	1.3799999999999957	110.95	111.75	110.83	111.52	10467927
Wed Jan 20 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	114.28	114.45	112.98	113.89	216330645	1.4699999999999989	46.27	46.604	45.43	45.92	145680000	1.1739999999999997	1.0453	1.4094	18.31	18.31	17.78	17.86	230907	0.5299999999999976	38.23	38.35	37.88	37.89	11438685	0.4699999999999988	163.51	163.51	159.09	163.22	438200	4.419999999999988	46.59	47.31	45.17	47.05	643198	2.140000000000001	109.97	110.05	108.46	108.94	17534231
Thu Jan 21 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	113.92	114.27	111.56	111.7	344747028	2.7099999999999937	46.06	46.35	45.3	45.49	204939600	1.0500000000000045	1.0426	1.4106	17.82	17.91	17.32	17.38	198067	0.5899999999999999	38.22	38.41	37.09	37.24	13716561	1.3199999999999932	161.86	162.5	159.12	159.79	247600	3.3799999999999955	46.6	46.98	45.07	45.3	388457	1.9099999999999968	108.48	108.78	106.61	107.37	25747831
Fri Jan 22 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	111.2	111.74	109.09	109.21	345627282	2.6499999999999915	45.34	45.48	44.04	44.16	171098700	1.4399999999999975	1.04	1.4154	17.13	17.154	16.87	17.07	184687	0.2839999999999989	37.07	37.09	36.32	36.34	17901363	0.7700000000000031	154.84	155.97	152.26	154.88	190100	3.710000000000008	43.7	44.386	42.6	43.3	343595	1.7860000000000014	106.93	107.68	106.01	107.17	24209966
Mon Jan 25 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	110.21	110.41	109.41	109.77	186751367	1	44.39	44.6	44.12	44.31	154218700	0.480000000000004	1.0403	1.4146	17.01	17.16	16.98	17.13	106196	0.1799999999999997	36.5	36.99	36.41	36.81	9052380	0.5800000000000054	154.72	155.2	153.93	155.19	164800	1.2699999999999818	43.68	44.42	43.43	44.36	184431	0.990000000000002	107.44	107.72	107.07	107.48	13170442
Tue Jan 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	109.34	110.47	109.04	109.31	210788669	1.4299999999999926	44.28	44.89	44.05	44.35	140816500	0.8400000000000034	1.0466	1.4063	16.48	16.89	16.43	16.71	218587	0.4600000000000008	36.37	36.83	36.25	36.5	9104873	0.5799999999999983	150.9	153.64	150.8	153.52	387600	2.839999999999975	42.77	43.1	42.38	42.75	338167	0.7199999999999989	106.87	107.99	106.75	107.56	12274165
Wed Jan 27 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	109.17	110.08	108.33	109.83	271482263	1.75	44.29	44.85	44.01	44.7	161632700	0.8400000000000034	1.0472	1.4053	16.67	16.7	16.42	16.5483	141860	0.2799999999999976	36.54	36.74	35.61	36.08	14802425	1.1300000000000026	152.45	153.2	148.27	149.99	247400	4.929999999999978	42.24	42.44	40.93	41.34	419800	1.509999999999998	107.53	108.8	106.16	106.528	18991219


CREATE TABLE financial_regression (
  "date" TIMESTAMP,
  "sp500_open" DOUBLE,
  "sp500_high" DOUBLE,
  "sp500_low" DOUBLE,
  "sp500_close" DOUBLE,
  "sp500_volume" DOUBLE,
  "sp500_high_low" DOUBLE,
  "nasdaq_open" DOUBLE,
  "nasdaq_high" DOUBLE,
  "nasdaq_low" DOUBLE,
  "nasdaq_close" DOUBLE,
  "nasdaq_volume" DOUBLE,
  "nasdaq_high_low" DOUBLE,
  "us_rates" DOUBLE,
  "cpi" DOUBLE,
  "usd_chf" DOUBLE,
  "eur_usd" DOUBLE,
  "gdp" DOUBLE,
  "silver_open" DOUBLE,
  "silver_high" DOUBLE,
  "silver_low" DOUBLE,
  "silver_close" DOUBLE,
  "silver_volume" DOUBLE,
  "silver_high_low" DOUBLE,
  "oil_open" DOUBLE,
  "oil_high" DOUBLE,
  "oil_low" DOUBLE,
  "oil_close" DOUBLE,
  "oil_volume" DOUBLE,
  "oil_high_low" DOUBLE,
  "platinum_open" DOUBLE,
  "platinum_high" DOUBLE,
  "platinum_low" DOUBLE,
  "platinum_close" DOUBLE,
  "platinum_volume" DOUBLE,
  "platinum_high_low" DOUBLE,
  "palladium_open" DOUBLE,
  "palladium_high" DOUBLE,
  "palladium_low" DOUBLE,
  "palladium_close" DOUBLE,
  "palladium_volume" DOUBLE,
  "palladium_high_low" DOUBLE,
  "gold_open" DOUBLE,
  "gold_high" DOUBLE,
  "gold_low" DOUBLE,
  "gold_close" DOUBLE,
  "gold_volume" DOUBLE
);