VOOZH about

URL: https://apify.com/parseforge/dat-freight-rates-scraper

โ‡ฑ DAT Freight Rates Scraper - Spot & Contract Rate Data ยท Apify


Pricing

from $18.75 / 1,000 result items

Go to Apify Store

DAT Freight Rates Scraper

Scrape DAT Trendlines freight data: national spot and contract rates, state load-to-truck ratios, week/month/year-over-year trends, and fuel prices. Built for freight brokers and dispatchers.

Pricing

from $18.75 / 1,000 result items

Rating

0.0

(0)

Developer

๐Ÿ‘ ParseForge

ParseForge

Maintained by Community

Actor stats

0

Bookmarked

7

Total users

3

Monthly active users

22 days ago

Last modified

Share

๐Ÿ‘ ParseForge Banner

๐Ÿšš DAT Freight Rates Scraper

๐Ÿš€ Pull live US and Canadian freight market rates in seconds. Filter by equipment, rate type, country, and time bucket. No API key, no registration, no manual CSV wrangling.

๐Ÿ•’ Last updated: 2026-05-16 ยท ๐Ÿ“Š 24 fields per record ยท 4 datasets in one feed ยท 183 state-level supply/demand rows ยท 3 years of monthly rate history

Pull structured records from DAT Freight Rates โ€” clean fields ready as CSV, JSON, JSONL, Excel, or XML for downstream pipelines.

Copy to your AI assistant

Copy this block into ChatGPT, Claude, Cursor, or any LLM to start using this actor.

