Gold Price & Relevant Metrics

UCSB - PSTAT 131 Final Project

@kaggle.cvergnolle_gold_price_and_relevant_metrics

Table List

1 table(86.93 KB)

Gold Price Prediction

@kaggle.cvergnolle_gold_price_and_relevant_metrics.gold_price_prediction

86.93 KB
676 rows
21 columns

date Date	price_2_days_prior Price 2 Days Prior	price_1_day_prior Price 1 Day Prior	price_today Price Today	price_tomorrow Price Tomorrow	price_change_tomorrow Price Change Tomorrow	std_dev_10 Std Dev 10	twenty_moving_average Twenty Moving Average	fifty_day_moving_average Fifty Day Moving Average	n_200_day_moving_average 200 Day Moving Average	monthly_inflation_rate Monthly Inflation Rate	effr_rate EFFR Rate	volume Volume	treasury_par_yield_month Treasury Par Yield Month	treasury_par_yield_two_year Treasury Par Yield Two Year	treasury_par_yield_curve_rates_10_yr Treasury Par Yield Curve Rates (10 Yr)	dxy DXY	sp_open SP Open	vix VIX	crude Crude
Wed Aug 07 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2405.87	2384.9	2385.83			30.15507763	2414.745	2368.2948	2189.8078	3	5.33	96	5.5	4	3.96	103.37	5293.13	24.77	72.84
Tue Aug 06 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2442.74	2405.87	2384.9	2385.83	0.93	29.42393623	2414.1525	2367.7916	2187.8563	3	5.33	89	5.5	3.99	3.9	102.78	5206.42	33.71	73.86
Mon Aug 05 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2447.17	2442.74	2405.87	2384.9	-20.97	28.34130125	2413.2305	2367.1584	2185.96345	3	5.33	86	5.52	3.89	3.78	103.22	5151.14	23.39	74.21
Fri Aug 02 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2447.23	2447.17	2442.74	2405.87	-36.87	28.61666082	2411.092	2365.725	2183.8564	3	5.33	89	5.54	3.88	3.8	104.31	5376.63	20.52	76.87
Thu Aug 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2411.09	2447.23	2447.17	2442.74	-4.43	26.08479583	2408.567	2363.5624	2181.55785	3	5.33	83	5.55	4.16	3.99	104.07	5537.84	16.2	78.59
Wed Jul 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2382.47	2411.09	2447.23	2447.17	-0.06	25.3071923	2404.103	2362.2836	2179.18645	3	5.33	78	5.49	4.29	4.09	104.43	5505.59	16.66	75.24
Tue Jul 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2387.11	2382.47	2411.09	2447.23	36.14	28.43180107	2399.7615	2361.7958	2176.81845	3	5.33	87	5.5	4.35	4.15	104.56	5478.73	16.64	75.91
Mon Jul 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2365.37	2387.11	2382.47	2411.09	28.62	34.90863282	2395.79	2362.1302	2174.66915	3	5.33	90	5.5	4.36	4.17	104.33	5476.55	16.59	77.3
Fri Jul 26 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2400.12	2365.37	2387.11	2382.47	-4.64	33.47269104	2393.3445	2362.7596	2172.64085	3	5.33	85	5.49	4.36	4.2	104.36	5433.67	17.97	78.35
Thu Jul 25 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	2409.86	2400.12	2365.37	2387.11	21.74	31.99188406	2390.3255	2362.6238	2170.45925	3	5.33	88	5.49	4.41	4.27	104.38	5428.7	18.41	77.5


CREATE TABLE gold_price_prediction (
  "date" TIMESTAMP,
  "price_2_days_prior" DOUBLE,
  "price_1_day_prior" DOUBLE,
  "price_today" DOUBLE,
  "price_tomorrow" DOUBLE,
  "price_change_tomorrow" DOUBLE,
  "price_change_ten" DOUBLE,
  "std_dev_10" DOUBLE,
  "twenty_moving_average" DOUBLE,
  "fifty_day_moving_average" DOUBLE,
  "n_200_day_moving_average" DOUBLE,
  "monthly_inflation_rate" DOUBLE,
  "effr_rate" DOUBLE,
  "volume" BIGINT,
  "treasury_par_yield_month" DOUBLE,
  "treasury_par_yield_two_year" DOUBLE,
  "treasury_par_yield_curve_rates_10_yr" DOUBLE,
  "dxy" DOUBLE,
  "sp_open" DOUBLE,
  "vix" DOUBLE,
  "crude" DOUBLE
);