Yet another vote for Nico's @ Pier 38. IIRC, they buy early in the morning at the fish auction next door, use it the same day, close after lunch.

Also another vote for Romy's. While I love the shrimp at Giovanni's original site, Romy's farms their own. Romy's also has a larger size shrimp than Giovanni's.