STRASMORE/EXPLORE 3,293 QUERIES

jnj_monthly

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-is-jnj-stock-for-indian-investors.

as of series 25×4read in context →
jnj_monthly — 25 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthmonth_end_close_usdmonth_high_usdmonth_low_usd
2024-10159.86166.75158.78
2024-11155.01161.06150.76
2024-12144.62155142.75
2025-01152.15154.14140.68
2025-02165.02166.43150.78
2025-03165.84169.99160.56
2025-04156.31161.81141.5
2025-05155.21157.94146.12
2025-06152.75157.67149.04
2025-07164.74169.99152.81
2025-08177.17181.16164.79
2025-09185.42185.99173.33
2025-10188.87194.48182.94
2025-11206.92207.81185.12
2025-12206.95215.18199.9
2026-01227.25230200.91
2026-02248.43248.94227.25
2026-03244.44251.71232.24
2026-04229.85247.21223.78
2026-05225.33235.5220.37
2026-06253.97259.9220.84
2026-07256.35274.9245.49
2026-08265.85276.47250.44
2026-09264.74281.07260.68
2026-10263.81269.67245.17
Rows × columns
25 × 4
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 jnj_monthly, derived from the stored result.
ColumnTypeRangeNotes
month text 25 distinct values (2024-10, 2024-11, 2024-12…)
month_end_close_usd number 144.62 to 265.85 US dollars
month_high_usd number 154.14 to 281.07 US dollars
month_low_usd number 140.68 to 260.68 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
    formatDateTime(toStartOfMonth(date), '%Y-%m')  AS month,
    round(toFloat64(argMax(close, date)), 2)       AS month_end_close_usd,
    round(toFloat64(max(high)), 2)                 AS month_high_usd,
    round(toFloat64(min(low)), 2)                  AS month_low_usd
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'JNJ'
  AND date >= toStartOfMonth(today() - INTERVAL 24 MONTH)
  AND date <= today()
GROUP BY month
ORDER BY month
⌘/Ctrl + Enter

इस डेटा के साथ अपने AI असिस्टेंट में काम करें

इस पेज के डेटा के साथ, क्वेरी के लिए तैयार खुलता है। मुफ़्त, बिना अकाउंट।