(select datetime,

token_cnt,

(token_cnt/lag(token_cnt,1) over (order by datetime)-1)*100 as perc_change_contract

from

(select date_trunc('week',CREATED_BLOCK_TIMESTAMP) as datetime,

count(distinct ADDRESS) as token_cnt

from ink.core.dim_contracts

group by 1))

select *

from a

where datetime = (select max(datetime) from a) - interval '7 day'