block_timestamp::date as day,

LABEL_TYPE,

count(FROM_ADDRESS) as no_holders,

sum(no_holders) over (partition by LABEL_TYPE order by day) as grow_rate,

sum(TX_FEE) as fee

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

where label_subtype != 'token_contract'

and LABEL_TYPE not in ('chadmin','operator')

and STATUS = 'SUCCESS'

group by 1,2