Data Share Usage Example Q1: Weekly Spot Van Rate Trend LA to Chicago Published Rate for the past fifty two weeks (Note: Actual field and view names may vary from those displayed below) SELECT * FROM .DAT.”user_view” WHERE DATE_PART(‘weekday’,RATE_DATE) = 0 AND RATE_DATE >= DAT
RateView rate data is a dataset built from over 950 industry contributors across the freight industry. Brokers, shippers, and carriers provide real moved-freight transactions detailing actual costs associated with moving truckload freight across the continental United States and Canada. Features of this dataset: – Over 65,000 market-to-market lane pairs to select – Three trailer type categories (Dry Van, Refrigerated, and Flatbed) – Two rate types (Broker-to-Carrier Spot and Shipper-to-Carrier Contract) – Temporal and geographic flexibility – Daily rate calculations – Full truckload freight – Single-stop – Linehaul rates (explicitly excluding fuel and accessorial charges) – Daily rate index history back to 2014 Fields Include: – Type of Trailer – Rate Type – Days Averaged – Lane Origin – Lane Destination – Cost per mile – 25th Percentile – 75th Percentile – Shipments Used – Count of Contributors – Length of Haul