Data Share Usage Example Q1: Latest Weekly LT Ratio The most recently posted Load-to-Truck ratio posted by DAT SELECT * FROM .DAT.”user_view” WHERE CALC_DATE >= DATEADD(‘DAY’,-6,CURRENT_DATE) AND EQUIP_TYPE = ‘V’
DAT’s National Load-to-Truck Ratio data is a dataset built from the hundreds of millions of annual freight-matching transactions taking place in the DATOne ecosystem. Load and Truck posts are aggregated weekly at the national level to provide the high-level snapshot of spot market capacity demands in the continental United States and Canada. Features of this dataset: – National posted load and truck volumes calculated as a ratio – Three trailer type categories (Dry Van, Refrigerated, and Flatbed) – Weekly aggregations reported – Three rolling years of history – Data updated each Monday More info available at dat.com/trendlines Fields Include: – Reference Date – Type of Trailer – Load-to-Truck Ratio