STRASMORE/EXPLORE 2,830 QUERIES

distribution_history

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-09-30, from how-to-invest-in-the-dax.

as of series 14×4read in context →
distribution_history — 14 rows by 4 columns, computed from US exchange, SIP and OPRA data.
dateex_date_labelcash_per_sharepct_of_price
2018-06-19Jun 19, 20180.74372.41
2019-06-17Jun 17, 20190.73812.74
2020-06-15Jun 15, 20200.27981.04
2020-12-14Dec 14, 20200.24930.81
2021-06-10Jun 10, 20210.60341.7
2021-12-13Dec 13, 20210.03580.11
2021-12-30Dec 30, 20210.24730.75
2022-06-09Jun 9, 20220.79193.09
2022-12-13Dec 13, 20220.00860.03
2023-06-07Jun 7, 20230.75872.75
2023-12-20Dec 20, 20230.00150.01
2024-06-11Jun 11, 20240.75852.47
2025-06-16Jun 16, 20250.67931.65
2026-06-15Jun 15, 20260.83161.99
Rows × columns
14 × 4
Period covered
to
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 distribution_history, derived from the stored result.
ColumnTypeRangeNotes
date date 2018-06-19 to 2026-06-15
ex_date_label text 14 distinct values (Dec 13, 2021, Dec 13, 2022, Dec 14, 2020…)
cash_per_share number 0.0015 to 0.8316
pct_of_price number 0.01 to 3.09 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
    toString(d.ex_date)                                   AS date,
    formatDateTime(d.ex_date, '%b %e, %Y')                AS ex_date_label,
    round(d.cash_per_share, 4)                            AS cash_per_share,
    round(100 * d.cash_per_share / toFloat64(p.close), 2) AS pct_of_price
FROM
(
    SELECT
        ex_dividend_date            AS ex_date,
        max(toFloat64(cash_amount)) AS cash_per_share
    FROM global_markets.stocks_dividends
    WHERE ticker = 'EWG'
      AND ex_dividend_date >= '2018-01-01'
    GROUP BY ex_dividend_date
) AS d
INNER JOIN
(
    SELECT date, close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'EWG'
      AND date >= '2018-01-01'
) AS p ON p.date = d.ex_date
ORDER BY date
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysishow-to-invest-in-the-dax
us_session_clock series 36×3 → index_versions ranking 15×4 → The 2s10s spread by month, full history series 604×5 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → The 5s30s spread month by month, with both legs series 241×4 → 5s30s and 2s10s, monthly averages over 20 years series 241×3 → See all 2,830 queries →