Is it normal for a clear liquid to leak from your breasts when you're pregnant and why does it happen only at night or early in the morning?

It's probably colostrum, or "pre-milk." It's not just common; it's normal. Not sure why you notice it at night, though. It could be your sleeping position.