The aerosol stuff they use is 100% pure silicone oil. The spray stuff from Canadian Tire usually has petroleum distillates or something that will chew up rubber (I'm talking about the 3-in-1 silicone lubricant or anything else like that, yes it may be silicone oil but there is other crap in it as well).
The one they use in the Redwolf video I believe to be the TM branded silicone spray but there are other airsoft manufacturers that also make silicone spray.
that you want. NOT THIS STUFF
The "water looking stuff" is 100% pure silicone oil. Likely RC Shock oil (it's 100% pure silicone oil if you're wondering).