The best time to fish are when there are fish in front of you...... seriously. Different locations vary as to the best time/condition. In general, for the RI area for this time of year: Under the cover of darkness, with a southwest wind and with bait in the water. If you have those conditions and you are in a fishy spot you will catch fish. I once asked a person from RI know to fish eels on how to fish a certain spot. Due to scheduling conflicts I ended up there on the opposite tide/conditions and slammed them, so you never know. Now that person was either giving me the skinny on that spot or trying to keep me clear of the area
...........What I'm trying to say here is the very best info you will gain on a spot is what you learn yourself.