hasil_bulanan

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
(
    SELECT round(toFloat64(max(cash_amount)) * 4, 2)
    FROM global_markets.stocks_dividends
    WHERE ticker = 'JNJ'
      AND ex_dividend_date >= '2026-01-01'
) AS dividen_tahunan_usd
SELECT
    toString(toStartOfMonth(date))                                              AS month,
    formatDateTime(max(date), '%m/%Y')                                          AS bulan_label,
    formatDateTime(max(date), '%d/%m/%Y')                                       AS tarikh_harga,
    round(toFloat64(argMax(close, date)), 2)                                    AS harga_akhir_bulan_usd,
    round(100 * dividen_tahunan_usd / toFloat64(argMax(close, date)), 2)        AS hasil_pct,
    round(100 * 0.70 * dividen_tahunan_usd / toFloat64(argMax(close, date)), 2) AS hasil_bersih_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'JNJ'
  AND date >= toStartOfMonth(today() - 365)
GROUP BY month
ORDER BY month