parseforge/dat-freight-rates-scraper on Apify. Call:ApifyClient("TOKEN").actor("parseforge/dat-freight-rates-scraper").call(run_input={...}), then client.dataset(run["defaultDatasetId"]).list_items().items for results. Key inputs:maxItems(integer,default10),datasets(array,default["national_history","load_truck_ratio","national_trends",),equipments(array,default["VAN","FLATBED","REEFER"]),rateTypes(array,default["SHIPPER_TO_BROKER_SPOT","BROKER_TO_CARRIER_SPOT","CONTRA), countries (array, default ["US", "CA"]), periodTypes (array, default ["Month", "Week"]). Full actor spec: fetch build via GEThttps://api.apify.com/v2/acts/parseforge~dat-freight-rates-scraper(Bearer TOKEN). Get token: https://console.apify.com/account/integrations

DAT Freight & Analytics runs the largest load board in North America, and the Trendlines pages it publishes are the closest thing the trucking industry has to a public price index. This scraper turns those pages into a flat Apify dataset. Every run captures the national rate history (spot and contract, weekly and monthly, going back roughly three years), the load-to-truck ratio for every US state and Canadian province, the week, month, and year-over-year percentage moves, and the current national diesel reference price. The output is one row per data point, which is the shape spreadsheets, Postgres, and pandas already speak.

Freight brokers, dispatchers, and 3PL pricing teams check DAT daily to figure out what a lane should pay. When the dashboard hangs or the iQ subscription is between renewals, the only fallback is calling carriers one by one. This actor gives you a programmatic version of the public Trendlines view, so quotes go out backed by current numbers and contract negotiations cite the same baseline both sides reference. Pair it with a scheduled Apify run and you have a daily rate sheet feeding your CRM, BI tool, or rate sheet, with zero scraping plumbing to maintain.

๐ŸŽฏ Target audience๐Ÿ’ก Primary use cases
Freight brokers and dispatcher teamsDaily lane-context rate checks for shipper quotes
Owner-operator carriersVerify carrier pay against published spot rates
3PL pricing and procurement teamsBuild a market-truth baseline for RFP responses
Logistics software vendorsPower rate widgets without paying a market data subscription
Supply chain analysts and researchersTrack freight cycle indicators alongside fuel and demand
Shippers verifying invoicesSpot underbid lanes and overcharged contracts

๐Ÿ“‹ What the DAT Freight Rates Scraper does

  • ๐Ÿ“ก National rate history. Monthly buckets back ~3 years and weekly buckets back ~1 year, with the average rate per mile in USD plus the average fuel surcharge per trip.
  • ๐Ÿšš Load-to-truck ratio per state. One row per US state and Canadian province for van, flatbed, and reefer, with the load count, truck count, and computed ratio.
  • ๐Ÿ“ˆ Trend percentages. Week, month, and year-over-year change for spot rate, load-to-truck ratio, load postings, truck postings, and fuel.
  • โ›ฝ National diesel price. The reference price per gallon DAT publishes alongside the rates.
  • ๐ŸŽ›๏ธ Smart filters. Restrict by equipment (van, flatbed, reefer, intermodal), rate type (spot shipper-to-broker, spot broker-to-carrier, contract), country (US, CA), period type (month, week), or state code.
  • ๐Ÿงพ One flat row per data point. Every dataset writes to the same shape, so SQL joins and pandas pivots are trivial.

Every record carries its source URL on dat.com, the dataset tag, every relevant filter (equipment, rate type, country, state, period), the numeric values, and a precise scrape timestamp. The schema is stable, so daily appends stitch into a clean longitudinal store.

๐Ÿ’ก Why it matters: A broker who avoids one underquoted load per week saves hundreds of dollars in margin. Owning a current rate feed instead of refreshing a vendor dashboard ten times an hour pays for itself within the first month.


๐ŸŽฌ Full Demo

๐Ÿšง Coming soon: a 3-minute walkthrough of the input form, a sample run, and a Google Sheets dashboard that consumes the dataset.


โš™๏ธ Input

FieldTypeDescriptionDefault
maxItemsintegerCap on the number of records returned. Free users are limited to 10.10
datasetsarray of enumWhich Trendlines datasets to scrape: national_history, load_truck_ratio, national_trends, fuel_price.All four
equipmentsarray of enumEquipment categories to include: VAN, FLATBED, REEFER, INTERMODAL.["VAN", "FLATBED", "REEFER"]
rateTypesarray of enumRate types for national_history: SHIPPER_TO_BROKER_SPOT, BROKER_TO_CARRIER_SPOT, CONTRACT.All three
countriesarray of enumCountries for national_history: US, CA.["US", "CA"]
periodTypesarray of enumTime bucket granularity for national_history: Month (~36 buckets) or Week (~52 buckets).["Month", "Week"]
statesarray of enumOptional list of state or province ISO codes to filter the load_truck_ratio dataset.All states

Example: van and reefer monthly US spot rates plus load-to-truck for Texas and California.

{
"datasets":["national_history","load_truck_ratio"],
"equipments":["VAN","REEFER"],
"rateTypes":["SHIPPER_TO_BROKER_SPOT"],
"countries":["US"],
"periodTypes":["Month"],
"states":["TX","CA"]
}

Example: full national snapshot for a daily warehousing job.

{
"datasets":["national_history","load_truck_ratio","national_trends","fuel_price"],
"equipments":["VAN","FLATBED","REEFER"],
"rateTypes":["SHIPPER_TO_BROKER_SPOT","BROKER_TO_CARRIER_SPOT","CONTRACT"],
"countries":["US","CA"],
"periodTypes":["Month","Week"]
}

โš ๏ธ Good to Know: This actor pulls from the public Trendlines API that powers dat.com/trendlines. The numbers are the same ones DAT publishes to the general public. Lane-level rates (specific origin-destination city pairs) are gated behind DAT's paid iQ subscription and are not part of this scraper's scope.


๐Ÿ“Š Output

Every record is one flat object representing a single data point from one of the four datasets.

๐Ÿงพ Schema

FieldTypeExample
๐Ÿ†” recordIdstringnational_history|VAN|SHIPPER_TO_BROKER_SPOT|US|Month|2026-04-01
๐Ÿท๏ธ datasetstringnational_history
๐Ÿš› equipmentstringVAN
๐Ÿ’ธ rateTypestringSHIPPER_TO_BROKER_SPOT
๐ŸŒŽ countrystringUS
๐Ÿ“ stateCodestringTX
โฒ๏ธ periodTypestringMonth
๐Ÿ“… periodStartstring2026-04-01
๐Ÿ—“๏ธ yearinteger2026
๐Ÿ”ข monthinteger4
๐Ÿ’ฐ rateUsdnumber2.24
โ›ฝ fuelSurchargePerTripUsdnumber0.71
๐Ÿ“ฆ loadCountnumber11842.5
๐Ÿšš truckCountnumber743.1
โš–๏ธ loadToTruckRationumber9.915
๐Ÿ›ข๏ธ fuelPricePerGallonUsdnumber5.64
๐Ÿ“Š metricstringspot_rate
๐Ÿ“ˆ weekOverWeekPctnumber1.322
๐Ÿ“‰ monthOverMonthPctnumber0
๐Ÿ—“๏ธ yearOverYearPctnumber4.455
๐Ÿ•’ asOfDatestring2026-05-11
๐Ÿ”— sourceUrlstringhttps://www.dat.com/trendlines/van/national-rates
โฐ scrapedAtstring2026-05-16T04:56:50.643Z
โ— errorstring(populated only on failure)

๐Ÿ“ฆ Sample records


โœจ Why choose this Actor

CapabilityWhat you get
๐ŸงพFour datasets in one feed. National rate history, state-level supply/demand, trend percentages, and fuel price land in the same dataset.
๐Ÿš›Every equipment category that matters. Van, flatbed, reefer, and intermodal in one input, no separate runs per truck type.
โณThree years of rate history. Monthly buckets back ~36 periods and weekly buckets back ~52, ready for time-series modelling.
๐ŸŒŽUS and Canadian coverage. State and provincial rows on the same schema, so cross-border lanes share a baseline.
๐ŸŽ›๏ธFilters at every axis. Restrict equipment, rate type, country, period, state, or dataset without writing code.
๐ŸšฆBuilt-in retries. Handles 429 and 503 from the upstream gracefully so scheduled jobs survive load spikes.
๐Ÿš€No API key. Public DAT Trendlines endpoints only, so you ship a market data feed without keys or contracts.

๐Ÿ“Š A full run with default filters produces roughly 1,800 records covering three years of national rate history, current state-level supply/demand for three equipment categories, every published trend percentage, and the latest diesel reference price.


๐Ÿ“ˆ How it compares to alternatives

ApproachCostCoverageRefreshFiltersSetup
โญ DAT Freight Rates Scraper (this Actor)Pay-per-run4 datasets, US and CAOn demand or scheduledEquipment, rate type, country, period, stateClick run
Paid live freight market APIsHigh monthly subscriptionMulti-sourceStreamingLimitedAPI key, contract
Official trade publicationsFreeHeadlines and weekly summariesWeeklyNoneRead and copy
Legacy community spreadsheetsFreeStale or partialQuarterly at bestNoneManual joins
Build your own scraperEngineering hoursWhatever you buildWhatever you buildWhatever you buildSignificant engineering

If you want a turnkey freight market data feed without paying a paid index subscription or maintaining your own crawler, this actor is the shortest path.


๐Ÿš€ How to use

  1. ๐Ÿ“ Sign up for Apify. Create a free account at console.apify.com/sign-up?fpr=vmoqkp.
  2. ๐ŸŽ›๏ธ Pick your datasets. Leave the defaults to grab everything, or narrow to just national_history for a pure time-series pull.
  3. ๐Ÿ” Set your filters. Choose equipment, rate type, country, period granularity, and optional state codes.
  4. โ–ถ๏ธ Run. Click Start and watch the dataset fill.
  5. ๐Ÿ“ค Export. Pull JSON, CSV, or XLSX, or wire the dataset into Make, Zapier, BigQuery, Postgres, or your own webhook.

โฑ๏ธ Total time: Under two minutes from sign-up to first dataset row.


๐Ÿ’ผ Business use cases

๐Ÿšš Freight brokers

  • Quote shippers with current spot rate context
  • Avoid underquoting on van, flatbed, and reefer lanes
  • Audit invoices against published contract rates
  • Spot supply-tight states to repost loads at higher pay

๐Ÿ›ป Owner-operators and small carriers

  • Negotiate truck rate floors with confidence
  • Reposition empty trucks toward high load-to-truck states
  • Track fuel surcharge baselines for billing
  • Validate broker-quoted pay against the published spot

๐Ÿ“Š 3PL pricing and procurement teams

  • Build RFP responses on a documented market baseline
  • Compare carrier bids against contract reference rates
  • Forecast budget impact when fuel surcharges shift
  • Track year-over-year freight inflation by equipment

๐Ÿง‘โ€๐Ÿ’ป Logistics software vendors

  • Power a rate sheet feature without buying a paid feed
  • Embed market indicators inside TMS and ERP dashboards
  • Trigger pricing alerts on threshold breaches
  • Differentiate analytics products with built-in baselines

๐ŸŒŸ Beyond business use cases

Data like this powers more than commercial workflows. The same structured records support research, education, civic projects, and personal initiatives.

๐ŸŽ“ Research and academia

  • Empirical datasets for papers, thesis work, and coursework
  • Longitudinal studies tracking changes across snapshots
  • Reproducible research with cited, versioned data pulls
  • Classroom exercises on data analysis and ethical scraping

๐ŸŽจ Personal and creative

  • Side projects, portfolio demos, and indie app launches
  • Data visualizations, dashboards, and infographics
  • Content research for bloggers, YouTubers, and podcasters
  • Hobbyist collections and personal trackers

๐Ÿค Non-profit and civic

  • Transparency reporting and accountability projects
  • Advocacy campaigns backed by public-interest data
  • Community-run databases for local issues
  • Investigative journalism on public records

๐Ÿงช Experimentation

  • Prototype AI and machine-learning pipelines with real data
  • Validate product-market hypotheses before engineering spend
  • Train small domain-specific models on niche corpora
  • Test dashboard concepts with live input

๐Ÿ”Œ Automating DAT Freight Rates Scraper

Wire this actor into the rest of your stack with a few lines of code or a saved schedule.

  • ๐ŸŸข Node.js client for calling the actor from JavaScript or TypeScript projects.
  • ๐Ÿ Python client for notebooks, FastAPI endpoints, or Airflow DAGs.
  • ๐Ÿ“š Apify API reference for raw REST integration in any language.

Schedules turn this actor into a low-cost market data subscription. Run it daily for an always-fresh rate sheet feeding your CRM, hourly during contract season for rapid bid reactions, or weekly for a longitudinal warehouse you can backfill into BigQuery or Postgres. The dataset chains naturally with downstream actors and webhooks, so you can branch on a load-to-truck ratio threshold or post a Slack alert when the national diesel price moves more than a configured percentage.


โ“ Frequently Asked Questions


๐Ÿ”Œ Integrate with any app

  • Zapier - route every new dataset row to spreadsheets, Slack, or your CRM.
  • Make - chain Apify runs into visual automations with conditional logic.
  • n8n - self-hosted workflows for full data ownership.
  • Google Sheets - drop CSV exports into shared sheets for rate-desk review.
  • Airtable - structured base for cross-equipment rate trackers.
  • Slack - push spread alerts and tight-supply notifications straight into channels.

๐Ÿ”— Recommended Actors

๐Ÿ’ก Pro Tip: browse the complete ParseForge collection for more logistics, freight, and market-data actors.


๐Ÿ†˜ Need Help? Open our contact form and we will respond within one business day.


โš ๏ธ Disclaimer: This actor extracts publicly available freight market data from the DAT Trendlines pages for informational purposes only. None of the data returned constitutes pricing or financial advice. You are responsible for ensuring your use complies with DAT's terms of service and any obligations that apply in your jurisdiction, especially when redistributing data.

You might also like

ImportYeti Scraper - Bills of Lading & US Import Records

jungle_synthesizer/importyeti-bill-of-lading-scraper

Extract US bill-of-lading records from ImportYeti. Pull shipment date, BOL numbers, supplier/customer names, countries, weight, container counts, product descriptions, and HS-code rollups for any US importer or foreign supplier.

๐Ÿ‘ User avatar

BowTiedRaccoon

68

Import Export Leads Finder

akash9078/import-export-leads-finder

Discover high-quality import-export leads for your international business expansion. Filter global B2B companies by country to target the right markets.

๐Ÿ‘ User avatar

Akash Kumar Naik

44

ImportYeti Scraper โ€” US Customs Importer & Supplier Data

khadinakbar/importyeti-scraper

Scrape US import/export trade data from ImportYeti โ€” bills of lading, importer & supplier profiles, HS codes, top trading partners, shipment history. CRM-ready JSON for B2B lead-gen, Amazon supplier discovery, and supply-chain intel. MCP-ready for AI agents.

43

ImportYeti Scraper

parseforge/importyeti-scraper

Supercharge your import/export research with our comprehensive ImportYeti scraper! Automate collection of supplier and company data including shipment history, locations, and trading partners. Perfect for importers, exporters, and researchers who need accurate, up-to-date trade data.

ImportYeti Scraper - US Import Records & Supplier Data

zen-studio/importyeti-scraper

Extract supplier profiles, shipment records, and trade data from ImportYeti. Search by company, product, or address. 60+ fields per result: HS codes, shipping lanes, carriers, bills of lading, trading partners, and contact info. No login required.

261

5.0

LeadMagnet

zakbuildsai/LeadMagnet

Open-source Google Maps business lead scraper powered by Playwright. Extract names, emails, phone numbers, websites, ratings, reviews, addresses, and hours at scale. Perfect for CRM enrichment, sales prospecting, market research, and lead generation. No API keys needed. Run on Apify or self-host.

๐Ÿ’Ž Linkedin Phone Scraper | $2/1K | Instant Phones (No Cookies)

x_guru/linkedin-phone-Scraper-no-cookies

Find phones by LinkedIn URLs instantly! Search 300M+ database for work & personal phones. No cookies | ๐Ÿš€ Powered by Dievio.com

๐Ÿ‘ User avatar

Hundevmode Labs

607

Mass Linkedin Phone Number Scraper

scraper-mind/linkedin-phone-number-scraper

[๐—–๐—ต๐—ฒ๐—ฎ๐—ฝ๐—ฒ๐˜€๐˜ ๐—ฃ๐—ฟ๐—ถ๐—ฐ๐—ฒ] Mass/Bulk LinkedIn Phone Number Scraper extracts publicly available phone numbers from LinkedIn profiles for research & outreach. Fast, accurate, and easy to use. Ideal for marketers & businesses. Get verified contact details effortlessly.

1.8K

4.6

Linkedin Phone Number Scraper

contacts-api/linkedin-phone-number-scraper

Find business contact numbers efficiently with our LinkedIn Phone Number Scraper. Extract publicly available phone numbers from LinkedIn profiles for B2B outreach and sales.

Linkedin Phone Number Scraper

scraper-engine/linkedin-phone-number-scraper

LinkedIn Phone Number Scraper extracts publicly listed phone numbers from LinkedIn profiles and linked pages. Build targeted contact lists by role, industry, or company. Ideal for sales teams running outbound campaigns.

๐Ÿ‘ User avatar

Scraper Engine

44