date_trunc(day,BLOCK_TIMESTAMP) as days,

ADDRESS_NAME,

count(distinct TX_ID ) as number_of_usage ,

sum(number_of_usage) over (partition by ADDRESS_NAME order by days Rows between unbounded preceding and current row) as cum_pr_usage

from solana.core.fact_events e,solana.core.dim_labels l

where

BLOCK_TIMESTAMP >= '2022-02-01'

and e.PROGRAM_ID = l.address

and LABEL_SUBTYPE not ilike '%token%'

and LABEL_SUBTYPE not ilike '%general%'

group by 1,2