3,256 answered market questions

WITH px AS
(
    SELECT
        toStartOfMonth(date)            AS m,
        round(toFloat64(avg(close)), 2) AS avg_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'JNJ'
      AND date >= '2026-01-01'
      AND date <  '2027-01-01'
    GROUP BY m
),
divs AS
(
    SELECT
        ex_dividend_date AS ex_date,
        max(cash_amount) AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'JNJ'
      AND ex_dividend_date >= '2024-01-01'
      AND ex_dividend_date <  '2027-01-01'
    GROUP BY ex_dividend_date
)
SELECT
    formatDateTime(px.m, '%Y-%m')                                                     AS month,
    round(toFloat64(argMax(divs.amt, divs.ex_date)), 4)                               AS quarterly_rate_in_effect,
    round(toFloat64(argMax(divs.amt, divs.ex_date)) * 4 / any(px.avg_close) * 100, 2) AS indicated_yield_pct
FROM px
CROSS JOIN divs
WHERE divs.ex_date <= toLastDayOfMonth(px.m)
GROUP BY px.m
ORDER BY month