Colloquium: Comparison of astrophysical and terrestrial frequency standards