Query editor
WITH pools AS (SELECTpool_name,SUM(swap_count) AS swaps_7d,SUM(swap_volume_rune_usd) AS vol_7d_usd,MAX(day) AS last_dayFROM thorchain.defi_daily_pool_statsWHERE day >= CURRENT_DATE - INTERVAL '7' DAYGROUP BY 1),chain_roll AS (SELECTsplit_part(pool_name, '.', 1) AS chain_prefix,COUNT(*) AS pool_count,SUM(swaps_7d) AS swaps_7d,SUM(vol_7d_usd) AS vol_7d_usdFROM poolsGROUP BY 1)SELECT 'CHAIN' AS row_kind, chain_prefix AS name, pool_count, swaps_7d, vol_7d_usd, NULL AS last_dayFROM chain_rollUNION ALLSELECT 'POOL' AS row_kind, pool_name AS name, 1, swaps_7d, vol_7d_usd, CAST(last_day AS varchar)FROM poolsORDER BY row_kind, vol_7d_usd DESC