yield_nama_besar

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
    dv.ticker                                         AS ticker,
    round(dv.dps_12m, 4)                              AS dps_12m_usd,
    round(toFloat64(px.harga), 2)                     AS harga_usd,
    round(100 * dv.dps_12m / toFloat64(px.harga), 2)  AS yield_trailing_pct,
    dv.pembayaran                                     AS jumlah_pembayaran,
    formatDateTime(px.hari, '%e %b %Y')               AS tanggal_harga
FROM
(
    SELECT
        ticker,
        sum(toFloat64(cash_amount)) AS dps_12m,
        count()                     AS pembayaran
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('KO', 'PG', 'JNJ', 'CSCO', 'COST', 'AAPL', 'CVX', 'VZ', 'T', 'ABBV')
      AND ex_dividend_date >= today() - 365
      AND ex_dividend_date <= today()
      AND cash_amount > 0
    GROUP BY ticker
) AS dv
INNER JOIN
(
    SELECT
        ticker,
        max(date)           AS hari,
        argMax(close, date) AS harga
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('KO', 'PG', 'JNJ', 'CSCO', 'COST', 'AAPL', 'CVX', 'VZ', 'T', 'ABBV')
      AND date >= today() - 30
    GROUP BY ticker
) AS px ON px.ticker = dv.ticker
ORDER BY yield_trailing_pct DESC