Astrophysical neutrinos at the low and high energy frontiers