A Tale of Two Cities: Pessimism and Opportunism in Offline Dynamic Pricing