date_trunc(day,BLOCK_TIMESTAMP)::date as days,

address_name ,

count (tx_hash ) as transactions,

sum(transactions)over(partition by address_name order by days rows between unbounded preceding and current row) as transactions_growth

from

polygon.core.fact_transactions t, polygon.core.dim_labels l

where l.address = t.to_address

and BLOCK_TIMESTAMP::date between '2022-07-01' and '2022-07-12'

and label_type = 'dex'

group by 1,2 order by 1