Red sand is primarily smelted into quicksilver using standard ore smelting techniques, but it is also used in alchemy as a component of several tinctures, as well as an ingredient in paint. It is also a component of the alloy Metal Blue.
Red sand probably corresponds to the mineral cinnabar, a dark red crystalline substance that is -- in real life, as in ATITD -- the primary ore of mercury.