Mine

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