Showing data from the past 5 years
(anchored to the latest snapshot in the public archive)
HN Trends
A field guide to Hacker News
Every Hacker News story, every user, queried live from the public ClickHouse archive.
The pulse
Live counts for the selected window. Stories, comments, karma awarded, distinct users active.
Reading the pulse
Karma Tides
Monthly story volume for a handful of perennial Hacker News obsessions, rendered as a streamgraph with a centred baseline.
SOURCE · COUNTIF(TITLE ILIKE) PER MONTH · STREAMGRAPH
Plotting the tides
The Heartbeat
When Hacker News sleeps and when it wakes. Cell shade is submission volume in the selected window.
SOURCE · GROUP BY HOUR × DAY-OF-WEEK · UTC
Listening for the beat
Precision over Volume
Users with the best average score per story in the selected window. Minimum 30 submissions, to weed out the one-hit wonders.
SOURCE · AVG(SCORE) BY USER · TYPE='STORY'
Tallying the precision board
More opinionated rankings on the Leaderboards page.