什么是补仓天数？卖空权益比率解读

SELECT ticker,
       round(short_interest / 1e6, 1) AS shares_short_m,
       round(avg_daily_volume / 1e6, 1) AS avg_daily_volume_m,
       round(days_to_cover, 2) AS days_to_cover
FROM global_markets.stocks_short_interest
WHERE settlement_date = '2026-06-30'
  AND ticker IN ('AAPL', 'GME', 'MU', 'TSLA')
ORDER BY ticker

SELECT multiIf(days_to_cover <= 1, '1 (the reported floor)',
               days_to_cover < 2, '>1 to 2 days',
               days_to_cover < 5, '2 to 5 days',
               days_to_cover < 10, '5 to 10 days',
               '10+ days') AS bucket,
       count() AS names
FROM global_markets.stocks_short_interest
WHERE settlement_date = '2026-06-30'
  AND avg_daily_volume >= 5000000
  AND days_to_cover IS NOT NULL
GROUP BY bucket
ORDER BY min(days_to_cover)

SELECT multiIf(avg_daily_volume < 1000000, 'under 1M shares/day',
               avg_daily_volume < 5000000, '1M to 5M',
               avg_daily_volume < 20000000, '5M to 20M',
               '20M+ shares/day') AS adv_tier,
       count() AS names,
       if(count() < 1000,
          toString(count()),
          concat(toString(intDiv(count(), 1000)), ',', leftPad(toString(count() % 1000), 3, '0'))) AS names_fmt,
       round(min(days_to_cover), 2) AS lowest_reported,
       round(quantileDeterministic(0.5)(days_to_cover, cityHash64(ticker)), 2) AS median_days_to_cover,
       round(countIf(days_to_cover >= 5) / count() * 100, 1) AS pct_above_5_days,
       round(countIf(days_to_cover = 1) / count() * 100, 1) AS pct_at_floor
FROM global_markets.stocks_short_interest
WHERE settlement_date = '2026-06-30'
  AND days_to_cover IS NOT NULL
  AND avg_daily_volume > 0
GROUP BY adv_tier
ORDER BY min(avg_daily_volume)

SELECT ticker,
       round(days_to_cover, 2) AS days_to_cover,
       round(short_interest / 1e6, 1) AS shares_short_m,
       round(avg_daily_volume / 1e6, 1) AS avg_daily_volume_m
FROM global_markets.stocks_short_interest
WHERE settlement_date = '2026-06-30'
  AND avg_daily_volume >= 5000000
  AND days_to_cover IS NOT NULL
  AND ticker NOT IN ('SPCX')
ORDER BY days_to_cover DESC, ticker ASC
LIMIT 12

SELECT settlement_date,
       round(days_to_cover, 2) AS days_to_cover,
       round(max(days_to_cover) OVER (ORDER BY settlement_date), 2) AS peak_days_to_cover,
       round(short_interest / 1e6, 1) AS shares_short_m,
       round(avg_daily_volume / 1e6, 1) AS avg_daily_volume_m
FROM global_markets.stocks_short_interest
WHERE ticker = 'GME'
  AND settlement_date >= '2020-06-30'
  AND settlement_date <= '2021-01-29'
ORDER BY settlement_date

WITH share_counts AS (
    SELECT ticker,
           argMax(market_cap / price, date) AS shares_outstanding,
           argMax(date, date) AS as_of
    FROM global_markets.stocks_ratios
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'TSLA', 'MU', 'GME')
      AND market_cap > 0
      AND price > 0
    GROUP BY ticker
)
SELECT si.ticker AS ticker,
       round(si.short_interest / 1e6, 1) AS shares_short_m,
       round(si.short_interest / sc.shares_outstanding * 100, 2) AS pct_of_shares_out,
       round(si.days_to_cover, 2) AS days_to_cover,
       formatDateTimeInJodaSyntax(sc.as_of, 'MMMM d, yyyy') AS share_count_as_of
FROM global_markets.stocks_short_interest AS si
INNER JOIN share_counts AS sc ON sc.ticker = si.ticker
WHERE si.settlement_date = '2026-06-30'
ORDER BY pct_of_shares_out DESC

SELECT settlement_date,
       formatDateTimeInJodaSyntax(settlement_date, 'MMMM d, yyyy') AS settlement_label,
       formatDateTime(toDate(min(_ingest_time)), '%Y-%m-%d') AS arrived_in_warehouse,
       dateDiff('day', settlement_date, toDate(min(_ingest_time))) AS lag_days,
       count() AS names_reported,
       if(count() < 1000,
          toString(count()),
          concat(toString(intDiv(count(), 1000)), ',', leftPad(toString(count() % 1000), 3, '0'))) AS names_reported_fmt
FROM global_markets.stocks_short_interest
WHERE settlement_date >= '2026-03-01'
  AND settlement_date <= '2026-06-30'
GROUP BY settlement_date
ORDER BY settlement_date