Maybe something like https://github.com/citusdata/pg_cron https://github.com/citusdata/pg_cron or if it's not a rolling time window, just trigger functions that

Maybe something like https://github.com/citusdata/pg_cron https://github.com/citusdata/pg_cron or if it's not a rolling time window, just trigger functions that get called whenever some expression in SQL is true.