Commercial cooking sprays are made from oil, along with an emulsifier such as soy lecithin, and something such as either a bit of alcohol, silicone, or a propellant agent to help prevent the spray from foaming or clogging the spray nozzle.
Some may have other ingredients as well to help increase their non-stick capabilities.
They are convenient, and generally, cheap, especially as they are regularly on sale and you only use a little at a time. A can has a very long shelf life, usually of several years, and you rarely if ever hear of one going bad.
The most common oil base used these days seems to be canola, though olive oil, etc, is also available.
You can get flavoured sprays, with butter flavour being quite common.
The dominant brand names in North America are Pam, Mazola and Crisco, though supermarket own-brands are quite common and often cheaper.
There are also special low calorie cooking sprays such as Fry Light, which is only 1 calorie per spray, compared with regular sprays such as Pam which is 7 calories per spray. (( “The truth is that there are about 7 calories per each 1 second spray…I estimate that the typical spray-time required to thoroughly lightly coat a pan is around 2 seconds. That still adds up to less than 15 calories (much, much less than what you’d be taking in if you used regular cooking oil”. Hungry Girl. 1 June 2005. https://www.hungry-girl.com/newsletters/raw/293-the-truth-about-no-calorie-cooking-spray-and-more ))
Beware cooking spray labels giving calories per 1/4 second spray. What the heck kind of human being can effect a 1/4 second spray? That kind of nonsense should be banned on nutrition labels.
See also: Oil Spray Bottles