Spindle/Bearing Lube

I have a Nottingham table and the bottle of oil that came with my table is about empty. What does anybody use for oil? I see people on AA saying to use motor oil and synthetic stuff but the oil that came with my table is thicker than motor oil and it is red and smells like standing right beside a refinery. Do different tables take different oil? What oil would people suggest and where do you get it? Thank you.