par_rnSwell 04
    Updated 2025-02-01
    WITH user_transaction_groups AS (
    SELECT
    FROM_ADDRESS AS user_address,
    COUNT(DISTINCT TX_HASH) AS total_transactions,
    CASE
    WHEN COUNT(DISTINCT TX_HASH) < 100 THEN '<100'
    WHEN COUNT(DISTINCT TX_HASH) BETWEEN 100 AND 500 THEN '100-500'
    WHEN COUNT(DISTINCT TX_HASH) BETWEEN 500 AND 1000 THEN '500-1K'
    WHEN COUNT(DISTINCT TX_HASH) BETWEEN 1000 AND 5000 THEN '1K-5K'
    WHEN COUNT(DISTINCT TX_HASH) BETWEEN 5000 AND 10000 THEN '5K-10K'
    WHEN COUNT(DISTINCT TX_HASH) BETWEEN 10000 AND 50000 THEN '10K-50K'
    WHEN COUNT(DISTINCT TX_HASH) BETWEEN 50000 AND 100000 THEN '50K-100K'
    WHEN COUNT(DISTINCT TX_HASH) BETWEEN 100000 AND 500000 THEN '100K-500K'
    ELSE '>500K'
    END AS transaction_group
    FROM swell.core.fact_transactions
    GROUP BY FROM_ADDRESS
    )
    SELECT
    transaction_group,
    COUNT(user_address) AS total_users,
    SUM(total_transactions) AS total_transactions
    FROM user_transaction_groups
    GROUP BY transaction_group
    ORDER BY total_transactions DESC

    Last run: 24 days ago
    TRANSACTION_GROUP
    TOTAL_USERS
    TOTAL_TRANSACTIONS
    1
    >500K12855994
    2
    100K-500K1116610
    3
    <100998536342
    4
    1K-5K1131051
    5
    5K-10K323535
    6
    10K-50K111648
    7
    100-5004511185
    8
    500-1K95975
    8
    161B
    1s