saeedmzn[Game activities ] - overtime
    Updated 18 hours ago
    with contracts as (
    select contract_address , project
    from $query('6dcd9269-59bc-42e5-b708-7597187d4f31')
    )
    select
    date_trunc(week,block_timestamp)::date weekly ,
    iff(project is NULL , 'Other' , project) project_ ,
    count(tx_hash) num_txns ,
    sum (num_txns) over (partition by project_ order by weekly ) cum_txns ,
    count (DISTINCT FROM_ADDRESS) active_wallets ,
    num_txns / active_wallets txns_per_wallet ,
    sum (TX_FEE) paid_fees ,
    sum (paid_fees) over (partition by project_ order by weekly ) cum_paid_fees
    from ronin.core.fact_transactions left join contracts on to_address = contract_address
    group by 1, 2

    Last run: about 18 hours ago
    WEEKLY
    PROJECT_
    NUM_TXNS
    CUM_TXNS
    ACTIVE_WALLETS
    TXNS_PER_WALLET
    PAID_FEES
    CUM_PAID_FEES
    1
    2024-11-25 00:00:00.000Wild Forest114210485413572595284.4006971198.712652848680.880916165
    2
    2025-02-24 00:00:00.000Kaidro42952689624431059405.595845559.39040352613555.490767287
    3
    2025-03-10 00:00:00.000Ragnarok: Monster World5013341612182.2981650.443630906502.511924438
    4
    2024-11-25 00:00:00.000Kongz1481322362323662.766949104.391867259951.915399816
    5
    2025-01-13 00:00:00.000Lumiterra13382517803925155.32087537.03690841916446.291483305
    6
    2025-02-10 00:00:00.000Wild Forest2884154276915645.1134752.8696847415715.132385845
    7
    2025-01-06 00:00:00.000Other1843994323783792345307.8625086866.490464704106295.668587413
    8
    2025-01-06 00:00:00.000Apeiron41910596651481366453.067108306.8386522447075.860777755
    9
    2025-03-10 00:00:00.000Kaidro905093536159449.58686431.7688048214085.827596799
    10
    2024-11-25 00:00:00.000Fableborne7854768696255915713.27782577.68309208645.37675112
    11
    2024-12-23 00:00:00.000Kaidro70996951919471849383.9745811243.4105132917916.461089505
    12
    2024-12-23 00:00:00.000Pixel2114765365412753864605.4721452763.62458590348352.074671026
    13
    2024-12-30 00:00:00.000Pixel2106857386481323708765.6807592750.09682810551102.171499131
    14
    2025-01-06 00:00:00.000Ragnarok: Monster World9003100588061.1166250.84736936481.770906111
    15
    2025-02-10 00:00:00.000Kaidro46591381102921111419.363636606.96171117612445.592313919
    16
    2024-11-04 00:00:00.000Axie Infinity84393746755561231486.853031577.8854305268497.355580552
    17
    2024-11-04 00:00:00.000Pixel HeroZ41717214694116593.57809473.89296381406.662544766
    18
    2024-11-11 00:00:00.000Wild Forest103429262807171723716.0003831024.7133487656256.470332105
    19
    2024-11-25 00:00:00.000Pixel3134558269629426133755.1103454110.26648852635832.043649534
    20
    2024-12-23 00:00:00.000Wild Forest908329124190961311586.925456900.1967834612690.194467865
    ...
    278
    27KB
    8s