flipside

    disabled-amaranth
    permarydisabled-amaranth
    Updated 2025-04-02
    SELECT
    dl.label AS game_name,
    COUNT(*) AS total_transactions,
    count (distinct from_address) as Users
    FROM ronin.core.fact_transactions t
    LEFT JOIN ronin.core.dim_labels dl
    ON t.to_address = dl.address
    WHERE t.block_timestamp >= '2025-01-01'
    AND t.block_timestamp < '2025-04-01'
    AND dl.label_type = 'games' -- Filtering for game contracts
    GROUP BY 1
    ORDER BY 3 DESC
    LIMIT 10;

    Last run: about 2 months ago
    GAME_NAME
    TOTAL_TRANSACTIONS
    USERS
    1
    		pixels224180691054021
    2
    		wild forest2775004397174
    3
    		axie16438910387002
    4
    		the machines arena9017058172457
    5
    		apeiron4255882169140
    6
    		tanto kit57542485540
    7
    		axie infinity157600060385
    8
    		kalodium39643292466
    9
    		reward multiplier67711566
    10
    		forkast22281053
    10
    289B
    3s