The transfer address will only contain one row for each transfer event, unlike credit debit, which has one row for credit and another for debit.
In the credit debit table, you can find the net inflow of an asset simply by summing the amount of USDC to find the change daily and make a cumulative sum.
In transfers, you will need to represent the inflows and outflows in two separate common expression tables (CTEs) and join them together.