Unnamed

SELECT STOCKS.SYMBOL, MIN( STOCKS.DATE ) AS MINDATE, MAX( STOCKS.DATE ) AS MAXDATE, (
 SELECT SUM( CLOSE )
 FROM STOCKS v1
 WHERE v1.SYMBOL = STOCKS.SYMBOL
 AND v1.DATE <= MAXDATE
 AND v1.DATE >= MINDATE
) AS CLOSE
FROM STOCKS
LIMIT 0 , 2