select receiver,

min(block_timestamp) as first_transfer_date

from osmosis.core.fact_transfers

where receiver like 'osmo%'

group by 1

)

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

count (distinct receiver) as weekly_first_transfers,

sum(weekly_first_transfers) over (order by fecha)

from first_transfer

group by 1

order by 1 desc