If you live near or in Rhode Island, then there are many aquariums you may go to several locations which can be found on the map below.
If you are looking for an aquarium close to southern Rhode Island, I recomend Mystic Aquarium. Pricing and hours can be found here.