2,401 answered market questions

SELECT
    symbol,
    priced_on,
    expiry,
    round(100 * put_iv_25d, 2)                     AS put_25d_iv_pct,
    round(100 * call_iv_25d, 2)                    AS call_25d_iv_pct,
    round(100 * (put_iv_25d - call_iv_25d), 2)     AS risk_reversal_pct
FROM
(
    SELECT
        underlying_symbol                                                                  AS symbol,
        concat(monthName(any(date)), ' ', toString(toDayOfMonth(any(date))), ', ',
               toString(toYear(any(date))))                                                AS priced_on,
        concat(monthName(expiration_date), ' ', toString(toDayOfMonth(expiration_date)), ', ',
               toString(toYear(expiration_date)))                                          AS expiry,
        any(days_to_expiry)                                                                AS dte,
        maxIf(-delta, delta < 0 AND -delta <= 0.25)                                        AS p_lo_d,
        argMaxIf(implied_volatility, -delta, delta < 0 AND -delta <= 0.25)                 AS p_lo_iv,
        minIf(-delta, delta < 0 AND -delta >= 0.25)                                        AS p_hi_d,
        argMinIf(implied_volatility, -delta, delta < 0 AND -delta >= 0.25)                 AS p_hi_iv,
        maxIf(delta, delta > 0 AND delta <= 0.25)                                          AS c_lo_d,
        argMaxIf(implied_volatility, delta, delta > 0 AND delta <= 0.25)                   AS c_lo_iv,
        minIf(delta, delta > 0 AND delta >= 0.25)                                          AS c_hi_d,
        argMinIf(implied_volatility, delta, delta > 0 AND delta >= 0.25)                   AS c_hi_iv,
        if(p_hi_d = p_lo_d, p_lo_iv,
           p_lo_iv + (p_hi_iv - p_lo_iv) * (0.25 - p_lo_d) / (p_hi_d - p_lo_d))           AS put_iv_25d,
        if(c_hi_d = c_lo_d, c_lo_iv,
           c_lo_iv + (c_hi_iv - c_lo_iv) * (0.25 - c_lo_d) / (c_hi_d - c_lo_d))           AS call_iv_25d
    FROM global_markets.options_greeks
    WHERE underlying_symbol IN ('SPY', 'AAPL', 'TSLA')
      AND date = (
          SELECT max(date)
          FROM global_markets.options_greeks
          WHERE underlying_symbol = 'SPY'
            AND date >= today() - 14
      )
      AND iv_converged = 1
      AND volume > 0
      AND abs(delta) BETWEEN 0.05 AND 0.5
    GROUP BY underlying_symbol, expiration_date
    HAVING countIf(delta < 0 AND -delta <= 0.25) > 0
       AND countIf(delta < 0 AND -delta >= 0.25) > 0
       AND countIf(delta > 0 AND delta <= 0.25) > 0
       AND countIf(delta > 0 AND delta >= 0.25) > 0
       AND dte BETWEEN 20 AND 45
    ORDER BY symbol, abs(dte - 30)
    LIMIT 1 BY symbol
)
ORDER BY indexOf(['SPY', 'AAPL', 'TSLA'], symbol)