I've seen a lot of texts referring to the coefficients and their sign for determining which way a parabola opens up. But is there more than this kind of "thumb rule" to it?
That is, how was it proven that for those coefficient ranges, the parabola opens up into a certain direction?
If you accept that a parabola only opens in "one direction" (up or down) eventually regardless of whether you move right or left, then all you have to do is plug in $x = 0$ and then consider $x = -N$ and $x = N$ for really large $N$ to see which direction the parabola opens. It should be clear that the sign of $A$ for the equation $y = Ax^2 + Bx + C$ determines this, since $AN^2$ is so much larger than $BN + C$ for large $N$. If you want a more rigorous argument, you can use calculus to show that the parabola is either "concave" (opening down) or "convex" (opening up), using the sign of the second derivative of the equation for the parabola, which for $y = Ax^2 + Bx + C$ is simply $2A$. So the sign of the leading coefficient $A$ determines everything. If positive, the parabola opens up, if negative, the parabola opens down.