STRASMORE/EXPLORE 2,170 QUERIES

The most expensive ticket to zero: the priciest contract that ended at two cents or less

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 The Best and Worst Thousand Dollars of June 2026.

as of scalar 1×5read in context →
contract
O:MU260612C01350000
first price
10
last price
0.01
contracts a thousand bought
1
ending value usd
1
Rows × columns
1 × 5
Computed
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 The most expensive ticket to zero: the priciest contract that ended at two cents or less, derived from the stored result.
ColumnTypeRangeNotes
contract text 1 distinct value (O:MU260612C01350000)
first_price number every row is 10 US dollars
last_price number every row is 0.01 US dollars
contracts_a_thousand_bought number every row is 1 count
ending_value_usd number every row is 1 US dollars

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

the exact SQL behind every number 
SELECT ticker AS contract,
    round(first_px, 2) AS first_price,
    round(last_px, 2) AS last_price,
    toUInt32(floor(1000 / (first_px * 100))) AS contracts_a_thousand_bought,
    round(floor(1000 / (first_px * 100)) * last_px * 100, 0) AS ending_value_usd
FROM (
    SELECT ticker,
        toFloat64(argMin(price, (sip_timestamp, price))) AS first_px,
        toFloat64(argMax(price, (sip_timestamp, price))) AS last_px,
        count() AS trades
    FROM global_markets.options_trades
    WHERE ((startsWith(ticker, 'O:MU') AND length(ticker) = 19) OR (startsWith(ticker, 'O:NVDA') AND length(ticker) = 21) OR (startsWith(ticker, 'O:TSLA') AND length(ticker) = 21) OR (startsWith(ticker, 'O:SPY') AND length(ticker) = 20) OR (startsWith(ticker, 'O:QQQ') AND length(ticker) = 20) OR (startsWith(ticker, 'O:AAPL') AND length(ticker) = 21))
      AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
    GROUP BY ticker
    HAVING count() >= 50 AND argMin(price, (sip_timestamp, price)) > 0
)
WHERE last_px <= 0.02 AND floor(1000 / (first_px * 100)) >= 1
ORDER BY first_px DESC, contract ASC
LIMIT 1

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 analysisThe Best and Worst Thousand Dollars of June 2026
The entry receipt: the winner's first print, its second, and every penny print of its June life (one row) scalar 1×11 → The full distribution: for every jackpot, thousands of near-total losses (put/call split included) scalar 1×10 → The ride, session by session: daily turnover, last price, and the thousand-dollar position's mark series 10×6 → The loss pile by root: contracts down 90%+ from first print, share of the pile, and each root's ten-baggers table 6×6 → Calibration: every month of 2026 computed identically, SPY and NVDA, open-to-close and range table 6×6 → The five biggest first-print-to-last-print multiples of June, priced from both chairs (six liquid roots, 50+ trades) table 5×9 → See all 2,170 queries →