Anonymous
public text v1 · immutableSELECT SYMBOL, DATE, SUM( CLOSE )
FROM STOCKS
WHERE DATE <= DATE
AND DATE >= (
SELECT DATE
FROM STOCKS v1
WHERE v1.date <= STOCKS.DATE
ORDER BY DATE DESC
LIMIT 2 , 1 )
GROUP BY STOCKS.SYMBOL, STOCKS.DATESELECT SYMBOL, DATE, SUM( CLOSE )
FROM STOCKS
WHERE DATE <= DATE
AND DATE >= (
SELECT DATE
FROM STOCKS v1
WHERE v1.date <= STOCKS.DATE
ORDER BY DATE DESC
LIMIT 2 , 1 )
GROUP BY STOCKS.SYMBOL, STOCKS.DATE