title: Pandas: max value between two running intervals
body: <p>I have a dataframe with the following structure:</p>
  <p>Timestamp, Value, Start, End</p>
  <p>I would like to know for each row, the maximum value based on TimeStamp &gt;= Start &amp; TimeStamp &lt;= End</p>
  <p>I cannot use rolling.max() because the start &amp; end are not equally defined.</p>
  <p><img src="https://i.imgur.com/MEDPWog.png" alt="highest" /></p>
  <p>This is some data I have.. So basically for each row I would like to find the highest High[0] row where Time[0] is between Time[0] and Time[1]</p>