Weekly movers: ten biggest gainers and decliners, $5M+ traded, in-week splits excluded

Name: Weekly movers: ten biggest gainers and decliners, $5M+ traded, in-week splits excluded
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 July 6, 2026.

as of 2026-07-26 table 20×5read in context →

Weekly movers: ten biggest gainers and decliners, $5M+ traded, in-week splits excluded — 20 rows by 5 columns, computed 2026-07-26 from US exchange, SIP and OPRA data.
ticker	board	week_pct	week_dollar_m	pct_of_dollar_max
FXHO	gainers	147.3	113.8	1.2
FBRX	gainers	109.6	305.8	3.2
CRNX	gainers	98	9660.5	100
GMM	gainers	97.6	639.3	6.6
LHSW	gainers	91.6	307.8	3.2
JZXN	gainers	89.9	356.5	3.7
TRAX	gainers	87.4	225.6	2.3
ZCMD	gainers	86.2	77.2	0.8
WRAP	gainers	72.3	172.7	1.8
SUNE	gainers	67	363.9	3.8
JEM	decliners	-76.4	26.1	0.3
ELPW	decliners	-70.3	105.2	1.1
HAO	decliners	-65.8	128.5	1.3
ALAR	decliners	-65.1	14.8	0.2
CCHH	decliners	-55.5	105.9	1.1
SDOT	decliners	-53.7	366.7	3.8
ONFO	decliners	-47.6	75.2	0.8
YHC	decliners	-46.9	17.7	0.2
GMEX	decliners	-44.9	14.8	0.2
BYRN	decliners	-44.6	44.8	0.5

Rows × columns: 20 × 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 Weekly movers: ten biggest gainers and decliners, $5M+ traded, in-week splits excluded, derived from the stored result.
Column	Type	Range	Notes
`ticker`	text	20 distinct values (ALAR, BYRN, CCHH…)
`board`	text	2 distinct values (decliners, gainers)
`week_pct`	number	-76.4 to 147.3	percent
`week_dollar_m`	number	14.8 to 9,660.5
`pct_of_dollar_max`	number	0.2 to 100	percent

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.

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 ticker, board, week_pct, week_dollar_m,
       round(100 * week_dollar_m / max(week_dollar_m) OVER (), 1) AS pct_of_dollar_max
FROM (
    SELECT 'gainers' AS board, ticker, round((cw / cp - 1) * 100, 1) AS week_pct, round(dv / 1e6, 1) AS week_dollar_m
    FROM (
        SELECT ticker,
               toFloat64(argMaxIf(close, window_start, window_start < '2026-07-03 00:00:00')) AS cp,
               toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')) AS cw,
               sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 13:30:00') AS dv
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker NOT IN ('SPCX')
          AND ticker NOT IN (SELECT ticker FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10')
          AND ((window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00')
            OR (window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-11 00:00:00'))
        GROUP BY ticker
        HAVING cp > 0 AND cw > 0 AND dv >= 5000000
    )
    ORDER BY week_pct DESC
    LIMIT 10
    UNION ALL
    SELECT 'decliners' AS board, ticker, round((cw / cp - 1) * 100, 1) AS week_pct, round(dv / 1e6, 1) AS week_dollar_m
    FROM (
        SELECT ticker,
               toFloat64(argMaxIf(close, window_start, window_start < '2026-07-03 00:00:00')) AS cp,
               toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')) AS cw,
               sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 13:30:00') AS dv
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker NOT IN ('SPCX')
          AND ticker NOT IN (SELECT ticker FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10')
          AND ((window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00')
            OR (window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-11 00:00:00'))
        GROUP BY ticker
        HAVING cp > 0 AND cw > 0 AND dv >= 5000000
    )
    ORDER BY week_pct ASC
    LIMIT 10
)
ORDER BY board DESC, abs(week_pct) DESC

SQL to run

SELECT ticker, board, week_pct, week_dollar_m,
       round(100 * week_dollar_m / max(week_dollar_m) OVER (), 1) AS pct_of_dollar_max
FROM (
    SELECT 'gainers' AS board, ticker, round((cw / cp - 1) * 100, 1) AS week_pct, round(dv / 1e6, 1) AS week_dollar_m
    FROM (
        SELECT ticker,
               toFloat64(argMaxIf(close, window_start, window_start < '2026-07-03 00:00:00')) AS cp,
               toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')) AS cw,
               sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 13:30:00') AS dv
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker NOT IN ('SPCX')
          AND ticker NOT IN (SELECT ticker FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10')
          AND ((window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00')
            OR (window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-11 00:00:00'))
        GROUP BY ticker
        HAVING cp > 0 AND cw > 0 AND dv >= 5000000
    )
    ORDER BY week_pct DESC
    LIMIT 10
    UNION ALL
    SELECT 'decliners' AS board, ticker, round((cw / cp - 1) * 100, 1) AS week_pct, round(dv / 1e6, 1) AS week_dollar_m
    FROM (
        SELECT ticker,
               toFloat64(argMaxIf(close, window_start, window_start < '2026-07-03 00:00:00')) AS cp,
               toFloat64(argMaxIf(close, window_start, window_start >= '2026-07-10 13:30:00' AND window_start < '2026-07-10 20:00:00')) AS cw,
               sumIf(toFloat64(close) * toFloat64(volume), window_start >= '2026-07-06 13:30:00') AS dv
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker NOT IN ('SPCX')
          AND ticker NOT IN (SELECT ticker FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10')
          AND ((window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00')
            OR (window_start >= '2026-07-06 13:30:00' AND window_start < '2026-07-11 00:00:00'))
        GROUP BY ticker
        HAVING cp > 0 AND cw > 0 AND dv >= 5000000
    )
    ORDER BY week_pct ASC
    LIMIT 10
)
ORDER BY board DESC, abs(week_pct) DESC

⌘/Ctrl + Enter

このデータをAIアシスタントで使う

このページのデータで、すぐにクエリできる状態で開きます。無料、アカウント不要。

Claude ChatGPT Gemini Muse 自分のエージェント

More from this analysisMarket Recap: Week of July 6, 2026

SK Hynix's SEC paper trail into its July 10 US listing table 9×2 → SEC filings by session and form type, July 6-10 table 5×5 → Feed coverage by day: articles tagging NVDA, MU, INTC, TER, July 6-10 table 5×5 → SPY / QQQ / DIA / IWM: week of July 6 vs the July 2 close, with the prior week's change table 4×5 → What the news feed actually carried, verbatim (The Motley Fool, rout day and bounce day) table 2×3 → The chip complex's full-week change: July 10 close vs July 2 close, fourteen names ranking 14×2 → See all 3,214 queries →