block_timestamp::date as date,

LABEL,

count(distinct tx_id) as tx_cnt,

count(distinct instruction:accounts[0]) as uniq_users,

ROW_NUMBER() OVER (PARTITION BY uniq_users ORDER BY date) as rank,

sum(tx_cnt) over (partition by label order by date) as cum_tx_cnt

from solana.core.fact_events inner join solana.core.dim_labels

on program_id = address

where SUCCEEDED='TRUE'

and label_type in('dapp','defi')

and block_timestamp::date >='2022-10-08'

and block_timestamp::date <= '2022-11-07'

group by 1 , 2

QUALIFY rank <= 10