Updated: 2026-04-03 | Database: research-pipeline.db
| Table | Filter | Rows | Schedule |
|---|---|---|---|
| sports_odds_snapshots | sport=golf, source=kalshi | 40,826 | Every 30min |
15 market categories tracked via series prefixes. See strategy spec for full list.
| Table | Rows | Key Columns | Schedule |
|---|---|---|---|
| golf_player_sg | 167 | player_name, sg_total, sg_t2g, sg_ott, sg_app, sg_arg, sg_putt, rounds | Daily 11AM |
| golf_tournament_results | 1,145 | tournament_id, player_name, position, score_to_par, r1-r4, made_cut | Daily 11AM |
| golf_player_form | 253 | player_name, events_played, avg_finish, avg_score_to_par, cut_rate, top5/10/20s | Daily 11AM |
| golf_owgr | 500 | rank, player_name, country, avg_points, total_points, events_played | Weekly |
| golf_course_data | 10 | course_name, tournament_name, kalshi_prefix, grass_type, par, dna_ott/app/arg/putt, course_type | Static |
| Table | Filter | Rows | Schedule |
|---|---|---|---|
| sports_edges | sport=golf, market_type=h2h | 2 | 4x daily |
| sports_edges | sport=golf, market_type=makecut | 2 | 4x daily |
| sports_edges | sport=golf, market_type=top5 | 3 | 4x daily |
| sports_edges | sport=golf, market_type=top10 | 3 | 4x daily |
| sports_edges | sport=golf, market_type=top20 | 3 | 4x daily |
| Table | Filter | Rows | Schedule |
|---|---|---|---|
| sports_odds_snapshots | sport=golf, source=pinnacle | — | Adaptive |
| sbr_book_odds | sport=golf | — | 4x daily |
| pregame_consensus | sport=Golf | 19 | 3x daily |
| Parameter | Value |
|---|---|
| SG source | PGA Tour GraphQL API (free) |
| EWMA weights | Not yet (future: 30%/35%/35% at 0.85/0.92/0.97 decay) |
| MC simulations | 50,000 |
| Min net edge | 4 cents |
| Max spread | 25 cents |
| Kalshi fee | 7% |
| Tournament sigma | 5.6 strokes |
| H2H sigma | 7.9 strokes |
| Cut logistic base | 0.6 (~65% base rate) |
| Cut SG factor | 1.5 |