yield_berjalan

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
    concat(toString(toYear(px.hari)), '-Q', toString(toQuarter(px.hari))) AS kuartal,
    round(100 * sumIf(toFloat64(dv.cash_amount),
                      dv.ex_dividend_date >  px.hari - 365
                  AND dv.ex_dividend_date <= px.hari) / toFloat64(px.harga), 2) AS yield_trailing_pct,
    round(100 * sumIf(toFloat64(dv.cash_amount),
                      dv.ex_dividend_date >  px.hari - 365
                  AND dv.ex_dividend_date <= px.hari
                  AND dv.cash_amount < 5) / toFloat64(px.harga), 2)             AS yield_rutin_pct
FROM
(
    SELECT
        toStartOfQuarter(date) AS kuartal_mulai,
        max(date)              AS hari,
        argMax(close, date)    AS harga
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'COST'
      AND date >= '2023-01-01'
      AND date <  '2026-01-01'
    GROUP BY kuartal_mulai
) AS px
CROSS JOIN
(
    SELECT
        ex_dividend_date,
        cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'COST'
      AND ex_dividend_date >= '2021-06-01'
      AND ex_dividend_date <  '2026-01-01'
      AND cash_amount > 0
) AS dv
GROUP BY kuartal, px.harga
ORDER BY kuartal