date_trunc(hour,block_timestamp) as hours,

LABEL_TYPE,

COUNT(TX_HASH)/360 AS tps,

sum(tps)over(partition by LABEL_TYPE order by hours rows between unbounded preceding and current row) as tps_growth

FROM avalanche.core.fact_transactions t,avalanche.core.dim_labels L

where t.TO_ADDRESS = l.address

GROUP BY 1,2