zakkisyedMonsterra Game insights - Active Users daily
    Updated 2022-10-12


    with monsterra_users as
    (
    select
    from_address, block_timestamp
    from bsc.core.fact_token_transfers
    where contract_address=lower('0x2290C6bD9560E6498dFDf10F9eCB17997CA131f2') -- MSTR
    or contract_address=lower('0xd4c73fd18f732BC6EE9FB193D109B2eed815Df80') --MAG
    )

    select count (distinct from_address) as usrs, date_trunc(day,block_timestamp) as dt,
    sum(usrs) over (order by dt) as cumulative
    from monsterra_users
    where block_timestamp >=current_date-6
    group by 2
    order by 2 desc


    Run a query to Download Data