MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT ID, @cumu_return:=IF(id = 1, 1, @cumu_return + (@cumu_return * ret)) AS cumulative_return

FROM (

SELECT 1 AS ID, 1 AS num, 0.1 AS ret UNION ALL

SELECT 2 AS ID, 1 AS num, 0.1 AS ret UNION ALL

SELECT 3 AS ID, 1 AS num, 0.1 AS ret UNION ALL

SELECT 4 AS ID, 1 AS num, 0.1 AS ret UNION ALL

SELECT 5 AS ID, 1 AS num, 0.1 AS ret

) t cross join (select @cumu_return := 0) p

with daily_return as (

SELECT 1 AS id, 1 AS last_return, 0.1 AS daily_return, null as last_updated UNION ALL

SELECT 2 AS ID, 1 AS num, 0.1 AS ret, null UNION ALL

SELECT 3 AS ID, 1 AS num, 0.1 AS ret, null UNION ALL

SELECT 4 AS ID, 1 AS num, 0.1 AS ret, null UNION ALL

SELECT 5 AS ID, 1 AS num, 0.1 AS ret, null

)

SELECT id, last_updated,

(MAX(CASE WHEN id = 1 THEN last_return END) OVER (ORDER BY id) *

EXP(SUM(LN(1 + daily_return)) OVER (ORDER BY id)

) / (1 + daily_return)

) as cumulative_return

FROM daily_return c;