1. Fetching Shipping Point Reports (Last 10 days)...
✅ Success! Found 20 shipping point reports
Sample Reports by State:
- [FR] Fresno Shipping Point Vegetables Prices (FR_FV120)
Type: vegetable | Date: 2026-09-10
- [YA] YAKIMA Shipping Point Fruit Prices (YA_FV110)
Type: fruit | Date: 2026-09-10
- [IX] Phoenix Shipping Point Vegetables Prices (IX_FV120)
Type: vegetable | Date: 2026-09-10
- [MB] Inwood Shipping Point Fruit Prices (MB_FV110)
Type: fruit | Date: 2026-09-10
- [IF] Idaho Falls Shipping Point Onions and Potatoes Prices (IF_FV130)
Type: roots | Date: 2026-09-10
2. Getting Daily Aggregate Data (All Commodities)...
✅ Daily Aggregate for 2026-09-11
- Total commodities tracked: 13
Sample Commodity Prices:
- Strawberries (berries)
Price: $40.50 - $49.50 / flat 8 1-lb
Movement: Slow
Top States: CA, FL
- Blueberries (berries)
Price: $49.50 - $60.50 / flat 12 6-oz
Movement: Very Active
Top States: WA, OR, MI
- Raspberries (berries)
Price: $58.50 - $71.50 / flat 12 6-oz
Movement: Active
Top States: WA, CA, OR
- Blackberries (berries)
Price: $54.00 - $66.00 / flat 12 6-oz
Movement: Active
Top States: OR, CA, TX
- Apples (fruits)
Price: $27.00 - $33.00 / 40 lb carton
Movement: Slow
Top States: WA, NY, MI
3. Testing Commodity-State Drill Down (Apples)...
✅ Apple Prices by State:
- Washington (WA)
Price Range: $27.93 - $30.87
Package: 40 lb carton
Quality: U.S. No. 1
Movement: Active
- New York (NY)
Price Range: $27.65 - $30.56
Package: 40 lb carton
Quality: U.S. No. 1
Movement: Very Active
- Michigan (MI)
Price Range: $26.79 - $29.61
Package: 40 lb carton
Quality: U.S. No. 1
Movement: Slow
- Pennsylvania (PA)
Price Range: $26.51 - $29.30
Package: 40 lb carton
Quality: U.S. No. 1
Movement: Moderate
4. Getting 10-Day Historical Data (Strawberries)...
✅ Strawberry prices in California (Last 10 days):
- 2026-09-01: $45.00 - $49.50 / flat 8 1-lb
Volume: 471 | Movement: Moderate
- 2026-09-02: $43.65 - $48.15 / flat 8 1-lb
Volume: 416 | Movement: Very Active
- 2026-09-03: $44.10 - $48.60 / flat 8 1-lb
Volume: 648 | Movement: Very Active
- 2026-09-04: $42.75 - $47.25 / flat 8 1-lb
Volume: 743 | Movement: Active
- 2026-09-05: $38.70 - $43.20 / flat 8 1-lb
Volume: 131 | Movement: Moderate
- 2026-09-06: $44.55 - $49.05 / flat 8 1-lb
Volume: 444 | Movement: Moderate
- 2026-09-07: $47.25 - $51.75 / flat 8 1-lb
Volume: 563 | Movement: Moderate
- 2026-09-08: $43.65 - $48.15 / flat 8 1-lb
Volume: 698 | Movement: Very Active
- 2026-09-09: $44.10 - $48.60 / flat 8 1-lb
Volume: 862 | Movement: Very Active
- 2026-09-10: $39.15 - $43.65 / flat 8 1-lb
Volume: 649 | Movement: Very Active
- 2026-09-11: $39.60 - $44.10 / flat 8 1-lb
Volume: 352 | Movement: Slow
5. Testing Shipping Point Dashboard Service...
✅ Dashboard Summary:
- Daily commodities: 13
- Reports available: 20
- Trending up: strawberries, avocados, tomatoes
- Trending down: potatoes, onions, carrots
- Period: 10 days
- Last updated: 2026-09-11 09:09:17
===========================================
SHIPPING POINT DATA STRUCTURE SUMMARY
===========================================
Market Type: Shipping Point (prices at origin/farm)
Drill Down: Commodity → State → Daily Prices
Aggregation: Daily totals with 10-day history
Coverage: Major producing states for each commodity
Key Features:
• State-by-state price comparison
• Daily price aggregates
• Movement indicators (Slow/Moderate/Active)
• Historical trending (up to 30 days)
• Package/unit specifications
• Quality grades (U.S. No. 1, etc.)
Note: Real implementation would parse USDA PDF reports
or connect to MyMarketNews data query interface.
📊 View Dashboard | 🍅 Tomatoes by State | 🍎 Apples by State | 🏠 Home