Daily Returns / SQL Server 2012+

gistfile1.sql

SELECT
    Date
    ,Value
    ,CAST(ROUND(100 * (Value / LAG(Value, 1, Value) OVER (ORDER BY Date) - 1), 2)  AS NUMERIC(16, 2)) AS 'Return'
FROM Totals
ORDER BY Date;