What type of word is by?

The Word 'by' is a preposition when followed by a noun or pronoun. Example:

• We drove right by the entrance. We drove right by it.

The Word 'by' is an adverb when not followed by a noun or pronoun. Example:

• We had nothing to do so we just stood by.