Have you considered using yahoofinance.
Here is the configuration.yaml code and the gold symbol
# Track stock symbols every 20 minutes
yahoofinance:
symbols:
- F*GC.CMX
scan_interval:
minutes: 20
show_trending_icon: true
decimal_places: 2
You can create a page in lovelace to view and the data will be archived in database.