from_address,

COUNT(DISTINCT tx_id) AS TotalSwaps,

COUNT(DISTINCT DATE_TRUNC('day', block_timestamp)) AS ActiveDays,

ROUND(COUNT(DISTINCT tx_id) * 1.0 / NULLIF(COUNT(DISTINCT DATE_TRUNC('day', block_timestamp)), 0), 2) AS AvgSwapsPerDay

FROM

thorchain.defi.fact_swaps

GROUP BY

from_address

ORDER BY

TotalSwaps DESC

LIMIT 10;