GLD's trailing year, and the gold notional inside one MGC

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    month,
    calendar_label,
    round(month_end_close, 2) AS gld_month_end_close,
    round(month_high, 2)      AS gld_month_high,
    round(month_low, 2)       AS gld_month_low,
    concat('$', substring(gold_digits, 1, 1), ',', substring(gold_digits, 2, 3)) AS implied_gold_label,
    concat('$', substring(mgc_digits, 1, 2), ',', substring(mgc_digits, 3, 3))   AS mgc_notional_label
FROM
(
    WITH 0.0918 AS ounces_per_gld_share
    SELECT
        toString(toStartOfMonth(date))     AS month,
        formatDateTime(min(date), '%b %Y') AS calendar_label,
        toFloat64(argMax(close, date))     AS month_end_close,
        toFloat64(max(high))               AS month_high,
        toFloat64(min(low))                AS month_low,
        toString(toUInt32(round(month_end_close / ounces_per_gld_share)))      AS gold_digits,
        toString(toUInt32(round(month_end_close * 10 / ounces_per_gld_share))) AS mgc_digits
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'GLD'
      AND date >= addMonths(toStartOfMonth(today()), -12)
    GROUP BY month
)
ORDER BY month