> What fuel is used to generate the electricity? (Honest question since I have no idea how electricity markets work)

Depends on which system you're talking about. Muni is 100% hydro. BART is more coy but claims their electricity is "greenhouse gas-free" and their diesel (for eBART) is "renewable".