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

2,272 answered market questions

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

Futures Tick Size and Tick Value Explained
Worked P&L examples: ticks moved x tick value x contracts (hypothetical)table · 2026-09-16 · 7×5 Outright tick size and tick value per contract, CME specifications, September 2026ranking · 2026-09-16 · 10×4Preview: 10 ranked values, smallest first. Calendar spread tick versus outright tick, dollars per contract, CME specifications, September 2026ranking · 2026-09-16 · 10×4Preview: 10 ranked values, smallest first.
Single Stock Futures: CME's New Contracts
Deposit on a $10,000 position: Reg T stock margin versus the security futures floorranking · 2026-09-12 · 4×4Preview: 4 ranked values, largest first. Fair value of a 100 share future at an illustrative $100 spot and 4% financingranking · 2026-09-12 · 5×4Preview: 5 ranked values, smallest first.
Futures Block Trades and CME Minimums
Share of AAPL volume reported away from the exchanges, last 60 calendar daysseries · 2026-09-12 · 35×2Preview: a 16-point series, ending higher.
Worked P&L examples: ticks moved x tick value x contracts (hypothetical)

Worked P&L examples: ticks moved x tick value x contracts (hypothetical)

most recentas of table 7×5read in context →
Worked P&L examples: ticks moved x tick value x contracts (hypothetical) — 7 rows by 5 columns, computed from US exchange, SIP and OPRA data.
exampleticks_movedtick_value_usdcontractspnl_usd
ES up 4.50 points, 1 contract1812.51225
ES up 4.50 points, 3 contracts1812.53675
MES up 4.50 points, 1 contract181.25122.5
CL down 0.85 per barrel, long 1 contract-85101-850
MCL down 0.85 per barrel, long 1 contract-8511-85
ZN up 8/32 (110-16 to 110-24), 1 contract1615.6251250
ZB down 12/32 (118-00 to 117-20), long 1 contract-1231.251-375
the exact SQL behind every number 
SELECT
    example,
    ticks_moved,
    tick_value_usd,
    contracts,
    ticks_moved * tick_value_usd * contracts AS pnl_usd
FROM
(
    SELECT 1 AS id, 'ES up 4.50 points, 1 contract' AS example, 18 AS ticks_moved, 12.50 AS tick_value_usd, 1 AS contracts
    UNION ALL SELECT 2, 'ES up 4.50 points, 3 contracts', 18, 12.50, 3
    UNION ALL SELECT 3, 'MES up 4.50 points, 1 contract', 18, 1.25, 1
    UNION ALL SELECT 4, 'CL down 0.85 per barrel, long 1 contract', -85, 10.00, 1
    UNION ALL SELECT 5, 'MCL down 0.85 per barrel, long 1 contract', -85, 1.00, 1
    UNION ALL SELECT 6, 'ZN up 8/32 (110-16 to 110-24), 1 contract', 16, 15.625, 1
    UNION ALL SELECT 7, 'ZB down 12/32 (118-00 to 117-20), long 1 contract', -12, 31.25, 1
) AS examples
ORDER BY id
More from this analysisFutures Tick Size and Tick Value Explained
Outright tick size and tick value per contract, CME specifications, September 2026 ranking 10×4 → Calendar spread tick versus outright tick, dollars per contract, CME specifications, September 2026 ranking 10×4 → Share of AAPL volume reported away from the exchanges, last 60 calendar days series 35×2 → Fair value of a 100 share future at an illustrative $100 spot and 4% financing ranking 5×4 → See all 2,272 queries →
$