POOL_NAME,

SUM(FROM_AMOUNT) AS total_volume,

AVG(LIQ_FEE_RUNE_USD) AS avg_liquidity_fee_usd

FROM thorchain.defi.fact_swaps

WHERE BLOCKCHAIN = 'THOR'

GROUP BY POOL_NAME

ORDER BY total_volume DESC

LIMIT 10;