1. Fetching Shipping Point Reports (Last 10 days)...
✅ Success! Found 19 shipping point reports
Sample Reports by State:
- [IX] Phoenix Shipping Point Vegetables Prices (IX_FV120)
Type: vegetable | Date: 2026-03-13
- [YA] YAKIMA Shipping Point Fruit Prices (YA_FV110)
Type: fruit | Date: 2026-03-13
- [FR] Fresno Shipping Point Fruit Prices (FR_FV110)
Type: fruit | Date: 2026-03-13
- [IF] Idaho Falls Shipping Point Onions and Potatoes Prices (IF_FV130)
Type: roots | Date: 2026-03-13
- [OR] Orlando Shipping Point Fruit Prices (OR_FV110)
Type: fruit | Date: 2026-03-13
2. Getting Daily Aggregate Data (All Commodities)...
✅ Daily Aggregate for 2026-03-15
- Total commodities tracked: 13
Sample Commodity Prices:
- Strawberries (berries)
Price: $40.50 - $49.50 / flat 8 1-lb
Movement: Active
Top States: CA, FL
- Blueberries (berries)
Price: $49.50 - $60.50 / flat 12 6-oz
Movement: Moderate
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: Moderate
Top States: OR, CA, TX
- Apples (fruits)
Price: $27.00 - $33.00 / 40 lb carton
Movement: Moderate
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: Active
- Michigan (MI)
Price Range: $26.79 - $29.61
Package: 40 lb carton
Quality: U.S. No. 1
Movement: Active
- Pennsylvania (PA)
Price Range: $26.51 - $29.30
Package: 40 lb carton
Quality: U.S. No. 1
Movement: Very Active
4. Getting 10-Day Historical Data (Strawberries)...
✅ Strawberry prices in California (Last 10 days):
- 2026-03-05: $45.90 - $50.40 / flat 8 1-lb
Volume: 177 | Movement: Very Active
- 2026-03-06: $41.85 - $46.35 / flat 8 1-lb
Volume: 162 | Movement: Very Active
- 2026-03-07: $45.00 - $49.50 / flat 8 1-lb
Volume: 496 | Movement: Very Active
- 2026-03-08: $41.40 - $45.90 / flat 8 1-lb
Volume: 542 | Movement: Very Active
- 2026-03-09: $44.10 - $48.60 / flat 8 1-lb
Volume: 205 | Movement: Moderate
- 2026-03-10: $43.65 - $48.15 / flat 8 1-lb
Volume: 794 | Movement: Moderate
- 2026-03-11: $43.20 - $47.70 / flat 8 1-lb
Volume: 401 | Movement: Moderate
- 2026-03-12: $46.35 - $50.85 / flat 8 1-lb
Volume: 962 | Movement: Active
- 2026-03-13: $46.35 - $50.85 / flat 8 1-lb
Volume: 565 | Movement: Active
- 2026-03-14: $42.30 - $46.80 / flat 8 1-lb
Volume: 498 | Movement: Moderate
- 2026-03-15: $38.70 - $43.20 / flat 8 1-lb
Volume: 190 | Movement: Very Active
5. Testing Shipping Point Dashboard Service...
✅ Dashboard Summary:
- Daily commodities: 13
- Reports available: 19
- Trending up: strawberries, avocados, tomatoes
- Trending down: potatoes, onions, carrots
- Period: 10 days
- Last updated: 2026-03-15 00:21:25
===========================================
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