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