Data Share Usage Example Q1: Current National Van Spot Rates The average spot price to move dry-van freight for the prior week (Monday through Sunday) SELECT * FROM .DAT.”user_view” WHERE RATE_DATE >= DATEADD(‘DAY’,-6,CURRENT_DATE) AND RATE_TYPE = ‘Spot’ AND EQUIPMENT_CATEGOR
This dataset is built from DAT’s over 950 industry contributors across the freight industry. This distilled view provides weekly National snapshot of the current price to move freight over-the-road in the continental United States and Canada as well as 3 rolling years of history. Features of this dataset: – Three trailer type categories (Dry Van, Refrigerated, and Flatbed) – Two rate types (Broker-to-Carrier Spot and Shipper-to-Carrier Contract) – Three rolling years of history – Full truckload – Single-stop – Linehaul Rates (explicitly excluding fuel and accessorial charges) – Data updated each Monday More info available at dat.com/trendlines Fields Include: – Reference Date – Type of Trailer – Rate Type – Cost per Mile