"What was the chemical element we placed within a can as youngsters (many years ago), dropped water into, propelling well into the sky".
It was C2H2, prepared by the action of water on calcium carbide. Commonly known as acetylene.