Firebird 4.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table tbtrades(id_trade integer, ENTRY_DATE date, EXIT_DATE date, Ergebnis NUMERIC(9,2), zuKonto VARCHAR(3))
EXECUTE BLOCK AS BEGIN
insert into tbtrades values(1, CURRENT_DATE-50, CURRENT_DATE-50, 10, '3');
insert into tbtrades values(2, CURRENT_DATE-50, CURRENT_DATE-40, 20, '4');
insert into tbtrades values(3, CURRENT_DATE-50, CURRENT_DATE-30, 30, '3');
insert into tbtrades values(4, CURRENT_DATE-50, CURRENT_DATE-20, 40, '4');
insert into tbtrades values(5, CURRENT_DATE-50, CURRENT_DATE-10, 50, '3');
END
5 rows affected

WITH CTE AS 
  (SELECT zuKonto, MIN(Entry_Date) AS MinEntry, MAX(Exit_Date) AS MaxExit 
  FROM tbtrades GROUP BY zuKonto)

SELECT x.zuKonto, x.id_trade, x.EXIT_DATE, x.Ergebnis, SUM(x.Ergebnis) OVER(PARTITION BY x.zuKonto ORDER BY x.EXIT_DATE, x.id_trade) AS SumTotal
FROM tbtrades x 
LEFT JOIN CTE c 
ON x.zuKonto=c.zuKonto AND x.Entry_Date>=c.MinEntry AND x.Exit_date<=c.MaxExit
WHERE x.zuKonto = '3' AND (x.Entry_Date >='2022-12-20' AND x.Exit_Date <= '2023-03-15')
ORDER BY x.zuKonto, x.EXIT_DATE, x.id_trade


ZUKONTO
ID_TRADE
EXIT_DATE
ERGEBNIS
SUMTOTAL


3
1
2023-02-06
10.00
10.00

3
3
2023-02-26
30.00
40.00