Transformers and Their Roles as Time Series Foundation Models