Learn how to interact with this dataset using the Ouro SDK or REST API.
API access requires an API key. Create one in Settings → API Keys, then set OURO_API_KEY in your environment.
Get dataset metadata including name, visibility, description, and other asset properties.
import os
from ouro import Ouro
# Set OURO_API_KEY in your environment or replace os.environ.get("OURO_API_KEY")
ouro = Ouro(api_key=os.environ.get("OURO_API_KEY"))
dataset_id = "019aea5d-27f3-78e1-9c9c-31495ba920bb"
# Retrieve dataset metadata
dataset = ouro.datasets.retrieve(dataset_id)
print(dataset.name, dataset.visibility)
print(dataset.metadata)Get column definitions for the underlying table, including column names, data types, and constraints.
| Column | Type |
|---|---|
| date | timestamp with time zone |
| type | text |
| value | real |
# Get column definitions for the underlying table
columns = ouro.datasets.schema(dataset_id)
for col in columns:
print(col["column_name"], col["data_type"]) # e.g., age integer, name textFetch the dataset's rows. Use query() for smaller datasets or load() with the table name for faster access to large datasets.
# Option 1: Query data by dataset ID (returns Pandas DataFrame)
df = ouro.datasets.query(dataset_id)
print(df.head())
# Option 2: Load data by table name (faster for large datasets)
table_name = dataset.metadata["table_name"] # e.g., "gold_futures_forecast_december_2025"
df = ouro.datasets.load(table_name)
print(len(df))Update dataset metadata (visibility, description, etc.) and optionally write new rows to the table. Writing new data will replace the existing data in the table. Requires write or admin permission on the dataset.
import pandas as pd
# Update dataset metadata
updated = ouro.datasets.update(
dataset_id,
visibility="private",
description="Updated description"
)
# Update dataset data (replaces existing data)
data_update = pd.DataFrame([
{"name": "Charlie", "age": 33},
{"name": "Diana", "age": 28},
])
updated = ouro.datasets.update(dataset_id, data=data_update)Forecasts for Gold Futures with 12-period horizon (monthly)
Describes a steady rise in gold prices over the next year. The main drivers are a softer US labor market, expectations for easier monetary policy, and ongoing geopolitical tensions that keep safe-haven demand intact. The current price is about $4,243 per ounce (as of December 1, 2025), with a forecast to reach around $4,928 by December 2026, roughly a 16% gain. In the near term, gold may pause or pull back a bit as investors position ahead of key data and Fed communications, but the overall path suggests a gradual, controlled increase driven by lower real yields and the policy outlook. Risks include a faster rebound in growth, less easing, or a stronger dollar.