hot_rank_now_minus1second_score_250 |        current_now         
-------------------------------------+----------------------------
                                6899 | 2023-08-18 19:02:54.807922
(1 row)

 hot_rank_now_minus1day_score_250 |        current_now         
----------------------------------+----------------------------
                               68 | 2023-08-17 19:02:55.808032
(1 row)

 hot_rank_now_minus2day_score_250 |        current_now         
----------------------------------+----------------------------
                               21 | 2023-08-16 19:02:55.808132
(1 row)

 hot_rank_now_minus3day_score_250 |        current_now        
----------------------------------+---------------------------
                               10 | 2023-08-15 19:02:55.80823
(1 row)

 hot_rank_now_minus6day_score_250 |        current_now         
----------------------------------+----------------------------
                                3 | 2023-08-12 19:02:55.808326
(1 row)

 hot_rank_now_minus9day_score_250 |        current_now         
----------------------------------+----------------------------
                                1 | 2023-08-09 19:02:55.808419
(1 row)

 hot_rank_now_minus12day_score_250 |        current_now         
-----------------------------------+----------------------------
                                 0 | 2023-08-06 19:02:55.808512
(1 row)

 hot_rank_now_minus22day_score_250 |        current_now         
-----------------------------------+----------------------------
                                 0 | 2023-07-27 19:02:55.808606
(1 row)

from

executing this:

-- when does hot_rank go flat like old soda?

SELECT hot_rank(250::numeric, timezone('utc', now() - interval '1 second')) AS hot_rank_now_minus1second_score_250, timezone('utc', now() - interval '1 second') AS current_now;

SELECT hot_rank(250::numeric, timezone('utc', now() - interval '1 day')) AS hot_rank_now_minus1day_score_250, timezone('utc', now() - interval '1 day') AS current_now;

SELECT hot_rank(250::numeric, timezone('utc', now() - interval '2 day')) AS hot_rank_now_minus2day_score_250, timezone('utc', now() - interval '2 day') AS current_now;

SELECT hot_rank(250::numeric, timezone('utc', now() - interval '3 day')) AS hot_rank_now_minus3day_score_250, timezone('utc', now() - interval '3 day') AS current_now;

SELECT hot_rank(250::numeric, timezone('utc', now() - interval '6 day')) AS hot_rank_now_minus6day_score_250, timezone('utc', now() - interval '6 day') AS current_now;

SELECT hot_rank(250::numeric, timezone('utc', now() - interval '9 day')) AS hot_rank_now_minus9day_score_250, timezone('utc', now() - interval '9 day') AS current_now;

SELECT hot_rank(250::numeric, timezone('utc', now() - interval '12 day')) AS hot_rank_now_minus12day_score_250, timezone('utc', now() - interval '12 day') AS current_now;

SELECT hot_rank(250::numeric, timezone('utc', now() - interval '22 day')) AS hot_rank_now_minus22day_score_250, timezone('utc', now() - interval '22 day') AS current_now;