sum(LIQ_FEE_ASSET_USD) as protocol_fee,

count(distinct blockchain) as n_chains,

count(distinct pool_name) as n_pools,

count(DISTINCT tx_id) as swaps,

count(DISTINCT from_address) as swappers,

sum(case when from_amount_usd is not null then from_amount_usd else to_amount_usd end) as volume

from thorchain.defi.fact_swaps

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