STRASMORE/EXPLORE 3,256 QUERIES

dividen_jnj

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-10-09, from us-dividend-tax-for-malaysian-investors.

as of table 12×5read in context →
dividen_jnj — 12 rows by 5 columns, computed from US exchange, SIP and OPRA data.
tarikh_isotarikh_exkasar_usdditahan_usdbersih_usd
2023-11-2020 November 20231.190.3570.833
2024-02-1616 Februari 20241.190.3570.833
2024-05-2020 Mei 20241.240.3720.868
2024-08-2727 Ogos 20241.240.3720.868
2024-11-2626 November 20241.240.3720.868
2025-02-1818 Februari 20251.240.3720.868
2025-05-2727 Mei 20251.30.390.91
2025-08-2626 Ogos 20251.30.390.91
2025-11-2525 November 20251.30.390.91
2026-02-2424 Februari 20261.30.390.91
2026-05-2626 Mei 20261.340.4020.938
2026-08-2525 Ogos 20261.340.4020.938
Rows × columns
12 × 5
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for dividen_jnj, derived from the stored result.
ColumnTypeRangeNotes
tarikh_iso date 2023-11-20 to 2026-08-25
tarikh_ex text 12 distinct values
kasar_usd number 1.19 to 1.34 US dollars
ditahan_usd number 0.357 to 0.402 US dollars
bersih_usd number 0.833 to 0.938 US dollars

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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
    toString(ex_dividend_date)                   AS tarikh_iso,
    concat(
        toString(toDayOfMonth(toDate(ex_dividend_date))), ' ',
        arrayElement(['Januari', 'Februari', 'Mac', 'April', 'Mei', 'Jun',
                      'Julai', 'Ogos', 'September', 'Oktober', 'November', 'Disember'],
                     toMonth(toDate(ex_dividend_date))), ' ',
        toString(toYear(toDate(ex_dividend_date)))
    )                                            AS tarikh_ex,
    round(toFloat64(max(cash_amount)), 4)        AS kasar_usd,
    round(toFloat64(max(cash_amount)) * 0.30, 4) AS ditahan_usd,
    round(toFloat64(max(cash_amount)) * 0.70, 4) AS bersih_usd
FROM global_markets.stocks_dividends
WHERE ticker = 'JNJ'
  AND currency = 'USD'
  AND frequency = 4
  AND ex_dividend_date <= today()
  AND ex_dividend_date >  today() - 1100
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date
⌘/Ctrl + Enter

Gunakan data ini dalam pembantu AI anda

Dibuka sedia untuk ditanya, dengan data halaman ini. Percuma, tanpa akaun.