3,256 answered market questions

WITH
    0.70 AS costs_per_contract,
    (
        SELECT round(toFloat64(close), 2)
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'AAPL'
          AND date = '2026-02-20'
    ) AS entry_close,
    (
        SELECT toFloat64(strike_price)
        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 strike_level,
    (
        SELECT toFloat64(option_close)
        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 entry_premium
SELECT
    toString(date)                                              AS session_date,
    formatDateTime(date, '%b %e')                               AS session_label,
    round(toFloat64(any(close)), 2)                             AS aapl_close,
    round(strike_level, 2)                                      AS strike,
    round(strike_level + entry_premium + costs_per_contract / 100, 2) AS breakeven
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'AAPL'
  AND date BETWEEN '2026-02-20' AND '2026-03-20'
GROUP BY date
ORDER BY date