DAT Trendlines+ 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 Trendlines+ Rate Data

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

Data Share Overview:

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

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!

presentation/data share body form