date(block_timestamp) as date,

LABEL_TYPE ,

count(tx_hash) tx_count,

sum(tx_count)over( partition by LABEL_TYPE order by date rows between unbounded preceding and current row ) as cum_tx_count

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

where t.to_address = l.address

and status = 'FAIL'

group by 1 , 2

order by 1