You can find these in Ceiling Lights. These are loft versions of my edited Vaulted Chandelier light.
Large Vaulted Chandelier – Loft Medium height
Large Vaulted Chandelier – Loft Short height
Large Vaulted Chandelier – Loft Tall height
I used my edited version because the original was a bit too saggy for me lol. You’ll need to place these using the moveobjects cheat on the second floor, then you can remove the floor underneath so they can be seen from the floor below. I’ve also made it so this will light up the area between floors as well.