-- SELECT
-- FROM_ADDRESS as Address,
-- COUNT(FACT_TRANSFERS_ID) as "Total Trades"
-- FROM thorchain.core.fact_transfers
-- GROUP BY FROM_ADDRESS
-- HAVING COUNT(FACT_TRANSFERS_ID) < 100000
-- ORDER BY
-- "Total Trades" DESC
-- LIMIT 50
select
from_address as "User",
count(fact_swaps_id) as "Total Trades"
from thorchain.defi.fact_swaps
group by 1
order by 2 desc
limit 60