The Yellow Rocket is a consumable item that can be placed. Once placed, it can then be activated to shoot the rocket into the air where it explodes in a shower of yellow sparks. It is a single use item and can be bought from the Party Girl NPC.
How to get Fireworks, Terraria 1 2, Terraria HERO,