SQL Server 2019

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

create table t(ret decimal(10,5), nav decimal(10,5), inserted_date date);
insert into t values(0,100,'2022-01-10')
insert into t values(0.016,101.6,'2022-01-11')
insert into t values(-0.0015,101.4476,'2022-01-12')
insert into t values(0.0103,102.49251028,'2022-01-13')
insert into t values(0.0003,102.523258033084,'2022-01-14')
insert into t values(0.0009,102.615528965314,'2022-01-15')
insert into t values(0,102.615528965314,'2022-01-16')
insert into t values(0,102.615528965314,'2022-01-17')
insert into t values(0.097,112.569235274949,'2022-01-18')
insert into t values(-0.0166,110.700585969385,'2022-01-19')
insert into t values(-0.0023,110.445974621655,'2022-01-20')
insert into t values(-0.0026,110.158815087639,'2022-01-21')
insert into t values(-0.0282,107.052336502168,'2022-01-22')
insert into t values(0,107.052336502168,'2022-01-23')
insert into t values(0,107.052336502168,'2022-01-24')
insert into t values(-0.0456,102.170749957669,'2022-01-25')
insert into t values(0.0132,103.51940385711,'2022-01-26')
insert into t values(0,103.51940385711,'2022-01-27')
insert into t values(-0.0102,102.463505937768,'2022-01-28')
insert into t values(0.0075,103.231982232301,'2022-01-29')
insert into t values(0,103.231982232301,'2022-01-30')
insert into t values(0,103.231982232301,'2022-01-31')
insert into t values(0.0173,105.01789552492,'2022-02-1')
insert into t values(0.0036,105.395959948809,'2022-02-2')
insert into t values(0.0118,106.639632276205,'2022-02-3')
insert into t values(-0.0071,105.882490887044,'2022-02-4')

26 rows affected

return	nav	inserted_date
0.00000	100.0000000000	2022-01-10
0.01600	101.6000000000	2022-01-11
-0.00150	101.4476000000	2022-01-12
0.01030	102.4925102800	2022-01-13
0.00030	102.5232577530	2022-01-14
0.00090	102.6155309340	2022-01-15
0.00000	102.6155300000	2022-01-16
0.00000	102.6155300000	2022-01-17
0.09700	112.5692364100	2022-01-18
-0.01660	110.7005906160	2022-01-19
-0.00230	110.4459786430	2022-01-20
-0.00260	110.1588104780	2022-01-21
-0.02820	107.0523412760	2022-01-22
0.00000	107.0523400000	2022-01-23
0.00000	107.0523400000	2022-01-24
-0.04560	102.1707532960	2022-01-25
0.01320	103.5194039000	2022-01-26
0.00000	103.5194000000	2022-01-27
-0.01020	102.4635021200	2022-01-28
0.00750	103.2319863250	2022-01-29
0.00000	103.2319800000	2022-01-30
0.00000	103.2319800000	2022-01-31
0.01730	105.0178932540	2022-02-01
0.00360	105.3959644400	2022-02-02
0.01180	106.6396323280	2022-02-03
-0.00710	105.8824886270	2022-02-04