Query editor
WITH apps AS (SELECT * FROM (VALUES ('Ethena'), ('PayPal'), ('Ether.Fi'), ('Stargate')) AS t(project)),daily 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_DATEAND d.day >= CURRENT_DATE - INTERVAL '365' DAY),rnk AS (SELECT *,ROW_NUMBER() OVER (PARTITION BY project ORDER BY volume_usd DESC, day DESC) AS rn_usd,ROW_NUMBER() OVER (PARTITION BY project ORDER BY messages DESC, day DESC) AS rn_msgsFROM daily),top_usd AS (SELECT project, day, messages, volume_usd, rn_usd AS rank_in_metric, 'usd' AS metric_planeFROM rnk WHERE rn_usd <= 5),top_msgs AS (SELECT project, day, messages, volume_usd, rn_msgs AS rank_in_metric, 'msgs' AS metric_planeFROM rnk WHERE rn_msgs <= 5)SELECT * FROM top_usdUNION ALLSELECT * FROM top_msgsORDER BY project, metric_plane, rank_in_metric