Wiindow Aggregate function

I post this question to Stack Overflow the other day and ended up providing my own solution.   

However,  the solution is incomplete. I need for arbitrary time intervals as described in my edit.

Any help would be greatly appreciated.

Herby