flipside

    Txns Distribution
    feyikemiTxns Distribution
    Updated 2025-01-03
    WITH user_transaction_counts AS (
    SELECT
    INITCAP(LABEL_TYPE) AS SECTOR,
    FROM_ADDRESS AS user_address,
    COUNT(DISTINCT TX_HASH) AS tx_count
    FROM base.core.fact_transactions a
    LEFT JOIN base.core.dim_labels b ON a.to_address = b.address
    WHERE LABEL_TYPE NOT IN ('chadmin')
    AND b.project_name IS NOT NULL
    AND a.status = 'SUCCESS'
    GROUP BY LABEL_TYPE, FROM_ADDRESS
    ),
    categorized_users AS (
    SELECT
    SECTOR,
    CASE
    WHEN tx_count = 1 THEN '1 Transaction (Non-Repeating)'
    WHEN tx_count BETWEEN 2 AND 5 THEN '2 - 5 Transactions'
    WHEN tx_count BETWEEN 6 AND 10 THEN '6 - 10 Transactions'
    WHEN tx_count BETWEEN 11 AND 25 THEN '11 - 25 Transactions'
    WHEN tx_count BETWEEN 26 AND 50 THEN '26 - 50 Transactions'
    ELSE 'More Than 50 Transactions'
    END AS transaction_category,
    COUNT(user_address) AS user_count
    FROM user_transaction_counts
    GROUP BY SECTOR, transaction_category
    )

    SELECT
    SECTOR AS "Sector",
    transaction_category AS "Transaction Category",
    user_count AS "Number of Users"
    FROM categorized_users
    ORDER BY SECTOR, user_count DESC
    Last run: 2 months ago
    Sector
    Transaction Category
    Number of Users
    1
    		Bridge1 Transaction (Non-Repeating)262519
    2
    		Bridge2 - 5 Transactions175544
    3
    		Bridge6 - 10 Transactions26488
    4
    		Bridge11 - 25 Transactions9656
    5
    		Bridge26 - 50 Transactions1380
    6
    		BridgeMore Than 50 Transactions813
    7
    		Cex1 Transaction (Non-Repeating)683040
    8
    		Cex2 - 5 Transactions325728
    9
    		Cex6 - 10 Transactions23163
    10
    		Cex11 - 25 Transactions8896
    11
    		Cex26 - 50 Transactions1795
    12
    		CexMore Than 50 Transactions781
    13
    		Dapp1 Transaction (Non-Repeating)174426
    14
    		Dapp2 - 5 Transactions132697
    15
    		Dapp6 - 10 Transactions22286
    16
    		Dapp11 - 25 Transactions12286
    17
    		Dapp26 - 50 Transactions3636
    18
    		DappMore Than 50 Transactions3566
    19
    		Defi1 Transaction (Non-Repeating)685031
    20
    		Defi2 - 5 Transactions464602
    54
    2KB
    176s