It is located in Dubai Mall. It opens at 10 am and tickets starts from 70 AED per person. Tickets can be bought from there and you can choose from the usual tours to diving. You can see the aquarium for free from the mall, the diference is walking through the tunnel, which is great.