aapl_month_end_12m

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.

WITH monthly AS
(
    SELECT
        toStartOfMonth(date)            AS month_start,
        argMax(toFloat64(close), date)  AS month_end_close,
        max(date)                       AS last_session
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'AAPL'
      AND date >= subtractMonths(toStartOfMonth(today()), 12)
      AND date <  toStartOfMonth(today())
    GROUP BY month_start
),
first_month AS
(
    SELECT argMin(month_end_close, month_start) AS base_close
    FROM monthly
)
SELECT
    formatDateTime(m.month_start, '%Y-%m')                 AS month,
    formatDateTime(m.month_start, '%b %Y')                 AS month_label,
    toString(m.last_session)                               AS month_last_session,
    round(m.month_end_close, 2)                            AS close_usd,
    round((m.month_end_close / f.base_close - 1) * 100, 2)  AS change_from_start_pct
FROM monthly AS m
CROSS JOIN first_month AS f
ORDER BY m.month_start