Red! I've never seen it, either. I'm also used to cooking oil that is yellow. Or green, which is the color I associate with olive oil. I can remember when using olive oil to cook seemed unusual and fancy.

I love many foods made from tamarind, especially tamarindo, which is a sweetened drink available in Mexican restaurants and stores here.