TST: add a test with freq=1MS to increase coverage of shift
xref #52064

Added a test with `freq=1MS` to increase coverage of `shift`. The reason: existing tests don't cover a case if the index of a DataFrame is a `DatetimeIndex`.
@MarcoGorelli, , could you please take a look at this pr?