STRASMORE/EXPLORE 3,171 QUERIES

profil_delais

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-10-07, from days-from-ex-date-to-dividend-payment.

as of ranking 6×3read in context →
profil_delais — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
bucketevents_countpart_pct
0 à 7 jours10019245
8 à 14 jours4069118
15 à 21 jours4918022
22 à 28 jours110485
29 à 35 jours80724
36 jours et plus134176
Rows × columns
6 × 3
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for profil_delais, derived from the stored result.
ColumnTypeRangeNotes
bucket text 6 distinct values
events_count number 8,072 to 100,192 count
part_pct number 4 to 45 percent

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    multiIf(delai <=  7, '0 à 7 jours',
            delai <= 14, '8 à 14 jours',
            delai <= 21, '15 à 21 jours',
            delai <= 28, '22 à 28 jours',
            delai <= 35, '29 à 35 jours',
                         '36 jours et plus')                   AS bucket,
    count()                                                     AS events_count,
    toUInt16(round(100 * count() / sum(count()) OVER ()))       AS part_pct
FROM
(
    SELECT dateDiff('day', ex_dividend_date, pay_date) AS delai
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date >= '2021-10-01'
      AND ex_dividend_date <  '2026-10-01'
      AND cash_amount > 0
      AND pay_date > ex_dividend_date
      AND dateDiff('day', ex_dividend_date, pay_date) <= 120
    GROUP BY ticker, ex_dividend_date, pay_date
)
GROUP BY bucket
ORDER BY min(delai)
⌘/Ctrl + Enter

Travaillez ces données dans votre assistant IA

S'ouvre prêt à interroger, avec les données de cette page. Gratuit, sans compte.

Claude ChatGPT Gemini Muse Votre propre agent