date_trunc('day', block_timestamp) AS date,

count(DISTINCT from_address) as total_addresses,

sum(total_addresses) over (order by date) as cum_add,

count(DISTINCT TX_HASH) as transactions ,

sum(transactions) over (order by date) as cum_tX,

STATUS,

sum(TX_FEE) as total_fee ,

avg(TX_FEE) as avrage_fee

from arbitrum.core.fact_transactions

WHERE block_timestamp >= '2022-01-01'

group by 1,STATUS

order by 1