STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Payment in Lieu of Dividends, Explained
PFE short interest by settlement date, Aug 2025 through Jul 2026series · 2026-08-22 · 24×3Preview: a 16-point series, ending higher. Ex-dividend events per month across the whole US calendarseries · 2026-08-22 · 12×4Preview: a 12-point series, roughly flat. The most recent regular dividend for eleven household namestable · 2026-08-22 · 11×5 Reported short interest across the same dividend payersranking · 2026-08-22 · 11×3Preview: 11 ranked values, largest first.
PFE short interest by settlement date, Aug 2025 through Jul 2026

PFE short interest by settlement date, Aug 2025 through Jul 2026

most recentas of series 24×3read in context →
PFE short interest by settlement date, Aug 2025 through Jul 2026 — 24 rows by 3 columns, computed from US exchange, SIP and OPRA data.
settlement_daysettled_labelshort_interest_millions
2025-08-15Aug 15, 2025113.8
2025-08-29Aug 29, 2025103.5
2025-09-15Sep 15, 2025112.9
2025-09-30Sep 30, 2025114
2025-10-15Oct 15, 2025116.8
2025-10-31Oct 31, 2025126.6
2025-11-14Nov 14, 2025130.7
2025-11-28Nov 28, 2025139.1
2025-12-15Dec 15, 2025139.5
2025-12-31Dec 31, 2025130
2026-01-15Jan 15, 2026129.8
2026-01-30Jan 30, 2026143
2026-02-13Feb 13, 2026146.4
2026-02-27Feb 27, 2026142.8
2026-03-13Mar 13, 2026131.4
2026-03-31Mar 31, 2026132.5
2026-04-15Apr 15, 2026133.4
2026-04-30Apr 30, 2026140.3
2026-05-15May 15, 2026157.5
2026-05-29May 29, 2026162.7
2026-06-15Jun 15, 2026162.1
2026-06-30Jun 30, 2026163.6
2026-07-15Jul 15, 2026163.8
2026-07-31Jul 31, 2026161.5
the exact SQL behind every number 
SELECT
    toString(settlement_date)                     AS settlement_day,
    formatDateTime(settlement_date, '%b %e, %Y')  AS settled_label,
    round(max(short_interest) / 1e6, 1)           AS short_interest_millions
FROM global_markets.stocks_short_interest
WHERE ticker = 'PFE'
  AND settlement_date >= '2025-08-01'
  AND settlement_date <  '2026-08-01'
GROUP BY settlement_date
ORDER BY settlement_date
More from this analysisPayment in Lieu of Dividends, Explained
Ex-dividend events per month across the whole US calendar series 12×4 → The most recent regular dividend for eleven household names table 11×5 → Reported short interest across the same dividend payers ranking 11×3 → Share of reported KO volume marked short, by session series 69×3 → See all 2,173 queries →
$