Query editor
WITH daily AS (SELECT day, project, messages, volume_usdFROM dune.gigagobin.result_canary_sentinel_app_dailyWHERE day >= DATE '2026-06-25'AND day <= DATE '2026-07-23'AND day < CURRENT_DATE),global_d AS (SELECTday,SUM(messages) AS msgs,SUM(volume_usd) AS usd,COUNT(DISTINCT project) AS appsFROM dailyGROUP BY 1),bands AS (SELECTCASEWHEN day < DATE '2026-07-09' THEN 'pre_14d'WHEN day >= DATE '2026-07-09' THEN 'post_14d'END AS era,AVG(msgs) AS msgs_mean_day,approx_percentile(msgs, 0.5) AS msgs_med_day,AVG(usd) AS usd_mean_day,approx_percentile(usd, 0.5) AS usd_med_day,AVG(apps) AS apps_mean_dayFROM global_dWHERE day BETWEEN DATE '2026-06-25' AND DATE '2026-07-22'GROUP BY 1),top_apps AS (SELECT projectFROM dune.gigagobin.result_canary_sentinel_app_dailyWHERE day >= CURRENT_DATE - INTERVAL '90' DAY AND day < CURRENT_DATEGROUP BY 1ORDER BY SUM(messages) DESCLIMIT 10),app_bands AS (SELECTd.project,CASE WHEN d.day < DATE '2026-07-09' THEN 'pre_14d' ELSE 'post_14d' END AS era,AVG(d.messages) AS msgs_mean,approx_percentile(d.messages, 0.5) AS msgs_med,AVG(d.volume_usd) AS usd_meanFROM daily dINNER JOIN top_apps t ON d.project = t.projectWHERE d.day BETWEEN DATE '2026-06-25' AND DATE '2026-07-22'GROUP BY 1, 2)SELECT 'global' AS scope, CAST(NULL AS varchar) AS project, era,msgs_mean_day AS msgs_mean, msgs_med_day AS msgs_med, usd_mean_day AS usd_meanFROM bandsUNION ALLSELECT 'app', project, era, msgs_mean, msgs_med, usd_meanFROM app_bandsORDER BY scope DESC, project, era