block_timestamp::date as day,

PROJECT_NAME,

count(FROM_ADDRESS) as Application,

sum(Application) over (partition by PROJECT_NAME order by day) as grow_rate

from arbitrum.core.fact_transactions x join arbitrum.core.dim_labels y on x.TO_ADDRESS= y.address

where label_subtype != 'token_contract'

and LABEL_TYPE ='layer2'

and STATUS = 'SUCCESS'

group by 1,2