D3 TeamUser - User by Trading Volume - cuongng
    Updated 2025-01-17
    -- SELECT
    -- FROM_ADDRESS as Address,
    -- ROUND(SUM(RUNE_AMOUNT)) as "Trading Volume"
    -- FROM thorchain.defi.fact_swaps
    -- GROUP BY FROM_ADDRESS
    -- ORDER BY
    -- "Trading Volume (RUNE)" DESC
    -- LIMIT 50
    select
    from_address as "User",
    sum(from_amount_usd) as "Total Trading Volume"
    from thorchain.defi.fact_swaps
    group by 1
    order by 2 desc
    limit 25


    QueryRunArchived: QueryRun has been archived