COUNT(DISTINCT tx_id) AS transactions,

COUNT(DISTINCT from_address) AS users,

SUM(from_amount_usd) AS usd_volume,

AVG(from_amount_usd) AS avg_usd_volume,

MEDIAN(from_amount_usd) AS median_usd_volume,

MAX(from_amount_usd) AS max_usd_volume

FROM thorchain.defi.fact_swaps

WHERE affiliate_address = 'ELD'