date_trunc('week', block_timestamp) as date,

sum(coalesce(from_amount_usd, to_amount_usd)) as volume,

count(DISTINCT tx_id) as n_swaps,

count(DISTINCT from_address) as n_swappers ,

sum(liq_fee_rune_usd) as liquidity_fee

from thorchain.defi.fact_swaps

where tx_id not in (select tx_id from thorchain.defi.fact_refund_events)

and date >= '{{start_date}}'

group by 1

order by date desc