select

block_timestamp::date as date,

LABEL_TYPE,

LABEL_SUBTYPE,

count(distinct from_address) as Users_Count,

count(distinct tx_hash) as tx_cnt,

sum(TX_FEE) as fee_amt,

sum(tx_cnt) over (order by date) as cum_tx_cnt,

sum(fee_amt) over (order by date) as cum_fee_amt

from gnosis.core.fact_transactions a join gnosis.core.dim_labels b on a.to_address= b.address

where block_timestamp >= CURRENT_DATE - 40

group by 1,2,3