select tx_from as address,

min(block_timestamp) as primera_fecha

from osmosis.core.fact_transactions

where tx_status = 'SUCCEEDED'

group by 1

select date_trunc('week', primera_fecha) as fecha,

count (distinct address) as new_addresses,

sum (new_addresses) over (order by fecha) as cum_new_addresses

from first_txs

where fecha < '2023-01-02'

group by 1

order by 1 desc