I've attempted something that is based on your explanation, using J's DDL (many thanks), however, it doesn't return the same result set you have, if I'm reading it correct.
For starters, I have a value for 00:09:40, but that isn't in your table. I think 01:25:50 is also missing in yours, but it's in mine. Am I missing something?
SELECT id,
hist_timestamp,
DP,
mints,
secnds,
[value],
mv.MaxValue
FROM #yourtable yt
CROSS APPLY (SELECT MAX(ca.value) AS MaxValue
FROM #yourtable ca
WHERE ca.hist_timestamp BETWEEN yt.hist_timestamp AND DATEADD(SECOND, 60, yt.hist_timestamp)) mv;
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk