Advancers and decliners on the week, with the liquidity filter disclosed

Name: Advancers and decliners on the week, with the liquidity filter disclosed
Creator: Strasmore
Published: 2026-07-26
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-07-26, from Market Recap: Week of June 29, 2026.

as of 2026-07-26 scalar 1×5read in context →

advancers

5,049

decliners

3,529

unchanged

dropped by liquidity filter

3,157

tickers with both closes

11,774

Rows × columns: 1 × 5
Computed: 2026-07-26
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 Advancers and decliners on the week, with the liquidity filter disclosed, derived from the stored result.
Column	Type	Range
`advancers`	number	every row is 5,049
`decliners`	number	every row is 3,529
`unchanged`	number	every row is 39
`dropped_by_liquidity_filter`	number	every row is 3,157
`tickers_with_both_closes`	number	every row is 11,774

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

the exact SQL behind every number

SELECT
    countIf(chg > 0 AND NOT dropped) AS advancers,
    countIf(chg < 0 AND NOT dropped) AS decliners,
    countIf(chg = 0 AND NOT dropped) AS unchanged,
    countIf(dropped) AS dropped_by_liquidity_filter,
    count() AS tickers_with_both_closes
FROM (
    SELECT ticker,
        argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-06-29') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
      - argMaxIf(toFloat64(close), window_start, toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-26') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) AS chg,
        sumIf(toFloat64(close) * toFloat64(volume), toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-06-29')) < 1e6 AS dropped
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= toDateTime('2026-06-26 00:00:00') AND window_start < toDateTime('2026-07-03 00:00:00')
    GROUP BY ticker
    HAVING countIf(toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2026-06-26') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) > 0
       AND countIf(toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2026-06-29') AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) > 0
)

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 analysisMarket Recap: Week of June 29, 2026

The session receipt: four traded days, one Friday closure, verified from the tape scalar 1×3 → The week's corporate calendar: with the June 30 filing-index gap on display scalar 1×8 → This week against the trailing year of weeks: SPY, open-to-close within each week (rank 1 = best; short weeks excluded) scalar 1×5 → Regular-hours dollar volume, week of June 29 (one reused-symbol listing excluded pending entity verification) ranking 8×3 → Contracts traded during the week, by expiry date (single-pass scan; batch-generated) ranking 6×3 → Treasury yields through the week (July 2 print not yet ingested at generation) ranking 5×4 → See all 2,170 queries →