The move marks the end of an era as Moody's was the last major agency to maintain a triple-A rating for US sovereign debt.