with raw as (select distinct tx_id, liq_fee_rune_usd, liq_fee_asset_usd, pool_name, from_amount_usd
from thorchain.swaps
where block_timestamp >= CURRENT_DATE - 30)
select sum(liq_fee_rune_usd) as total_fees, pool_name, sum(from_amount_usd) as swap_vol
from raw
group by 2
order by 1 desc
limit 10