Where nine familiar issuers close their reported periods

Name: Where nine familiar issuers close their reported periods
Creator: Strasmore
Published: 2026-08-06
License: https://www.strasmore.com/terms/

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-08-06, from What H1 and H2 Mean in Company Reporting.

as of 2026-08-06 table 9×5read in context →

Where nine familiar issuers close their reported periods — 9 rows by 5 columns, computed 2026-08-06 from US exchange, SIP and OPRA data.
ticker	periods_close_in	distinct_months	closes_on_file	latest_close
AAPL	Mar, Jun, Jul, Sep, Dec	5	11	2025-12-27
COST	Feb, May, Aug, Sep, Nov	5	12	2026-05-10
HD	Jan, Feb, Apr, May, Jul, Aug, Oct, Nov	8	11	2026-05-03
JNJ	Mar, Jun, Jul, Sep, Oct, Dec	6	11	2025-12-28
KO	Mar, Jun, Sep, Dec	4	10	2025-12-31
MSFT	Mar, Jun, Sep, Dec	4	10	2025-12-31
NVDA	Jan, Apr, Jul, Oct	4	12	2026-04-26
ORCL	Feb, May, Aug, Nov	4	12	2026-05-31
WMT	Jan, Apr, Jul, Oct	4	10	2025-10-31

Rows × columns: 9 × 5
Period covered: 2025-10-31 to 2026-05-31
Computed: 2026-08-06
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 Where nine familiar issuers close their reported periods, derived from the stored result.
Column	Type	Range
`ticker`	text	9 distinct values (AAPL, COST, HD…)
`periods_close_in`	text	7 distinct values
`distinct_months`	number	4 to 8
`closes_on_file`	number	10 to 12
`latest_close`	date	2025-10-31 to 2026-05-31

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-08-06, and the query below is what returned them.

the exact SQL behind every number

SELECT
    ticker,
    arrayStringConcat(
        arrayMap(m -> ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'][m],
                 arraySort(groupUniqArray(toMonth(period_end)))),
        ', ')                      AS periods_close_in,
    uniqExact(toMonth(period_end)) AS distinct_months,
    uniqExact(period_end)          AS closes_on_file,
    toString(max(period_end))      AS latest_close
FROM
(
    SELECT
        arrayJoin(tickers) AS ticker,
        period_end
    FROM global_markets.stocks_income_statements
    WHERE period_end >= toDate('2023-07-01')
      AND period_end <  toDate('2026-07-01')
)
WHERE ticker IN ('AAPL', 'COST', 'HD', 'JNJ', 'KO', 'MSFT', 'NVDA', 'ORCL', 'WMT')
GROUP BY ticker
ORDER BY ticker

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisWhat H1 and H2 Mean in Company Reporting

The most recent 10-K on file for the same nine issuers ranking 9×4 → Companies filing a 10-K annual report in each month of calendar H1 2026 series 6×3 → Annual and interim filing forms counted over calendar H1 2026 ranking 3×3 → Spacing between each name's eight biggest overnight moves, July 2024 to June 2026 table 7×5 → Apple: implied volatility and the expected move at six horizons, one session table 6×7 → Implied vs realized: median 30-day expected move and what six stocks did next table 6×5 → See all 2,170 queries →