trunc(block_timestamp,'day') as date,

--status,

count(distinct from_address) as daily_users,

sum(daily_users) over (order by date) as cum_users,

count(distinct tx_hash) as daily_transactions,

sum(daily_transactions) over (order by date) as cum_transactions,

sum(tx_fee) as daily_fees,

sum(daily_fees) over (order by date) as cum_fees,

avg(tx_fee) as avg_fee_per_tx

from optimism.core.fact_transactions where block_timestamp >=CURRENT_DATE-INTERVAL '1 WEEK'

group by 1

order by 1 asc