with raw as (select distinct tx_id, liq_fee_rune_usd, liq_fee_asset_usd, from_address, from_amount_usd
from thorchain.swaps
where block_timestamp >= CURRENT_DATE - 30)
select from_address, count (distinct tx_id) as tx_count, sum(from_amount_usd) as total_swaps, avg(from_amount_usd) as average_swaps
from raw
group by 1
order by 2 desc
limit 25