txns as (

select

t.*,

((t.gas_price_paid/1e9) * (t.gas_used)) as gas_used_arbitrum

from arbitrum.core.fact_transactions t

select

block_timestamp::date as date,

status as type,

count(distinct from_address) as n_users,

count(distinct tx_hash) as tx_frequncy,

sum(gas_used_arbitrum) as gas_arbitrum,

sum(n_users) over (order by date asc rows between unbounded preceding and current row) as cum_n_users,

sum(gas_arbitrum) over (order by date asc rows between unbounded preceding and current row) as cum_gas_arbitrum,

sum(tx_frequncy) over (order by date asc rows between unbounded preceding and current row) as cum_tx_frequncy

from txns

group by date, type