Stop macOS from accessing external drive at night
I believe the best solution would be mounting and unmounting the drive to completely ensure no activity from the OS or any other rogue processes.


There is an already built solution that is paid: 
Following this guide can help with more advanced settings how to unmount and mount the drive.


A free Solution would be combining

Apple Script disk mounting with Time scheduling to execute script