STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

What H1 and H2 Mean in Company Reporting
Where nine familiar issuers close their reported periodstable · 2026-08-06 · 9×5 The most recent 10-K on file for the same nine issuersranking · 2026-08-06 · 9×4Preview: 9 ranked values, smallest first. Annual and interim filing forms counted over calendar H1 2026ranking · 2026-08-06 · 3×3Preview: 3 ranked values, largest first. Companies filing a 10-K annual report in each month of calendar H1 2026series · 2026-08-06 · 6×3Preview: a 6-point series, roughly flat.
Where nine familiar issuers close their reported periods

Where nine familiar issuers close their reported periods

most recentas of table 9×5read in context →
Where nine familiar issuers close their reported periods — 9 rows by 5 columns, computed from US exchange, SIP and OPRA data.
tickerperiods_close_indistinct_monthscloses_on_filelatest_close
AAPLMar, Jun, Jul, Sep, Dec5112025-12-27
COSTFeb, May, Aug, Sep, Nov5122026-05-10
HDJan, Feb, Apr, May, Jul, Aug, Oct, Nov8112026-05-03
JNJMar, Jun, Jul, Sep, Oct, Dec6112025-12-28
KOMar, Jun, Sep, Dec4102025-12-31
MSFTMar, Jun, Sep, Dec4102025-12-31
NVDAJan, Apr, Jul, Oct4122026-04-26
ORCLFeb, May, Aug, Nov4122026-05-31
WMTJan, Apr, Jul, Oct4102025-10-31
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
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 → See all 2,170 queries →
$