No, Goldfish prefer to rest in the dark. So to ensure your Goldfish gets the best rest, turn off your lights.
Should I use Blue Light for Goldfish?
Here is a great article about the effects of colored light on Goldfish.
And the conclusion states;
A Goldfish exhibits the most stable behavior under a white light, because it contains the waves and frequencies of red, orange, blue, indigo, and violet light rays. Therefore, in order to keep one’s fish in the most stable and healthy condition, white light is the best option. Source