This is interesting, but we’d have to come up with a clever way to exclude bumped topics.
The announcement of Discourse's Fourth Birthday is currently ranked at the top for the past year. It was bumped in November. So the logic can’t be quite as simple as “include older topics with any new activity within the date range” because then this would be at the top of the past quarter as well, which is not desirable.