Prices Gold Years

Price discovery is crucial for any market. Gold not only has a spot price.

@kaggle.willianoliveiragibin_prices_gold_years

Table List

2 tables(99.18 KB)

Economic Calendar 19–23 New

@kaggle.willianoliveiragibin_prices_gold_years.economic_calendar_19_23_new

47.9 KB
1876 rows
9 columns

day Day	date Date	hour Hour	country Country	event Event	actual Actual	previous Previous	consensus Consensus	forecast Forecast
Tuesday	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	20:45	CN	Caixin Manufacturing PMI DEC	49.7	50.2	50.1	50.1
Friday	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	08:30	US	Non Farm Payrolls DEC	312K	176K	177K	165K
Sunday	Sun Jan 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	0	CN	US-China Trade Talks	0	0	0	0
Monday	Mon Jan 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	10:00	CA	Ivey PMI s.a DEC	59.7	57.2	56.8	56.7
Monday	Mon Jan 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	0	CN	US-China Trade Talks	0	0	0	0
Tuesday	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	00:00	JP	Consumer Confidence DEC	42.7	42.9	nan	42
Tuesday	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	05:00	EA	Business Confidence DEC	0.82	01.04	0.99	1.1
Tuesday	Tue Jan 08 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	08:30	CA	Balance of Trade NOV	-2.06B	-0.85B	-1.95B	nan
Wednesday	Wed Jan 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	20:30	CN	Inflation Rate YoY DEC	19	2.20%	21	22
Friday	Fri Jan 11 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	04:30	GB	Balance of Trade NOV	-2.904B	-3.037B	nan	-2.2B


CREATE TABLE economic_calendar_19_23_new (
  "day" VARCHAR,
  "date" TIMESTAMP,
  "hour" VARCHAR,
  "country" VARCHAR,
  "event" VARCHAR,
  "actual" VARCHAR,
  "previous" VARCHAR,
  "consensus" VARCHAR,
  "forecast" VARCHAR
);