flipside

    Txn categories
    feyikemiTxn categories
    Updated 2025-05-16
    WITH tb1 AS (
    SELECT
    ORIGIN_FROM_ADDRESS,
    COUNT(DISTINCT TX_HASH) AS TRANSACTIONS
    FROM base.defi.ez_dex_swaps
    WHERE PLATFORM ILIKE 'aerodrome'
    GROUP BY 1
    )

    SELECT
    CASE
    WHEN TRANSACTIONS = 1 THEN '1 Transaction'
    WHEN TRANSACTIONS BETWEEN 2 AND 5 THEN '2 - 5 Transactions'
    WHEN TRANSACTIONS BETWEEN 6 AND 10 THEN '6 - 10 Transactions'
    WHEN TRANSACTIONS BETWEEN 11 AND 25 THEN '11 - 25 Transactions'
    WHEN TRANSACTIONS BETWEEN 26 AND 50 THEN '26 - 50 Transactions'
    ELSE '> 50 Transactions'
    END AS TXN_Category,
    COUNT(ORIGIN_FROM_ADDRESS) AS USERS_COUNT
    FROM tb1
    GROUP BY 1
    ORDER BY 2 DESC
    Last run: 13 days ago
    TXN_CATEGORY
    USERS_COUNT
    1
    		1 Transaction792324
    2
    		2 - 5 Transactions476748
    3
    		6 - 10 Transactions108654
    4
    		11 - 25 Transactions87567
    5
    		> 50 Transactions27555
    6
    		26 - 50 Transactions26535
    6
    177B
    6s