annual_net

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(toYear(d.ex_dividend_date))                     AS year,
    round(sumIf(d.amt, d.ticker = 'QQQ'), 4)                 AS qqq_gross_usd,
    round(sumIf(d.amt, d.ticker = 'QQQ') * 0.85, 4)          AS qqq_net_usd,
    round(sumIf(d.amt, d.ticker = 'SPY'), 4)                 AS spy_gross_usd,
    round(sumIf(d.amt, d.ticker = 'SPY') * 0.85, 4)          AS spy_net_usd
FROM
(
    SELECT
        ticker,
        ex_dividend_date,
        toFloat64(max(cash_amount)) AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('QQQ', 'SPY')
      AND ex_dividend_date >= '2019-01-01'
      AND ex_dividend_date <  '2026-01-01'
    GROUP BY ticker, ex_dividend_date
) AS d
GROUP BY year
HAVING qqq_gross_usd > 0 AND spy_gross_usd > 0
ORDER BY year