shel_worked

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
    date,
    ex_label,
    gross_usd,
    uk_withholding_usd,
    adr_fee_usd,
    net_usd
FROM
(
    SELECT
        toString(ex_dividend_date)                   AS date,
        formatDateTime(ex_dividend_date, '%d %b %Y') AS ex_label,
        round(toFloat64(cash) * 100, 2)              AS gross_usd,
        round(toFloat64(cash) * 100 * 0.0, 2)        AS uk_withholding_usd,
        round(100 * 0.01, 2)                         AS adr_fee_usd,
        round(toFloat64(cash) * 100 - 100 * 0.01, 2) AS net_usd
    FROM
    (
        SELECT
            ex_dividend_date,
            any(cash_amount) AS cash
        FROM global_markets.stocks_dividends
        WHERE ticker = 'SHEL'
          AND currency = 'USD'
          AND ex_dividend_date <= today()
        GROUP BY ex_dividend_date
        ORDER BY ex_dividend_date DESC
        LIMIT 4
    )
)
ORDER BY date