SQL How to query for earliest stock price? : <p>I have a table that has rows for various stock prices at various times of the day for many different companies.  Each row is a stocks price at a particular time of day. The times are not the same for each stock. </p>

<p>I can't figure out how to query for the price of each stock at the earliest time point. </p>

<p>For example, from the below example table I would want the query to return:
ABC 1.25
XYZ 0.95</p>

<p><em>[Stock]</em>      <em>[Trade Time]</em>    <em>[Price]</em></p>

<p>ABC            9:35            1.25</p>

<p>ABC       9:55          1.15</p>

<p>ABC      10:35          1.50</p>

<p>XYZ       9:47          0.95</p>

<p>XYZ       9:53          1.00</p>

<p>XYZ      11:10          0.85</p>
