Query editor
WITH daily AS (SELECT *FROM dune.gigagobin.result_canary_sentinel_app_dailyWHERE day < CURRENT_DATE),app_life AS (SELECTproject,MIN(day) AS first_seen,MAX(day) AS last_seen,COUNT(*) AS active_days_all,SUM(messages) AS msgs_all,SUM(volume_usd) AS usd_allFROM dailyGROUP BY 1),top25 AS (SELECT projectFROM dailyWHERE day >= CURRENT_DATE - INTERVAL '365' DAYGROUP BY 1ORDER BY SUM(messages) DESCLIMIT 25),expanded AS (SELECT project, '7d' AS window_name, messages, volume_usd, avg_usd_per_message, dayFROM dailyWHERE project IN (SELECT project FROM top25)AND day >= CURRENT_DATE - INTERVAL '7' DAY AND day < CURRENT_DATEUNION ALLSELECT project, '30d', messages, volume_usd, avg_usd_per_message, dayFROM dailyWHERE project IN (SELECT project FROM top25)AND day >= CURRENT_DATE - INTERVAL '30' DAY AND day < CURRENT_DATEUNION ALLSELECT project, '90d', messages, volume_usd, avg_usd_per_message, dayFROM dailyWHERE project IN (SELECT project FROM top25)AND day >= CURRENT_DATE - INTERVAL '90' DAY AND day < CURRENT_DATEUNION ALLSELECT project, '180d', messages, volume_usd, avg_usd_per_message, dayFROM dailyWHERE project IN (SELECT project FROM top25)AND day >= CURRENT_DATE - INTERVAL '180' DAY AND day < CURRENT_DATEUNION ALLSELECT project, '365d', messages, volume_usd, avg_usd_per_message, dayFROM dailyWHERE project IN (SELECT project FROM top25)AND day >= CURRENT_DATE - INTERVAL '365' DAY AND day < CURRENT_DATE),agg AS (SELECTproject,window_name,COUNT(*) AS days_in_window,approx_percentile(messages, 0.5) AS msgs_median,approx_percentile(messages, 0.1) AS msgs_p10,approx_percentile(messages, 0.9) AS msgs_p90,approx_percentile(volume_usd, 0.5) AS usd_median,approx_percentile(volume_usd, 0.1) AS usd_p10,