STRASMORE/EXPLORE 3,293 QUERIES

withholding_math

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-24, from att-dividend-for-foreign-shareholders.

as of series 12×5read in context →
withholding_math — 12 rows by 5 columns, computed from US exchange, SIP and OPRA data.
ex_dateex_date_labelgross_usdwithheld_usdnet_usd
2024-01-099 января 202427.758.3319.42
2024-04-099 апреля 202427.758.3319.42
2024-07-1010 июля 202427.758.3319.42
2024-10-1010 октября 202427.758.3319.42
2025-01-1010 января 202527.758.3319.42
2025-04-1010 апреля 202527.758.3319.42
2025-07-1010 июля 202527.758.3319.42
2025-10-1010 октября 202527.758.3319.42
2026-01-1212 января 202627.758.3319.42
2026-04-1010 апреля 202627.758.3319.42
2026-07-1010 июля 202627.758.3319.42
2026-10-099 октября 202627.758.3319.42
Rows × columns
12 × 5
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 withholding_math, derived from the stored result.
ColumnTypeRangeNotes
ex_date date 2024-01-09 to 2026-10-09
ex_date_label text 12 distinct values
gross_usd number every row is 27.75 US dollars
withheld_usd number every row is 8.33 US dollars
net_usd number every row is 19.42 US dollars

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(ex) AS ex_date,
    concat(
        toString(toDayOfMonth(ex)), ' ',
        ['января','февраля','марта','апреля','мая','июня','июля','августа','сентября','октября','ноября','декабря'][toMonth(ex)], ' ',
        toString(toYear(ex))
    ) AS ex_date_label,
    round(amt * 100, 2)        AS gross_usd,
    round(amt * 100 * 0.30, 2) AS withheld_usd,
    round(amt * 100 * 0.70, 2) AS net_usd
FROM
(
    SELECT
        ex_dividend_date            AS ex,
        toFloat64(max(cash_amount)) AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'T'
      AND ex_dividend_date >= '2024-01-01'
    GROUP BY ex
)
ORDER BY ex
⌘/Ctrl + Enter

Work with this data in your AI assistant

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

Claude ChatGPT Gemini Muse Your own agent