premium_harian

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 anchor AS
    (
        SELECT max(date) AS d_max
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'AAPL'
    )
SELECT
    toString(date)                           AS session_date,
    any(formatDateTime(date, '%d/%m/%Y'))    AS tarikh_label,
    round(avg(toFloat64(option_close)), 2)   AS premium_usd,
    round(100 * avg(implied_volatility), 1)  AS iv_pct
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
  AND date >= (SELECT d_max FROM anchor) - 60
  AND iv_converged = 1
  AND volume > 0
  AND toFloat64(delta) BETWEEN 0.35 AND 0.65
  AND days_to_expiry BETWEEN 20 AND 45
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
GROUP BY session_date
ORDER BY session_date