monthname(BLOCK_TIMESTAMP) AS Month,

count(TX_HASH) AS txns,

count(distinct FROM_ADDRESS) AS act_users,

sum(TX_FEE) AS tot_fee,

tot_fee/txns as fee_per_tx,

tot_fee/count(distinct BLOCK_TIMESTAMP::date ) as fee_per_day,

txns/act_users as txs_per_user,

txns/count(distinct BLOCK_TIMESTAMP::date ) as txs_per_day,

act_users/count(distinct BLOCK_TIMESTAMP::date ) as wallets_per_day

from optimism.core.fact_transactions where STATUS='SUCCESS' and BLOCK_TIMESTAMP::date between '2022-12-01' and CURRENT_DATE-1

group by 1