AI Diagnostics

SELECT s.`code` AS code,
       s.`name` AS name,
       MIN(f.`d`) AS first_date,
       MAX(f.`d`) AS last_date,
       COUNT(*) AS row_count
FROM `ai_feature_daily` f
JOIN `symbols` s ON s.`id` = f.`symbol_id`
WHERE s.`is_active` = 1
GROUP BY s.`id`, s.`code`, s.`name`
ORDER BY row_count DESC, code ASC
LIMIT 200

{
    "ok": true,
    "feature_run_id": 33,
    "backend": "xgboost_gpu",
    "device": "cuda",
    "feature_cols": [
        "ret_1d",
        "mom_5d",
        "mom_10d",
        "mom_20d",
        "vol_avg_5",
        "vol_avg_20",
        "rolling_volatility_20",
        "volume_spike_20",
        "takas_lot_sum",
        "takas_lot_diff_1d",
        "takas_float_pct_avg",
        "takas_float_pct_diff_1d",
        "mom_60d",
        "sma_10",
        "sma_20",
        "sma_50",
        "sma_100",
        "sma_200",
        "ema_12",
        "ema_20",
        "ema_50",
        "ema_200",
        "price_vs_sma20_pct",
        "price_vs_sma50_pct",
        "sma20_vs_sma50_pct",
        "sma50_vs_sma200_pct",
        "rsi_14",
        "macd_line",
        "macd_signal",
        "macd_hist",
        "atr_14",
        "bb_mid",
        "bb_upper",
        "bb_lower",
        "bb_pos",
        "adx_14",
        "donchian_20_breakout",
        "high_20_breakout",
        "low_20_breakdown",
        "high_55_breakout",
        "distance_to_high_20_pct",
        "distance_to_low_20_pct",
        "breakout_on_volume",
        "bullish_div_rsi",
        "bearish_div_rsi",
        "bullish_div_macd",
        "bearish_div_macd",
        "divergence_score",
        "trend_regime_code",
        "setup_compression_score",
        "setup_accumulation_score",
        "setup_acceptance_score",
        "setup_spring_score",
        "setup_relative_strength_score",
        "setup_breakout_quality_score",
        "base_break_score",
        "reclaim_break_score",
        "final_setup_score",
        "acceptance_bars_3",
        "spring_flag",
        "breakout_flag",
        "rsr_value",
        "target_follow_through_strength_5d",
        "target_exhaustion_risk_5d"
    ],
    "rows_all": 46834,
    "train_rows": 46834,
    "validation_rows": 0,
    "gpu_used": 1,
    "duration_seconds": 871.7910000000000536601874046027660369873046875,
    "params": {
        "n_estimators": 600,
        "max_depth": 4,
        "learning_rate": 0.05000000000000000277555756156289135105907917022705078125,
        "subsample": 0.8000000000000000444089209850062616169452667236328125,
        "colsample_bytree": 0.8000000000000000444089209850062616169452667236328125,
        "min_child_weight": 3,
        "reg_lambda": 1
    },
    "candidate_results": [
        {
            "backend": "xgboost_gpu",
            "device": "cuda",
            "gpu_used": 1,
            "primary_metric_name": "mean_precision_at_10",
            "primary_metric_value": 1,
            "mean_auc": 0.82467400000000001814015604395535774528980255126953125,
            "mean_pr_auc": 0.84811000000000003051781050089630298316478729248046875,
            "mean_precision_at_10": 1,
            "mean_hit_rate_at_10": 1,
            "device_fallback_count": 0
        },
        {
            "backend": "catboost_gpu",
            "device": "cuda",
            "gpu_used": 1,
            "primary_metric_name": "mean_precision_at_10",
            "primary_metric_value": 1,
            "mean_auc": 0.83667800000000003279865268268622457981109619140625,
            "mean_pr_auc": 0.8557259999999999866560074224253185093402862548828125,
            "mean_precision_at_10": 1,
            "mean_hit_rate_at_10": 1,
            "device_fallback_count": 0
        }
    ],
    "setup_feature_enabled": true,
    "setup_label_summary": {
        "breakout_success_5d": 0,
        "reclaim_success_5d": 0,
        "false_breakout_5d": 0,
        "watch_positive_5d": 0
    },
    "champion_compare": {
        "current_primary_metric": 1,
        "new_primary_metric": 1,
        "metric_name": "mean_precision_at_10"
    },
    "primary_metric": "mean_precision_at_10",
    "mean_auc": 0.82467400000000001814015604395535774528980255126953125,
    "mean_pr_auc": 0.84811000000000003051781050089630298316478729248046875,
    "mean_precision_at_10": 1,
    "mean_precision_at_20": 1,
    "mean_hit_rate_at_10": 1,
    "mean_hit_rate_at_20": 1,
    "device_fallback_count": 0,
    "feature_importance": [],
    "top_features": [],
    "model_registry_id": 36,
    "artifact_path": "/opt/uypa-ai-worker/models/xgboost_gpu_40.joblib",
    "training_frame": {
        "rows_raw": 2477311,
        "rows_after_required": 46834,
        "rows_final": 46834,
        "symbols": 632,
        "source_mode": "materialized_store_latest_per_symbol_day",
        "requested_feature_run_id": 33
    },
    "forecast_bundle": {
        "ok": true,
        "model_registry_id": 37,
        "model_key": "forecast_bundle_40",
        "trained_horizons": [
            1,
            3,
            5
        ],
        "metrics": {
            "h1": {
                "rows": 1618729,
                "mae": 0.0177716932566145020822023781192910973913967609405517578125,
                "rmse": 0.0246851074153072967687361227717701694928109645843505859375,
                "r2": 0.43443617001359602358689926404622383415699005126953125
            },
            "h3": {
                "rows": 1617521,
                "mae": 0.023562756017329482272071317083828034810721874237060546875,
                "rmse": 0.035177556471070854648974801648364518769085407257080078125,
                "r2": 0.6691211222046586915013222096604295074939727783203125
            },
            "h5": {
                "rows": 1616313,
                "mae": 0.0169059301278748248809069565368190524168312549591064453125,
                "rmse": 0.033674443438136691941764411240001209080219268798828125,
                "r2": 0.82613787440369834680353733347146771848201751708984375
            }
        }
    },
    "divergence_bundle": {
        "ok": true,
        "model_registry_id": 38,
        "model_key": "divergence_success_bundle_40",
        "backend": "sklearn_hgbc",
        "trained_horizons": [
            3,
            5
        ],
        "metrics": {
            "h3": {
                "rows": 49467,
                "train_rows": 39573,
                "valid_rows": 9894,
                "auc": 0.61236870191572123633960700317402370274066925048828125,
                "pr_auc": 0.57221602451401165634337075971416197717189788818359375,
                "brier": 0.2395755861326112068354632356204092502593994140625,
                "positive_rate": 0.460582171012734964410384463917580433189868927001953125
            },
            "h5": {
                "rows": 49428,
                "train_rows": 39542,
                "valid_rows": 9886,
                "auc": 0.60046153688395076386541404644958674907684326171875,
                "pr_auc": 0.512562785830016576227308178204111754894256591796875,
                "brier": 0.23857464699777353178689054402639158070087432861328125,
                "positive_rate": 0.419178636455593778276096372792380861937999725341796875
            }
        }
    },
    "setup_bundle": {
        "ok": true,
        "feature_cols_enabled": [
            "setup_compression_score",
            "setup_accumulation_score",
            "setup_acceptance_score",
            "setup_spring_score",
            "setup_relative_strength_score",
            "setup_breakout_quality_score",
            "base_break_score",
            "reclaim_break_score",
            "final_setup_score",
            "rsr_value"
        ],
        "label_summary": {
            "breakout_success_5d": 0,
            "reclaim_success_5d": 0,
            "false_breakout_5d": 0,
            "watch_positive_5d": 0
        }
    }
}

