Query editor
WITH legs AS (SELECT split_part(from_asset, '.', 1) AS chain_prefix, from_amount_usd AS usd, block_timestampFROM thorchain.defi_swapsWHERE block_timestamp >= CURRENT_DATE - INTERVAL '30' DAYUNION ALLSELECT split_part(to_asset, '.', 1) AS chain_prefix, to_amount_usd AS usd, block_timestampFROM thorchain.defi_swapsWHERE block_timestamp >= CURRENT_DATE - INTERVAL '30' DAY)SELECTchain_prefix,COUNT(*) AS legs_30d,SUM(usd) AS usd_30d,MIN(block_timestamp) AS first_seen,MAX(block_timestamp) AS last_seenFROM legsWHERE chain_prefix IS NOT NULL AND chain_prefix <> ''GROUP BY 1ORDER BY usd_30d DESC