trailing_yield

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
    px AS
    (
        SELECT
            toStartOfQuarter(date)         AS q,
            argMax(toFloat64(close), date) AS quarter_close
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'T'
          AND date >= '2023-01-01'
          AND date <= today()
        GROUP BY q
    ),
    dv AS
    (
        SELECT
            ex_dividend_date            AS ex,
            toFloat64(max(cash_amount)) AS amt
        FROM global_markets.stocks_dividends
        WHERE ticker = 'T'
          AND ex_dividend_date >= '2022-04-01'
        GROUP BY ex
    )
SELECT
    toString(p.q) AS quarter_date,
    concat(toString(toQuarter(p.q)), ' кв. ', toString(toYear(p.q))) AS quarter_label,
    round(any(p.quarter_close), 2)                    AS close_usd,
    round(100 * sum(d.amt) / any(p.quarter_close), 2) AS trailing_yield_pct
FROM px AS p
CROSS JOIN dv AS d
WHERE d.ex >= addMonths(p.q, -9)
  AND d.ex <  addMonths(p.q, 3)
GROUP BY p.q
HAVING count() = 4
ORDER BY p.q