revenue_mix
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-24, from what-does-jnj-stand-for.
| quarter_end_date | quarter_label | revenue_usd_bn | gross_profit_usd_bn |
|---|---|---|---|
| 2022-01-02 | Jan 2022 | 9.77 | 8.27 |
| 2022-04-03 | Apr 2022 | 23.43 | 15.83 |
| 2022-07-03 | Jul 2022 | 24.02 | 16.1 |
| 2022-10-02 | Oct 2022 | 20 | 13.82 |
| 2023-01-01 | Jan 2023 | 19.94 | 13.86 |
| 2023-04-02 | Apr 2023 | 20.89 | 14.21 |
| 2023-07-02 | Jul 2023 | 21.52 | 15.06 |
| 2023-10-01 | Oct 2023 | 21.35 | 14.74 |
| 2023-12-31 | Dec 2023 | 21.4 | 14.6 |
| 2024-03-31 | Mar 2024 | 21.38 | 14.87 |
| 2024-06-30 | Jun 2024 | 22.45 | 15.58 |
| 2024-09-29 | Sep 2024 | 22.47 | 15.51 |
| 2024-12-29 | Dec 2024 | 22.52 | 15.39 |
| 2025-03-30 | Mar 2025 | 21.89 | 14.54 |
| 2025-06-29 | Jun 2025 | 23.74 | 16.11 |
| 2025-09-28 | Sep 2025 | 23.99 | 16.69 |
| 2025-12-28 | Dec 2025 | 24.56 | 16.6 |
- Rows × columns
- 17 × 4
- Period covered
- to
- 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 |
|---|---|---|---|
quarter_end_date |
date | 2022-01-02 to 2025-12-28 | |
quarter_label |
text | 17 distinct values (Apr 2022, Apr 2023, Dec 2023…) | |
revenue_usd_bn |
number | 9.77 to 24.56 | US dollars |
gross_profit_usd_bn |
number | 8.27 to 16.69 | 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(period_end) AS quarter_end_date,
formatDateTime(period_end, '%b %Y') AS quarter_label,
round(toFloat64(revenue) / 1e9, 2) AS revenue_usd_bn,
round(toFloat64(gross_profit) / 1e9, 2) AS gross_profit_usd_bn
FROM
(
SELECT
period_end,
argMax(revenue, (filing_date, period_end)) AS revenue,
argMax(gross_profit, (filing_date, period_end)) AS gross_profit
FROM global_markets.stocks_income_statements
WHERE has(tickers, 'JNJ')
AND timeframe = 'quarterly'
AND period_end >= '2022-01-01'
GROUP BY period_end
)
WHERE revenue > 0
ORDER BY period_end
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.