count(distinct(from_address)) as number_of_traders,

count(distinct(tx_id)) as number_of_swaps,

sum(case when from_amount_usd is null then to_amount_usd else from_amount_usd end) as total_amount_usd,

avg(case when from_amount_usd is null then to_amount_usd else from_amount_usd end) as avg_amount_usd,

total_amount_usd/number_of_swaps as avg_vol_per_swap,

total_amount_usd/number_of_traders as avg_vol_per_swappper

from thorchain.defi.fact_swaps