One-Shot Wand is a Equip Spell Card.
Spell Cards are usually activated from the hand on your turn unless their type gives another timing window.
On the current TCG and OCG Forbidden & Limited lists tracked here, One-Shot Wand is Unlimited.
YGOPRODeck lists One-Shot Wand for these formats: Duel Links, Common Charity, TCG, OCG, Master Duel.
A listed print of One-Shot Wand appears in Abyss Rising (ABYR-EN051) at Common rarity.
Among markets shown on this page, the lowest listed snapshot for One-Shot Wand is about $0.09 on Cardmarket (prices change frequently).
