with new_nfts as (
select
min(block_timestamp) as timestamp,
contract_address
from terra.core.fact_nft_mints
group by contract_address
),
weekly as (
select
date_trunc('week', timestamp) as week,
count(contract_address) as nfts
from new_nfts
group by week
)
select
week,
sum(nfts) over(order by week) as nfts
from weekly
order by week asc