carry_illustration

Name: carry_illustration
Creator: Strasmore
Published: 2026-09-12
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-09-12, from what-are-single-stock-futures.

as of 2026-09-12 ranking 5×4read in context →

carry_illustration — 5 rows by 4 columns, computed 2026-09-12 from US exchange, SIP and OPRA data.
days_to_expiry	financing_usd	fair_price_no_dividend	fair_price_with_050_dividend
30	0.33	100.33	99.83
60	0.66	100.66	100.16
90	0.99	100.99	100.49
180	1.97	101.97	101.47
365	4	104	103.5

Rows × columns: 5 × 4
Computed: 2026-09-12
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 carry_illustration, derived from the stored result.
Column	Type	Range	Notes
`days_to_expiry`	number	30 to 365
`financing_usd`	number	0.33 to 4	US dollars
`fair_price_no_dividend`	number	100.33 to 104	US dollars
`fair_price_with_050_dividend`	number	99.83 to 103.5	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 2026-09-12, and the query below is what returned them.

the exact SQL behind every number

SELECT
    days_to_expiry,
    round(100 * 0.04 * days_to_expiry / 365, 2) AS financing_usd,
    round(100 + 100 * 0.04 * days_to_expiry / 365, 2) AS fair_price_no_dividend,
    round(100 + 100 * 0.04 * days_to_expiry / 365 - 0.50, 2) AS fair_price_with_050_dividend
FROM (SELECT arrayJoin([30, 60, 90, 180, 365]) AS days_to_expiry)
ORDER BY days_to_expiry

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 analysiswhat-are-single-stock-futures

margin_comparison ranking 4×4 → weekly_leaders ranking 25×4 → Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years) ranking 25×3 → SPY options median spread by expiration date, near-the-money strikes only ranking 25×4 → When market headlines publish, by New York clock hour ranking 24×2 → Stock headlines by ET hour of publication (last 30 days, all days) ranking 24×3 → See all 2,214 queries →