DAT Market Conditions Index Data

Snowflake Cost Saving

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

Data Share Description:

DAT Market Conditions Index 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: Los Angeles Market Daily MCI Calculation – Rolling 13 Months Calculated MCI values for the past 13 months (Note: Actual field and view names may vary from those displayed below.) SELECT * FROM .DAT.”user_view” WHERE CAL_DATE >= DATEADD(‘month’,-13,CUR
Data Share Usage Example SQL1 Last Tested: January 1, 1970

Data Share Overview:

DAT’s Market Conditions Index (MCI) is a dataset built from the hundreds of millions of annual freight-matching post and search transactions taking place in the DAT One ecosystem. The calculation constitutes a powerful index for managing daily and weekly capacity strategies. Features of this dataset: – Outbound (explicit origin) and Inbound (explicit destination) calculations down to the DAT Key Market Area level – Three trailer type categories (Dry Van, Refrigerated, and Flatbed) – Daily MCI calculations at all levels – Daily history back to 2013* – A variety of historical granularities (e.g. prior 7 days) – 8-day forecast available *Note: Product launched in June 2020. MCI calculations prior to this date are what would have been calculated had the product existed at that time. Fields Include: – Type of Trailer – Origin Geography Code – Outbound MCI – Inbound MCI – Load-to-Truck Ratio – Equipment Posts – Load Posts – Equipment Searches – Load Searches

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