flipside

    Active gamers on each of the popular Ronin games
    defi__joshActive gamers on each of the popular Ronin games
    Updated 9 hours ago
    with contracts as (

    select
    contract_address,
    project
    from
    $query('aa066775-bf6a-4da3-abf7-a91b1040861a')

    )

    select
    project as "project",
    count (DISTINCT from_address) "number of active gamers"
    from ronin.core.fact_transactions join contracts on TO_ADDRESS = contract_address
    group by 1
    Last run: about 9 hours agoAuto-refreshes every 12 hours
    project
    number of active gamers
    1
    		Wild Forest836825
    2
    		Fableborne110278
    3
    		Fishing Frenzy37701
    4
    		Pixel5181726
    5
    		Pixel HeroZ50342
    6
    		Axie Infinity519214
    7
    		Lumiterra513945
    8
    		Kaidro6186
    9
    		Kongz96644
    10
    		Apeiron242217
    11
    		Cambria3923
    12
    		Ragnarok: Monster World154065
    13
    		The Machines Arena385816
    13
    290B
    31s