affiliate_address,

SUM(from_amount_usd) AS TotalVolumeUSD,

COUNT(DISTINCT tx_id) AS TotalTransactions,

COUNT(DISTINCT from_address) AS ActiveSwappers

thorchain.defi.fact_swaps

affiliate_address IS NOT NULL

GROUP BY

affiliate_address

ORDER BY

TotalVolumeUSD DESC

5;