Earnings headlines by the hour on a Beijing clock, Q3 2026

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 tagged AS
(
    SELECT
        toHour(toTimeZone(published_utc, 'Asia/Shanghai')) AS cst_hour,
        count()                                            AS items
    FROM global_markets.stocks_news
    WHERE published_utc >= '2026-07-01 00:00:00'
      AND published_utc <  '2026-10-01 00:00:00'
      AND positionCaseInsensitive(title, 'earnings') > 0
    GROUP BY cst_hour
),
hours AS
(
    SELECT
        spine.h                        AS h,
        toUInt32(sum(tagged.items))    AS headlines
    FROM (SELECT arrayJoin(range(24)) AS h) AS spine
    LEFT JOIN tagged ON tagged.cst_hour = spine.h
    GROUP BY spine.h
)
SELECT
    concat(leftPad(toString(h), 2, '0'), ':00')             AS beijing_clock,
    concat(leftPad(toString((h + 12) % 24), 2, '0'), ':00') AS et_clock_summer,
    headlines,
    round(100 * headlines / sum(headlines) OVER (), 2)      AS pct_of_headlines
FROM hours
ORDER BY h