The bulbs that come with the standard Lithonia, LOM, etc fixtures are 4K or 3K bulbs, which are pretty much useless.
The 70w fixtures are the ones most commonly found in the ceiling or "wall pack" style fixtures that are sold there.
However, there is no aquarium bulb made that is a drop in replacement, as 70W aquarium bulbs are only made in Double Ended. You'd have to rig up a socket. Even then, the fixtures are probe start, and DE bulbs are pulse start. A probe start bulb has an internal ignitor, but the 70W bulb in the Depot fixtures lack them, so it's possible that the ballast is capable of firing a DE bulb.
You are going to be far better off, and cheaper, to buy a loose ballast from an electrical supply house and a mogul socket and build your own fixture, unless the halide fixtures at Lowes or the Depot are on some wild clearance or something. I picked up two once for $6 each, but I haven't bothered to do anything with them yet.