Does archiving work for investment accounts?

No, transactions in investment accounts are not included in the archive process. The reason being that it would not be possible to correctly calculate the cost basis with only a partial investment transaction history.