A Holographic study of high-density matter and astrophysical applications