Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create type trange as range(subtype=time);
--above automatically creates `ttzmultirange` variant

CREATE TYPE


create table your_table("Id" int, "Time" time,"Value" int);
insert into your_table values
     (1, '10:10:05', 3)
    ,(1, '10:11:06', 4)
    ,(1, '10:13:13', 5)
    ,(1, '10:13:19', 9)
    ,(1, '10:13:32', 8)
    ,(1, '10:14:35', 2)
returning *;

CREATE TABLE




Id
Time
Value


1
10:10:05
3

1
10:11:06
4

1
10:13:13
5

1
10:13:19
9

1
10:13:32
8

1
10:14:35
2



INSERT 0 6


with param(target_range) as (
    values ('[10:12:00,10:14:00]'::trange))
,add_missing as (
    select date_trunc('minute',g-'1 minute'::interval)::time as start,
           date_trunc('minute',g)::time as end,
           (array_agg("Value" order by "Time"))[count(*)] end_value,
           min("Value"),
           max("Value")
    from param
    cross join generate_series(current_date + lower(target_range),
                              current_date + upper(target_range),
                         '1 minute')g
    left join your_table t on date_trunc('minute',g-'1 minute'::interval)::time
                             =date_trunc('minute',t."Time")
                          and g::time <@ target_range
    group by 1,2)
select "start","end", 
       ((jsonb_agg(end_value)filter(where end_value is not null)
             over w1)->>-1)::int as start_value,
       ((jsonb_agg(end_value)filter(where end_value is not null)
             over w1)->>-1)::int as end_value,
       ((jsonb_agg(min)filter(where min is not null)
             over w1)->>-1)::int as min,
       ((jsonb_agg(max)filter(where max is not null)
             over w1)->>-1)::int as max
from add_missing
window w1 as (order by start)
offset 1;


start
end
start_value
end_value
min
max


10:12:00
10:13:00
4
4
4
4

10:13:00
10:14:00
8
8
5
9



SELECT 2
Id	Time	Value
1	10:10:05	3
1	10:11:06	4
1	10:13:13	5
1	10:13:19	9
1	10:13:32	8
1	10:14:35	2