The cost of betting on weather catastrophes