1. Fetching Shipping Point Reports (Last 10 days)...
✅ Success! Found 21 shipping point reports
Sample Reports by State:
- [IX] Phoenix Shipping Point Vegetables Prices (IX_FV120)
Type: vegetable | Date: 2026-07-10
- [YA] YAKIMA Shipping Point Fruit Prices (YA_FV110)
Type: fruit | Date: 2026-07-10
- [FR] Fresno Shipping Point Fruit Prices (FR_FV110)
Type: fruit | Date: 2026-07-10
- [IF] Idaho Falls Shipping Point Onions and Potatoes Prices (IF_FV130)
Type: roots | Date: 2026-07-10
- [OR] Orlando Shipping Point Vegetables Prices (OR_FV120)
Type: vegetable | Date: 2026-07-10
2. Getting Daily Aggregate Data (All Commodities)...
✅ Daily Aggregate for 2026-07-13
- Total commodities tracked: 13
Sample Commodity Prices:
- Strawberries (berries)
Price: $40.50 - $49.50 / flat 8 1-lb
Movement: Moderate
Top States: CA, FL
- Blueberries (berries)
Price: $49.50 - $60.50 / flat 12 6-oz
Movement: Slow
Top States: WA, OR, MI
- Raspberries (berries)
Price: $58.50 - $71.50 / flat 12 6-oz
Movement: Slow
Top States: WA, CA, OR
- Blackberries (berries)
Price: $54.00 - $66.00 / flat 12 6-oz
Movement: Very 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: Very 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: Active
4. Getting 10-Day Historical Data (Strawberries)...
✅ Strawberry prices in California (Last 10 days):
- 2026-07-03: $38.25 - $42.75 / flat 8 1-lb
Volume: 655 | Movement: Active
- 2026-07-04: $44.55 - $49.05 / flat 8 1-lb
Volume: 208 | Movement: Moderate
- 2026-07-05: $45.90 - $50.40 / flat 8 1-lb
Volume: 797 | Movement: Slow
- 2026-07-06: $44.10 - $48.60 / flat 8 1-lb
Volume: 802 | Movement: Active
- 2026-07-07: $47.25 - $51.75 / flat 8 1-lb
Volume: 285 | Movement: Slow
- 2026-07-08: $45.00 - $49.50 / flat 8 1-lb
Volume: 931 | Movement: Very Active
- 2026-07-09: $41.40 - $45.90 / flat 8 1-lb
Volume: 770 | Movement: Slow
- 2026-07-10: $46.35 - $50.85 / flat 8 1-lb
Volume: 634 | Movement: Slow
- 2026-07-11: $43.65 - $48.15 / flat 8 1-lb
Volume: 709 | Movement: Moderate
- 2026-07-12: $40.95 - $45.45 / flat 8 1-lb
Volume: 868 | Movement: Very Active
- 2026-07-13: $45.45 - $49.95 / flat 8 1-lb
Volume: 520 | Movement: Very Active
5. Testing Shipping Point Dashboard Service...
✅ Dashboard Summary:
- Daily commodities: 13
- Reports available: 21
- Trending up: strawberries, avocados, tomatoes
- Trending down: potatoes, onions, carrots
- Period: 10 days
- Last updated: 2026-07-13 08:40:47
===========================================
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