Piccolo trumpet is a super fun instrument to play.
Invented in the 20th century, the modern piccolo trumpet is pitched in Bb (or A), one octave higher than a standard Bb trumpet. Many contemporary pieces are written for the instrument, but is often used to play baroque music which tends to be in the higher register.
Baroque music composers, however, had a very different instrument in mind. You can read about baroque trumpets here, but for now, listen to the difference between 2 baroque trumpets and 2 piccolo trumpets playing this excerpt from Johann Sebastian Bach’s Easter Oratorio: