select stock_id, date, min(close) from prices where stock_id=4 AND date > ''2004-01-01'' group by stock_id, date