flipside

    Popular Contracts By Number of Users
    Eman-RazPopular Contracts By Number of Users
    Updated 2025-03-22
    with tab1 as (select origin_from_address, contract_address
    from ronin.core.fact_event_logs
    where tx_succeeded='TRUE'),

    tab2 as (select distinct address, name
    from ronin.core.dim_contracts)

    select contract_address, name, count(distinct origin_from_address) as "Number of Users"
    from tab1 left join tab2 on tab1.contract_address = tab2.address
    where name is not null
    group by 1, 2
    order by 3 desc
    limit 10
    Last run: about 1 month ago
    CONTRACT_ADDRESS
    NAME
    Number of Users
    1
    		0x1136dac182ab639632a38540c6f33c01e02e51a6Wild Forest Signal Fire755305
    2
    		0x7eae20d11ef8c779433eb24503def900b9d28ad7PIXEL556783
    3
    		0xcc451977a4be9adee892f7e610fe3e3b3927b5a1Lumiterra Game Item404678
    4
    		0x97a9107c1793bc407d6f527b77e7fff4d812beceAxie Infinity Shard392735
    5
    		0xc39a2430b0b6f1edad1681672b47c857c1be0998Soul371002
    6
    		0x32950db2a7164ae833121501c797d79e7b79d74cAxie294118
    7
    		0xe514d9deb7966c8be0ca922de8a064264ea6bcd4Wrapped Ronin218039
    8
    		0x0b7007c13325c48911f73a2dad5fa5dcbf808adcUSD Coin140243
    9
    		0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef5Ronin Wrapped Ether137772
    10
    		0xa8754b9fa15fc18bb59458815510e40a12cd2014Smooth Love Potion133644
    10
    703B
    4s