DAT RateView Linehaul Rate Data

Snowflake Cost Saving

We Automate SnowflakeDB Data Cloud Cost Saving. Sign Our Free 7 Days No Risk Trail Now

Data Share Description:

DAT RateView Linehaul Rate Data

Data Share Frequency: Daily
Data Share Category: Transportation
Data Share Type: Personalized
Data Share Date Added: February 1, 2021
Data Share Status: ACTIVE
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
Data Share Usage Example SQL1 Last Tested: January 1, 1970

Data Share Overview:

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

Join The Club

Every week, we'll be sending you curated materials handpicked by professionals. Plus, you'll be the first to know about our latest data!