concat(from_asset,'-',to_asset) as pair, count(distinct(tx_id)) as frequency, sum(to_amount_usd) as volume

from thorchain.defi.fact_swaps

where block_timestamp>='2024-01-01' and block_timestamp<trunc(current_date,'week')

group by 1,2

having frequency>1000

order by 1 desc