flipside

    Near Users Count by Projects
    feyikemiNear Users Count by Projects
    Updated 2025-03-31
    SELECT
    PROJECT_NAME,
    COUNT(DISTINCT TX_SIGNER) AS Users
    FROM near.core.fact_transactions a
    JOIN near.core.dim_address_labels b
    ON a.tx_receiver = b.address
    WHERE BLOCK_TIMESTAMP::DATE >= '2024-01-01'
    AND TX_SUCCEEDED = 'true'
    AND Project_name NOT IN ('USDt', 'usdc')
    GROUP BY 1
    ORDER BY 2 DESC
    Limit 10
    Last run: about 2 months ago
    PROJECT_NAME
    USERS
    1
    		kaikai46077973
    2
    		playember7691279
    3
    		sweat4160238
    4
    		here wallet1983886
    5
    		uwon1258616
    6
    		wnear1113054
    7
    		hot near wallet662349
    8
    		binance286860
    9
    		aurora278134
    10
    		lnr242242
    10
    199B
    128s