Oracle 11g Release 2

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

create table tbl(dt, to_cur, from_cur, rate) as (
    select date '2020-01-01', 'CASHCAD', 'CASHUSD', .771 from dual union all
    select date '2020-01-02', 'CASHCAD', 'CASHUSD', .772 from dual union all
    select date '2020-01-03', 'CASHCAD', 'CASHUSD', .773 from dual union all
    select date '2020-01-04', 'CASHCAD', 'CASHUSD', .773 from dual union all
    select date '2020-01-05', 'CASHCAD', 'CASHUSD', .773 from dual union all
    select date '2020-01-06', 'CASHCAD', 'CASHUSD', .774 from dual union all
    select date '2020-01-07', 'CASHCAD', 'CASHUSD', .775 from dual union all
    select date '2020-01-08', 'CASHCAD', 'CASHUSD', .776 from dual union all
    select date '2020-01-09', 'CASHCAD', 'CASHUSD', .777 from dual union all
    select date '2020-01-10', 'CASHCAD', 'CASHUSD', .772 from dual union all
    select date '2020-01-11', 'CASHCAD', 'CASHUSD', .772 from dual union all
    select date '2020-01-12', 'CASHCAD', 'CASHUSD', .772 from dual union all
    select date '2020-01-13', 'CASHCAD', 'CASHUSD', .770 from dual union all
    select date '2020-01-14', 'CASHCAD', 'CASHUSD', .764 from dual union all
    select date '2020-01-15', 'CASHCAD', 'CASHUSD', .768 from dual )

15 rows affected

TO_CUR	FROM_CUR	DT_FROM	DT_TO	RATE	CNT
CASHCAD	CASHUSD	01-JAN-20	01-JAN-20	.771	1
CASHCAD	CASHUSD	02-JAN-20	02-JAN-20	.772	1
CASHCAD	CASHUSD	03-JAN-20	05-JAN-20	.773	3
CASHCAD	CASHUSD	06-JAN-20	06-JAN-20	.774	1
CASHCAD	CASHUSD	07-JAN-20	07-JAN-20	.775	1
CASHCAD	CASHUSD	08-JAN-20	08-JAN-20	.776	1
CASHCAD	CASHUSD	09-JAN-20	09-JAN-20	.777	1
CASHCAD	CASHUSD	10-JAN-20	12-JAN-20	.772	3
CASHCAD	CASHUSD	13-JAN-20	13-JAN-20	.77	1
CASHCAD	CASHUSD	14-JAN-20	14-JAN-20	.764	1
CASHCAD	CASHUSD	15-JAN-20	15-JAN-20	.768	1