DFS Desk — Data Inventory (Mar 28, 2026)

Status: NOT BUILT — Zero tables, zero scrapers

WHAT THIS DESK DOES

Two value streams:

1. Win DraftKings DFS contests — Cash (50/50), GPP (tournaments), H2H
2. Beat Kalshi player props — use DK salary/ownership as signals for Kalshi prop mispricing

DraftKings is primary platform. FanDuel sportsbook is the sharp anchor for props (not DFS crowd).

EXISTING DATA (from other desks — no new collection needed)

TABLES TO BUILD (panel-approved schemas)

Priority 1 — Salary + Projections

CREATE TABLE dfs_dk_players (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    sport TEXT NOT NULL,
    slate_date TEXT NOT NULL,
    player_name TEXT NOT NULL,
    team TEXT NOT NULL,
    position TEXT NOT NULL,
    dk_salary INTEGER NOT NULL,
    dk_implied_fp REAL,
    projected_ownership REAL,
    actual_ownership REAL,
    actual_fp REAL,
    actual_pts INTEGER, actual_reb INTEGER, actual_ast INTEGER,
    fetched_at TEXT DEFAULT (datetime('now')),
    UNIQUE(sport, slate_date, player_name)
);

CREATE TABLE dfs_salary_history (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    sport TEXT NOT NULL,
    player_name TEXT NOT NULL,
    slate_date TEXT NOT NULL,
    dk_salary INTEGER NOT NULL,
    salary_5slate_avg REAL,
    salary_momentum REAL,
    UNIQUE(sport, player_name, slate_date)
);

CREATE TABLE dfs_player_distributions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    sport TEXT NOT NULL,
    player_name TEXT NOT NULL,
    stat_type TEXT NOT NULL,
    sample_size INTEGER,
    mean REAL NOT NULL,
    std_dev REAL NOT NULL,
    p10 REAL, p50 REAL, p90 REAL,
    gamma_k REAL, gamma_theta REAL, gamma_shift REAL,
    updated_at TEXT NOT NULL,
    UNIQUE(sport, player_name, stat_type)
);

Priority 2 — Ownership Snapshots + Late-Swap Detection

CREATE TABLE dfs_ownership_snapshots (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    sport TEXT NOT NULL,
    slate_date TEXT NOT NULL,
    player_name TEXT NOT NULL,
    snapshot_time TEXT NOT NULL,
    minutes_before_lock REAL,
    ownership_pct REAL NOT NULL,
    UNIQUE(sport, slate_date, player_name, snapshot_time)
);

Priority 3 — Correlations + Stacking

CREATE TABLE dfs_correlations (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    sport TEXT NOT NULL,
    player_a TEXT NOT NULL,
    player_b TEXT NOT NULL,
    correlation REAL NOT NULL,
    sample_size INTEGER,
    stack_type TEXT,
    updated_at TEXT DEFAULT (datetime('now')),
    UNIQUE(sport, player_a, player_b)
);

Priority 4 — Cross-Platform Signals + Results

CREATE TABLE dfs_kalshi_signals (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    sport TEXT NOT NULL,
    game_date TEXT NOT NULL,
    player_name TEXT NOT NULL,
    signal_type TEXT NOT NULL,
    dk_salary INTEGER,
    dk_implied_prob REAL,
    kalshi_ticker TEXT,
    kalshi_prop_type TEXT,
    kalshi_threshold REAL,
    kalshi_price REAL,
    kalshi_implied_prob REAL,
    fanduel_implied_prob REAL,
    edge_estimate REAL,
    signal_strength TEXT,
    direction TEXT,
    acted_on INTEGER DEFAULT 0,
    actual_result TEXT,
    pnl REAL,
    created_at TEXT DEFAULT (datetime('now')),
    UNIQUE(sport, game_date, player_name, kalshi_prop_type, kalshi_threshold)
);

CREATE TABLE dfs_contest_results (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    sport TEXT NOT NULL,
    slate_date TEXT NOT NULL,
    platform TEXT DEFAULT 'draftkings',
    contest_type TEXT NOT NULL,
    entry_fee REAL,
    payout REAL,
    placement INTEGER,
    percentile REAL,
    lineup_json TEXT,
    total_score REAL,
    created_at TEXT DEFAULT (datetime('now'))
);

APPROVED CUSTOM METRICS (from panel ruling)

DFS Contest Metrics

Kalshi Cross-Platform Signals

SPORTS COVERAGE

DATA SOURCES (DFS-specific)

PANEL RULING REFERENCE

Full ruling: /home/ubuntu/edgeclaw/results/panel-results/dfs-panel-ruling.md Panel: Opus + Sonnet + Grok 4.2 + Gemini Pro 3.1 (Mar 28, 2026, Grade: A)