Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

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

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management