Rocket-like projectile rotation

I want to make my projectile rotate depending on where it is going like a rocket. If it is going up, its face will be rotated towards air and it will rotate towards ground when it starts to fall down. Like this:

How can I achieve that? I am using fastcast module.

You could make a script that takes the velocity of the rocket and then orient it after doing some calculations. Because having a positive Y value means it points more up, having a negative Y value means it points more down. Same with the other X and Z values but rotated differently for them.