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

Trade Condition Codes Explained
Share of a session's prints carrying price-ineligible conditionsranking · 2026-08-07 · 5×4Preview: 5 ranked values, largest first. Two versions of the same AAPL session high, fifteen minutes at a timeseries · 2026-08-07 · 26×3Preview: a 16-point series, ending lower. Condition code families defined for US stocksranking · 2026-08-07 · 8×2Preview: 8 ranked values, largest first. One AAPL session, every print grouped by its sale conditionranking · 2026-08-07 · 12×3Preview: 12 ranked values, largest first.
Share of a session's prints carrying price-ineligible conditions

Share of a session's prints carrying price-ineligible conditions

most recentas of ranking 5×4read in context →
Share of a session's prints carrying price-ineligible conditions — 5 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickerodd_lot_pctlate_or_derived_pctextended_hours_pct
NVDA85.142.43.53
KO80.975.571.48
MSFT73.993.084.18
AAPL65.833.92.57
SPY46.81.493.21
the exact SQL behind every number 
WITH
    (SELECT groupArray(toInt32(id))
       FROM global_markets.stocks_condition_codes
      WHERE asset_class = 'stocks'
        AND type = 'sale_condition'
        AND name ILIKE '%odd lot%')                       AS odd_lot_codes,
    (SELECT groupArray(toInt32(id))
       FROM global_markets.stocks_condition_codes
      WHERE asset_class = 'stocks'
        AND type = 'sale_condition'
        AND multiSearchAnyCaseInsensitive(name,
              ['form t', 'extended trading hours']))      AS extended_codes,
    (SELECT groupArray(toInt32(id))
       FROM global_markets.stocks_condition_codes
      WHERE asset_class = 'stocks'
        AND type = 'sale_condition'
        AND multiSearchAnyCaseInsensitive(name,
              ['out of sequence', 'prior reference', 'derivatively priced',
               'average price', 'price variation', 'seller'])
        AND NOT multiSearchAnyCaseInsensitive(name,
              ['form t', 'extended trading hours']))      AS late_or_derived_codes
SELECT
    ticker,
    round(100 * countIf(hasAny(conditions, odd_lot_codes))         / count(), 2) AS odd_lot_pct,
    round(100 * countIf(hasAny(conditions, late_or_derived_codes)) / count(), 2) AS late_or_derived_pct,
    round(100 * countIf(hasAny(conditions, extended_codes))        / count(), 2) AS extended_hours_pct
FROM global_markets.stocks_trades
WHERE ticker IN ('AAPL', 'KO', 'MSFT', 'NVDA', 'SPY')
  AND sip_timestamp >= toDateTime('2026-06-17 08:00:00', 'UTC')
  AND sip_timestamp <  toDateTime('2026-06-18 00:00:00', 'UTC')
GROUP BY ticker
ORDER BY odd_lot_pct DESC
More from this analysisTrade Condition Codes Explained
One AAPL session, every print grouped by its sale condition ranking 12×3 → Condition code families defined for US stocks ranking 8×2 → Two versions of the same AAPL session high, fifteen minutes at a time series 26×3 → Biggest stock losers this week (names trading $1B+, leveraged/inverse ETFs excluded) ranking 10×4 → See all 2,170 queries →
$