select
date_trunc('day', block_timestamp) as block_day,
count(distinct TX_HASH) as tx_count,
sum(tx_count) over (partition by PROJECT_NAME order by block_day asc) as cum_tx,
ADDRESS_NAME,
PROJECT_NAME,
LABEL_TYPE,
avg(TX_FEE) as avg_fee,
sum(TX_FEE) as sum_fee
from arbitrum.core.fact_transactions a
join arbitrum.core.dim_labels b
on a.TO_ADDRESS=b.ADDRESS
where block_timestamp >= '2022-07-01' and block_timestamp < current_date -1
group by block_day,ADDRESS_NAME,PROJECT_NAME,LABEL_TYPE
having tx_count > 100