damidezTo Assest by volume
    Updated 2024-10-08
    select
    to_asset,
    count(distinct tx_id) as transaction,
    sum(coalesce(from_amount_usd, to_amount_usd)) as volume_usd
    from thorchain.defi.fact_swaps
    where affiliate_address = 'rg'
    GROUP BY to_asset
    order by volume_usd desc
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived