flipside

    bored-cyan
    feyikemibored-cyan
    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 >= CURRENT_DATE - INTERVAL '24 HOURS'
    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
    		here wallet523308
    2
    		hot near wallet21845
    3
    		harvest moon17865
    4
    		sweat2349
    5
    		wnear1768
    6
    		learn near club814
    7
    		gear536
    8
    		burrow531
    9
    		binance459
    10
    		ref finance292
    10
    191B
    5s