The daily mark on one AAPL March 2026 call: premium, intrinsic value, time value

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH
    (
        SELECT round(toFloat64(close), 2)
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'AAPL'
          AND date = '2026-02-20'
    ) AS entry_close,
    (
        SELECT ticker
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'AAPL'
          AND lower(option_type) LIKE 'c%'
          AND expiration_date = '2026-03-20'
          AND date = '2026-02-20'
          AND toFloat64(option_close) > 0
          AND toFloat64(strike_price) > entry_close
        ORDER BY strike_price
        LIMIT 1
    ) AS chosen_contract
SELECT
    toString(date)                                AS session_date,
    formatDateTime(date, '%b %e')                 AS session_label,
    toUInt16(any(g.days_to_expiry))               AS days_left,
    round(toFloat64(any(g.option_close)), 2)      AS premium,
    round(greatest(any(s.stock_close) - toFloat64(any(g.strike_price)), 0.0), 2) AS intrinsic_value,
    round(toFloat64(any(g.option_close))
          - greatest(any(s.stock_close) - toFloat64(any(g.strike_price)), 0.0), 2) AS time_value
FROM global_markets.options_greeks AS g
INNER JOIN
(
    SELECT
        date,
        toFloat64(close) AS stock_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'AAPL'
      AND date BETWEEN '2026-02-20' AND '2026-03-20'
) AS s USING (date)
WHERE g.ticker = chosen_contract
  AND date BETWEEN '2026-02-20' AND '2026-03-20'
GROUP BY date
ORDER BY date