damidezpair volume
    Updated 2024-10-08
    -- forked from payable-emerald @ https://flipsidecrypto.xyz/studio/queries/fd0bb8b7-579b-422c-b245-82df12a27f2f

    SELECT
    CONCAT(from_asset, ' --> ', to_asset) AS asset_pair,
    COUNT(DISTINCT tx_id) AS transaction_count,
    SUM(COALESCE(from_amount_usd, to_amount_usd)) AS volume_usd
    FROM thorchain.defi.fact_swaps
    WHERE affiliate_address = 'rg'
    GROUP BY asset_pair
    ORDER BY volume_usd DESC
    LIMIT 10;


    QueryRunArchived: QueryRun has been archived