PERF: perf improvements in DataFrame construction with a non-daily datelike index (GH6479)

closes #6479