price_history

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.

Rows × columns

37 × 5

Period covered

2023-10-01 to 2026-10-01

Computed

2026-10-24

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

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 2026-10-24, and the query below is what returned them.

SELECT
    toString(toStartOfMonth(date))      AS month,
    formatDateTime(min(date), '%b %Y')  AS month_label,
    round(avg(toFloat64(close)), 2)     AS avg_close_usd,
    round(min(toFloat64(low)), 2)       AS month_low_usd,
    round(max(toFloat64(high)), 2)      AS month_high_usd
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'JNJ'
  AND date >= toStartOfMonth(today() - 1095)
GROUP BY month
ORDER BY month