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

2,173 answered market questions

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

0DTE Options Strategies: How They Trade
Same-day options volume by premium paid: whole US tape, July 10, 2026ranking · 2026-07-31 · 5×4Preview: 5 ranked values, largest first. Median gamma, theta and delta by time to expiry: near-the-money US options, July 15, 2026table · 2026-07-31 · 4×5 How July 10's same-day SPY contracts finished: expired at zero vs. settled with valueranking · 2026-07-31 · 2×4Preview: 2 ranked values, smallest first. SPY intraday travel: close, high and low against the open, June 1 to July 10, 2026series · 2026-07-31 · 28×5Preview: a 16-point series, roughly flat.
Same-day options volume by premium paid: whole US tape, July 10, 2026

Same-day options volume by premium paid: whole US tape, July 10, 2026

most recentas of ranking 5×4read in context →
Same-day options volume by premium paid: whole US tape, July 10, 2026 — 5 rows by 4 columns, computed from US exchange, SIP and OPRA data.
premium_paidcontracts_mpct_of_contractspct_of_premium_dollars
Under $0.106.6921.10.5
$0.10 to $0.509.3229.44.3
$0.50 to $210.6633.619.2
$2 to $104.0712.829
$10 and up0.993.147
the exact SQL behind every number
SELECT multiIf(price < 0.10, 'Under $0.10',
               price < 0.50, '$0.10 to $0.50',
               price < 2, '$0.50 to $2',
               price < 10, '$2 to $10',
               '$10 and up') AS premium_paid,
       round(sum(size) / 1e6, 2) AS contracts_m,
       round(100.0 * sum(size) / sum(sum(size)) OVER (), 1) AS pct_of_contracts,
       round(100.0 * sum(price * size) / sum(sum(price * size)) OVER (), 1) AS pct_of_premium_dollars
FROM global_markets.options_trades
WHERE sip_timestamp >= toDateTime64('2026-07-10 13:30:00', 9)
  AND sip_timestamp < toDateTime64('2026-07-10 20:00:00', 9)
  AND substring(ticker, length(ticker) - 14, 6) = '260710'
GROUP BY premium_paid
ORDER BY min(price)
$