Query editor
WITH sw AS (SELECT split_part(from_asset, '.', 1) AS src_chain,COUNT(*) AS swap_legs,COUNT(DISTINCT tx_id) AS swap_txsFROM thorchain.defi_swapsWHERE block_timestamp >= CURRENT_DATE - INTERVAL '30' dayAND from_asset NOT LIKE 'THOR.RUNE%'GROUP BY 1),rf AS (SELECT split_part(asset, '.', 1) AS src_chain,COUNT(*) AS refunds,COUNT(DISTINCT tx_id) AS refund_txsFROM thorchain.defi_refund_eventsWHERE block_timestamp >= CURRENT_DATE - INTERVAL '30' dayGROUP BY 1)SELECTCOALESCE(sw.src_chain, rf.src_chain) AS chain,sw.swap_txs,rf.refund_txs,100.0 * COALESCE(rf.refund_txs, 0)/ NULLIF(sw.swap_txs + COALESCE(rf.refund_txs, 0), 0) AS pct_refundedFROM swFULL OUTER JOIN rf ON sw.src_chain = rf.src_chainORDER BY sw.swap_txs DESC NULLS LAST