select trunc(block_timestamp,'week') as date,
count(distinct(tx_id)) as frequency, sum(to_amount_usd) as volume, count(distinct from_address ) as swappers
from thorchain.defi.fact_swaps
where block_timestamp>='2024-01-01' and block_timestamp<trunc(current_date,'week')
group by 1
order by 1 desc