Data Share Usage Example Q1: Latest Weekly Market Conditions Index The most recently posted Market Conditions Index posted by DAT SELECT * FROM .DAT.”user_view” WHERE CALC_DATE >= DATEADD(‘DAY’,-6,CURRENT_DATE) AND EQUIP_TYPE = ‘V’
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) calculation at the national level – Three trailer type categories (Dry Van, Refrigerated, and Flatbed) – Weekly MCI calculations – Three rolling years of history* – Data updated each Monday *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: – Reference Date – Type of Trailer – Outbound MCI – Inbound MCI