{
    "ok": true,
    "mode": "daily",
    "predict_run_id": 42,
    "model_registry_id": 36,
    "model_key": "xgboost_gpu_20260511215631",
    "backend": "xgboost_gpu",
    "device": "cuda",
    "feature_run_id": 33,
    "predict_date": "2026-05-11",
    "requested_predict_date": "2026-05-11",
    "used_feature_date": "2026-05-11",
    "feature_date_fallback_used": 0,
    "snapshot_scope": "selected_run",
    "rows_loaded_for_scoring": 601,
    "rows_written": 601,
    "anchor_meta": {
        "requested_predict_date": null,
        "last_predict_date": "2026-05-11",
        "last_predict_run_id": 32,
        "selected_run_id": 33,
        "selected_run_min_d": "2010-01-04",
        "selected_run_max_d": "2026-05-11",
        "latest_feature_run_id": 33,
        "latest_feature_run_min_d": "2010-01-04",
        "latest_feature_run_max_d": "2026-05-11",
        "chosen_feature_run_id": 33,
        "chosen_feature_run_min_d": "2010-01-04",
        "chosen_feature_run_max_d": "2026-05-11",
        "chosen_reason": "latest_feature_run",
        "anchor_date": "2026-05-11",
        "anchor_reason": "chosen_run_max_date",
        "anchor_override_used": 0
    },
    "gpu_used": 1,
    "gpu_inference_used": 1,
    "predict_method": "xgboost_inplace_predict_gpu",
    "predict_device_used": "cuda:0",
    "top_predictions": [
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 41,
            "code": "ANGEN",
            "d": "2026-05-11",
            "up_prob": 0.999446928501129150390625,
            "pred_class": 1,
            "score_rank": 1,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 502,
            "code": "SMRTG",
            "d": "2026-05-11",
            "up_prob": 0.999269187450408935546875,
            "pred_class": 1,
            "score_rank": 2,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 454,
            "code": "PNSUT",
            "d": "2026-05-11",
            "up_prob": 0.99915444850921630859375,
            "pred_class": 1,
            "score_rank": 3,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 91,
            "code": "BIGEN",
            "d": "2026-05-11",
            "up_prob": 0.999043524265289306640625,
            "pred_class": 1,
            "score_rank": 4,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 191,
            "code": "EKOS",
            "d": "2026-05-11",
            "up_prob": 0.998874962329864501953125,
            "pred_class": 1,
            "score_rank": 5,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 592,
            "code": "YKSLN",
            "d": "2026-05-11",
            "up_prob": 0.998785674571990966796875,
            "pred_class": 1,
            "score_rank": 6,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 487,
            "code": "SEGMN",
            "d": "2026-05-11",
            "up_prob": 0.998742759227752685546875,
            "pred_class": 1,
            "score_rank": 7,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 337,
            "code": "KORDS",
            "d": "2026-05-11",
            "up_prob": 0.998727142810821533203125,
            "pred_class": 1,
            "score_rank": 8,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 318,
            "code": "KERVN",
            "d": "2026-05-11",
            "up_prob": 0.998710155487060546875,
            "pred_class": 1,
            "score_rank": 9,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 169,
            "code": "DOKTA",
            "d": "2026-05-11",
            "up_prob": 0.9987051486968994140625,
            "pred_class": 1,
            "score_rank": 10,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 380,
            "code": "MEGMT",
            "d": "2026-05-11",
            "up_prob": 0.998676240444183349609375,
            "pred_class": 1,
            "score_rank": 11,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 62,
            "code": "ATSYH",
            "d": "2026-05-11",
            "up_prob": 0.998638451099395751953125,
            "pred_class": 1,
            "score_rank": 12,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 450,
            "code": "PKART",
            "d": "2026-05-11",
            "up_prob": 0.9985752105712890625,
            "pred_class": 1,
            "score_rank": 13,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 473,
            "code": "RTALB",
            "d": "2026-05-11",
            "up_prob": 0.998471796512603759765625,
            "pred_class": 1,
            "score_rank": 14,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 33,
            "code": "ALFAS",
            "d": "2026-05-11",
            "up_prob": 0.99844825267791748046875,
            "pred_class": 1,
            "score_rank": 15,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 458,
            "code": "PRKAB",
            "d": "2026-05-11",
            "up_prob": 0.998421192169189453125,
            "pred_class": 1,
            "score_rank": 16,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 233,
            "code": "GENIL",
            "d": "2026-05-11",
            "up_prob": 0.998356163501739501953125,
            "pred_class": 1,
            "score_rank": 17,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 519,
            "code": "TATEN",
            "d": "2026-05-11",
            "up_prob": 0.9983413219451904296875,
            "pred_class": 1,
            "score_rank": 18,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 586,
            "code": "YEOTK",
            "d": "2026-05-11",
            "up_prob": 0.99827325344085693359375,
            "pred_class": 1,
            "score_rank": 19,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        },
        {
            "predict_run_id": 42,
            "feature_run_id": 33,
            "symbol_id": 597,
            "code": "ZEDUR",
            "d": "2026-05-11",
            "up_prob": 0.998218953609466552734375,
            "pred_class": 1,
            "score_rank": 20,
            "model_key": "xgboost_gpu_20260511215631",
            "target_name": "next_up_h1"
        }
    ],
    "forecast_rows_written": 1803,
    "forecast_model_key": "forecast_bundle_40"
}