flipside

    Active Users by No. of Bets
    NuveveCryptoArchivedActive Users by No. of Bets
    Updated 2025-03-06
    with tx as (
    select
    decoded_log:takerOrderMaker as user,
    count(tx_hash) as bets
    from polygon.core.ez_decoded_event_logs
    where contract_address = '0x4bfb41d5b3570defd03c39a9a4d8de6bd8b8982e'
    and event_name = 'OrdersMatched'
    group by user
    )

    select
    concat(bets, ' bets') as bets,
    count(user) as users
    from tx
    group by bets
    order by users desc
    limit 7

    Last run: about 1 month ago
    BETS
    USERS
    1
    		1 bets105667
    2
    		2 bets78099
    3
    		3 bets45426
    4
    		4 bets42131
    5
    		5 bets27936
    6
    		6 bets27829
    7
    		7 bets20485
    7
    121B
    207s