Query editor
-- P5 mid-band FP probe: USD ∈ (med, 1.5×k3_p90] under k3 vs MAD κ=3-- Apps: Ethena, PayPal, Stargate | windows 90d/365d | USD plane-- Warn proxy (same as fnfp): value > band_upper AND value > 3×band_med-- Critical proxy: Warn AND value > 5×band_med-- Labels: FP-probe / control-ish mid-elevated (not true incidents)WITH apps AS (SELECT * FROM (VALUES ('Ethena'), ('PayPal'), ('Stargate')) AS t(project)),base AS (SELECT d.project, d.day, d.messages, d.volume_usdFROM dune.gigagobin.result_canary_sentinel_app_daily dINNER JOIN apps a ON d.project = a.projectWHERE d.day < CURRENT_DATE AND d.day >= CURRENT_DATE - INTERVAL '365' DAY),wins AS (SELECT * FROM (VALUES ('90d'), ('365d')) AS t(w)),expanded AS (SELECT b.project, w.w, b.day, b.messages, b.volume_usdFROM base bCROSS JOIN wins wWHERE (w.w = '365d') OR (w.w = '90d' AND b.day >= CURRENT_DATE - INTERVAL '90' DAY)),rnk AS (SELECT *,ROW_NUMBER() OVER (PARTITION BY project, w ORDER BY volume_usd DESC) AS rn_usdFROM expanded),-- Inclusive + k3 (drop top 3 USD) rows for band edgesincl AS (SELECT project, w, volume_usd AS val FROM rnk),k3 AS (SELECT project, w, volume_usd AS val FROM rnk WHERE rn_usd > 3),incl_stats AS (SELECT project, w,COUNT(*) AS n_incl,approx_percentile(val, 0.5) AS incl_med,approx_percentile(val, 0.9) AS incl_p90FROM incl GROUP BY 1,2),k3_stats AS (SELECT project, w,COUNT(*) AS n_k3,approx_percentile(val, 0.5) AS k3_med,approx_percentile(val, 0.9) AS k3_p90FROM k3 GROUP BY 1,2),mad_calc AS (SELECT i.project, i.w,s.incl_med AS mad_med,approx_percentile(ABS(i.val - s.incl_med), 0.5) AS madFROM incl iINNER JOIN incl_stats s ON i.project = s.project AND i.w = s.wGROUP BY i.project, i.w, s.incl_med),bands AS (SELECTi.project, i.w,