damidezdistribution of volume
    Updated 2024-10-08
    WITH rango AS (
    SELECT
    from_address,
    SUM(COALESCE(from_amount_usd, to_amount_usd)) AS volume_usd
    FROM thorchain.defi.fact_swaps
    WHERE affiliate_address = 'rg'
    GROUP BY from_address
    )

    SELECT
    COUNT(DISTINCT from_address) AS Users,
    CASE
    WHEN volume_usd < 200 THEN '<200'
    WHEN volume_usd >= 200 AND volume_usd < 500 THEN '$200-$500'
    WHEN volume_usd >= 500 AND volume_usd < 1000 THEN '$500-$1000'
    WHEN volume_usd >= 1000 AND volume_usd < 2000 THEN '$1000-$2000'
    WHEN volume_usd >= 2000 AND volume_usd < 5000 THEN '$2000-$5000'
    WHEN volume_usd >= 5000 THEN '>$5000'
    END AS Amount_Category
    FROM rango
    GROUP BY Amount_Category
    ORDER BY Amount_Category;

    QueryRunArchived: QueryRun has been archived