close_at_65

Name: close_at_65
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 fed-call-vs-house-call.

as of 2026-09-12 table 2×7read in context →

close_at_65 — 2 rows by 7 columns, computed 2026-09-12 from US exchange, SIP and OPRA data.
call_type	requirement_pct	market_value_usd	equity_usd	required_equity_usd	call_usd	sale_to_clear_usd
House call (30%)	30	13000	3000	3900	900	3000
Exchange call (25%)	25	13000	3000	3250	250	1000

Rows × columns: 2 × 7
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 close_at_65, derived from the stored result.
Column	Type	Range	Notes
`call_type`	text	2 distinct values (Exchange call (25%), House call (30%))
`requirement_pct`	number	25 to 30	percent
`market_value_usd`	number	every row is 13,000	US dollars
`equity_usd`	number	every row is 3,000	US dollars
`required_equity_usd`	number	3,250 to 3,900	US dollars
`call_usd`	number	250 to 900	US dollars
`sale_to_clear_usd`	number	1,000 to 3,000	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
    call_type,
    requirement_pct,
    market_value_usd,
    equity_usd,
    required_equity_usd,
    required_equity_usd - equity_usd                                    AS call_usd,
    round((required_equity_usd - equity_usd) / (requirement_pct / 100)) AS sale_to_clear_usd
FROM
(
    SELECT
        call_type,
        requirement_pct,
        200 * 65                                AS market_value_usd,
        200 * 65 - 10000                        AS equity_usd,
        round(200 * 65 * requirement_pct / 100) AS required_equity_usd
    FROM
    (
        SELECT 'House call (30%)' AS call_type, 30 AS requirement_pct
        UNION ALL
        SELECT 'Exchange call (25%)', 25
    )
)
ORDER BY call_usd DESC

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 analysisfed-call-vs-house-call

margin_call_lines table 3×5 → The 2s10s spread, every print of the half table 124×2 → The 2s10s spread, every print of the half table 124×2 → Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 → SPY at one-minute resolution, 2:00–3:30 pm ET on May 6, 2010 table 90×4 → Executed volume by price level: the traded ladder (KO, 30 minutes) table 63×3 → See all 2,214 queries →