avg(FEE) as avg_fee,

sum(fee) as total_fee ,

count(DISTINCT tx_id) as num_tx

-- count(tx_id)/(7*24*60*60) as avg_tps

-- date_trunc('week', BLOCK_TIMESTAMP) as week

from terra.core.fact_transactions

-- where TX_SUCCEEDED =TRUE

-- GROUP by week