What kind of drill bit can make a hole in a nickel?

Any HSS drill bit will make a hole in a nickel. Be careful how you hold the nickel as the bit will very likely jam into it. I use 'vice-grips' when doing something like that, pliers are not strong enough.