哪些股票有 weekly options？如何從選擇權鏈判斷

SELECT
    toString(expiration_date)                                   AS expiry_date,
    concat(formatDateTime(expiration_date, '%a %b '),
           toString(toDayOfMonth(expiration_date)))              AS expiry_label,
    if(toDayOfWeek(expiration_date) = 5
       AND toDayOfMonth(expiration_date) BETWEEN 15 AND 21,
       'monthly (third Friday)', 'weekly')                      AS series_type,
    min(days_to_expiry)                                         AS dte,
    uniqExact(ticker)                                           AS contracts_traded
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
  AND date = toDate('2026-08-24')
  AND days_to_expiry <= 130
  AND volume > 0
GROUP BY expiration_date
ORDER BY expiration_date

SELECT
    bucket,
    count()                                                          AS underlyings
FROM
(
    SELECT
        underlying_symbol,
        arrayJoin([
            'A. All underlyings with a traded contract',
            multiIf(non_monthly_dates = 0, 'B. Third Friday only (monthly)',
                    weekdays_used >= 5,    'D. Weekly, every weekday Mon to Fri',
                                           'C. Weekly or quarterly, not every weekday')
        ])                                                           AS bucket
    FROM
    (
        SELECT
            underlying_symbol,
            uniqExactIf(expiration_date,
                NOT (toDayOfWeek(expiration_date) = 5
                     AND toDayOfMonth(expiration_date) BETWEEN 15 AND 21)) AS non_monthly_dates,
            uniqExact(toDayOfWeek(expiration_date))                        AS weekdays_used
        FROM global_markets.options_greeks
        WHERE date >= today() - 35
          AND date < today()
          AND expiration_date < today() + 60
          AND toDayOfWeek(expiration_date) <= 5
          AND volume > 0
          AND underlying_symbol NOT IN ('SPCX')
        GROUP BY underlying_symbol
    )
)
GROUP BY bucket
ORDER BY bucket

SELECT
    multiIf(
        toDayOfWeek(expiration_date) = 5
            AND toDayOfMonth(expiration_date) BETWEEN 15 AND 21, 'F. Third Friday (monthly)',
        toDayOfWeek(expiration_date) = 5,                       'E. Other Friday (weekly)',
        toDayOfWeek(expiration_date) = 4,                       'D. Thursday',
        toDayOfWeek(expiration_date) = 3,                       'C. Wednesday',
        toDayOfWeek(expiration_date) = 2,                       'B. Tuesday',
                                                                'A. Monday') AS bucket,
    uniqExact(underlying_symbol)                                            AS underlyings
FROM global_markets.options_greeks
WHERE date >= today() - 35
  AND date < today()
  AND expiration_date < today() + 60
  AND toDayOfWeek(expiration_date) <= 5
  AND volume > 0
  AND underlying_symbol NOT IN ('SPCX')
GROUP BY bucket
ORDER BY bucket

SELECT
    underlying_symbol                                           AS symbol,
    round(uniqExact(ticker) / 1000, 1)                          AS contracts_thousands,
    uniqExactIf(expiration_date,
        NOT (toDayOfWeek(expiration_date) = 5
             AND toDayOfMonth(expiration_date) BETWEEN 15 AND 21)) AS non_monthly_expirations,
    arrayStringConcat(
        arrayMap(d -> arrayElement(['Mon', 'Tue', 'Wed', 'Thu', 'Fri'], d),
                 arraySort(groupUniqArray(toDayOfWeek(expiration_date)))),
        ' ')                                                    AS expiry_weekdays
FROM global_markets.options_greeks
WHERE date >= today() - 35
  AND date < today()
  AND expiration_date < today() + 60
  AND toDayOfWeek(expiration_date) <= 5
  AND volume > 0
  AND underlying_symbol NOT IN ('SPCX')
GROUP BY underlying_symbol
HAVING non_monthly_expirations > 0
ORDER BY contracts_thousands DESC, symbol
LIMIT 25