blk_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.

SELECT
    toString(ex_dividend_date)                     AS ex_date,
    formatDateTime(ex_dividend_date, '%b %e, %Y')  AS ex_label,
    formatDateTime(prev_session, '%a, %b %e')      AS last_us_session,
    formatDateTime(
        toTimeZone(
            toDateTime(concat(toString(prev_session), ' 16:00:00'), 'America/New_York'),
            'Asia/Manila'),
        '%a, %b %e, %I:%i %p')                     AS manila_cutoff,
    round(declared_amount, 4)                      AS cash_amount
FROM
(
    WITH
        (
            SELECT groupArray(date)
            FROM global_markets.stocks_daily_aggs
            WHERE ticker = 'BLK'
              AND date >= '2023-06-01'
        ) AS blk_sessions
    SELECT
        ex_dividend_date,
        max(cash_amount) AS declared_amount,
        arrayReverseSort(arrayFilter(s -> s < ex_dividend_date, blk_sessions))[1] AS prev_session
    FROM global_markets.stocks_dividends
    WHERE ticker = 'BLK'
      AND cash_amount > 0
      AND ex_dividend_date >= '2024-01-01'
      AND ex_dividend_date <  today()
    GROUP BY ex_dividend_date
)
ORDER BY ex_date