| Detail | Value |
|---|---|
| Rows | 122,986 |
| Schedule | Every 30 min |
| Coverage | 273 active series (of 2,242+ total Entertainment category) |
| Columns | series_ticker, market_ticker, title, yes_price, no_price, volume, open_interest, last_trade_at, status, captured_at |
| What it gives us | Full price history for all culture contracts. Feeds stale price detector. |
| Detail | Value |
|---|---|
| Rows | 912 |
| Schedule | 8 AM daily |
| What it gives us | Expert panel odds for Oscars/Emmys/Grammys — primary anchor for awards contracts |
| Detail | Value |
|---|---|
| Rows | 395 |
| Schedule | 6:15 AM daily |
| What it gives us | Most-shazamed songs — leading indicator for chart entry (73% top-50 within 14 days when rank improves 20+ positions) |
| Detail | Value |
|---|---|
| Rows | 204 |
| What it gives us | Multi-platform streaming rankings (FlixPatrol) |
| Detail | Value |
|---|---|
| Rows | 202 |
| What it gives us | Computed streaming metrics — GTSI, amplification, decay curves |
| Detail | Value |
|---|---|
| Rows | 176 |
| Schedule | 9AM/9PM |
| What it gives us | Advance ticket sales — strongest predictor of opening weekend gross |
| Detail | Value |
|---|---|
| Rows | 2 |
| Schedule | 7:15 AM daily |
| What it gives us | Daily/weekend gross, theater count, RT scores, genre, implied weekend range |
| Note | Very low row count — scraper may need attention |
| Detail | Value |
|---|---|
| Rows | 2 |
| Schedule | 4x daily |
| What it gives us | Critic + audience scores, review count, divergence |
| Note | Very low row count — scraper may need attention |
| Detail | Value |
|---|---|
| Rows | 2 |
| What it gives us | Computed box office metrics — Thursday multipliers, pre-sale curve matching |
| Table | Expected Source | Status |
|---|---|---|
| culture_spotify_daily | Spotify Charts API | 0 rows — scraper not collecting |
| culture_tiktok_sounds | TikTok trending sounds | 0 rows — scraper not collecting |
| culture_google_trends | Google Trends API | 0 rows — scraper not collecting |
| culture_music_metrics | Computed (SVA, CPMD, PPVI, viral coefficient) | 0 rows — depends on Spotify data |
| culture_awards_predictions | Precursor tournament model output | 0 rows — model not built |
| culture_stale_alerts | Stale Price Detector output | 0 rows — detector not running |
| Component | Priority | Status |
|---|---|---|
| Stale Price Detector | Highest — applies to ALL 273 series | Not built |
| Spotify daily streams collection | Tier 1 — feeds SVA, CPMD, PPVI | Not collecting |
| TikTok sound tracking | Tier 1 — feeds CPMD pipeline lag | Not collecting |
| Google Trends collection | Tier 2 — feeds GTSI | Not collecting |
| Billboard chart scraper | Tier 1 — settlement source | Not built |
| Stream Velocity Acceleration (SVA) | Music metric | Not computed (needs Spotify) |
| TikTok-to-Spotify Pipeline Lag (CPMD) | Music metric — most actionable signal | Not computed (needs TikTok + Spotify) |
| Playlist Placement Velocity (PPVI) | Music metric | Not computed (needs Spotify playlist data) |
| Viral Coefficient | Music metric | Not computed (needs chart + viral ranks) |
| Thursday-to-Weekend Multiplier | Box office metric | Partially built (culture_boxoffice_metrics) |
| Precursor Tournament Model | Awards metric (PGA+DGA+SAG+BAFTA) | Not built |
| Streaming Decay Curve | Streaming metric | Partially built (culture_streaming_metrics) |
| Cross-Platform Amplification | Streaming metric | Partially built |
| culture_edge_signals table | Final output table for all tiers | Not created |
| File | Function | Status |
|---|---|---|
| scrape-culture-kalshi.ts | Kalshi price collection (all 273 series) | Running every 30 min |
| culture-series.ts | Dynamic series discovery from Kalshi API | Running (24h cache) |
| culture-metrics.ts | Music metrics computation | Running (8:30 AM daily) |
| culture-boxoffice-metrics.ts | Box office metrics | Running |
| culture-streaming-metrics.ts | Streaming metrics | Running |
| culture-awards-model.ts | Awards prediction model | Built, needs data |
| culture-awards-calibration.ts | Awards model calibration | Built, needs data |
| culture-stale-detector.ts | Stale price detection | Built, not wired to cron |
| Time (ET) | Job | Status |
|---|---|---|
| Every 30 min | Kalshi culture prices | Running |
| 6 AM daily | Spotify, Shazam | Shazam running, Spotify not |
| 4x daily | TikTok sounds, RT scores | RT partially, TikTok not |
| 7:15 AM daily | Box Office Mojo | Running (low data) |
| 8 AM daily | Gold Derby, FlixPatrol | Gold Derby running, FlixPatrol running |
| 8:30 AM daily | Culture metrics computation | Running |
| 8:45 AM / 2 PM | Stale Price Detector | Not running |
| 9 AM / 9 PM | Fandango pre-sales | Running |
| Tue 10 AM | Billboard, Netflix Top 10 | Netflix running, Billboard not |
| 3x daily | Google Trends | Not running |
Full ruling: /home/ubuntu/edgeclaw/results/panel-results/culture-data-final-ruling.md
Panel: Opus + Sonnet + Grok 4.2 Reasoning + Gemini Pro 3.1 (Mar 26, 2026)
Grade: A