yield_trace

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.

WITH
(
    SELECT argMax(cash_amount, ex_dividend_date)
    FROM global_markets.stocks_dividends
    WHERE ticker = 'IBM'
      AND ex_dividend_date <= today()
) AS letzte_quartalsdividende
SELECT
    toString(handelsdatum)                                                              AS date,
    formatDateTime(handelsdatum, '%d.%m.%Y')                                            AS handelstag,
    round(toFloat64(schluss), 2)                                                        AS schlusskurs_usd,
    round(toFloat64(letzte_quartalsdividende) * 4 / toFloat64(schluss) * 100, 2)        AS rendite_pct
FROM
(
    SELECT
        toDate(date) AS handelsdatum,
        close        AS schluss
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'IBM'
      AND date >= today() - 30
      AND date <= today()
)
ORDER BY handelsdatum