pay_calendar
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-09-30, from us-dividend-tax-for-indian-investors.
| ticker | ex_date_label | record_date_label | pay_date_label | gross_dps_usd | net_dps_usd |
|---|---|---|---|---|---|
| KO | Sep 15, 2026 | Sep 15, 2026 | Oct 1, 2026 | 0.53 | 0.3975 |
| JNJ | Aug 25, 2026 | Aug 25, 2026 | Sep 8, 2026 | 1.34 | 1.005 |
| MSFT | Aug 20, 2026 | Aug 20, 2026 | Sep 10, 2026 | 0.91 | 0.6825 |
| CVX | Aug 19, 2026 | Aug 19, 2026 | Sep 10, 2026 | 1.78 | 1.335 |
| PG | Jul 24, 2026 | Jul 24, 2026 | Aug 17, 2026 | 1.0885 | 0.8164 |
| ABBV | Jul 15, 2026 | Jul 15, 2026 | Aug 14, 2026 | 1.73 | 1.2975 |
- Rows × columns
- 6 × 6
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
ticker |
text | 6 distinct values (ABBV, CVX, JNJ…) | |
ex_date_label |
text | 6 distinct values (Aug 19, 2026, Aug 20, 2026, Aug 25, 2026…) | |
record_date_label |
text | 6 distinct values (Aug 19, 2026, Aug 20, 2026, Aug 25, 2026…) | |
pay_date_label |
text | 5 distinct values (Aug 14, 2026, Aug 17, 2026, Oct 1, 2026…) | |
gross_dps_usd |
number | 0.53 to 1.78 | US dollars |
net_dps_usd |
number | 0.3975 to 1.335 | 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
ticker,
formatDateTime(max(ex_dividend_date), '%b %e, %Y') AS ex_date_label,
formatDateTime(argMax(record_date, ex_dividend_date), '%b %e, %Y') AS record_date_label,
formatDateTime(argMax(pay_date, ex_dividend_date), '%b %e, %Y') AS pay_date_label,
round(argMax(toFloat64(cash_amount), ex_dividend_date), 4) AS gross_dps_usd,
round(argMax(toFloat64(cash_amount), ex_dividend_date) * 0.75, 4) AS net_dps_usd
FROM global_markets.stocks_dividends
WHERE ticker IN ('JNJ', 'KO', 'PG', 'MSFT', 'ABBV', 'CVX')
AND ex_dividend_date <= today()
AND ex_dividend_date > today() - 200
GROUP BY ticker
ORDER BY max(ex_dividend_date) DESC
इस डेटा के साथ अपने AI असिस्टेंट में काम करें
इस पेज के डेटा के साथ, क्वेरी के लिए तैयार खुलता है। मुफ़्त, बिना अकाउंट।