date_trunc('day', block_timestamp) as date,

count(distinct tx_hash) as tx_count,

sum(tx_fee) as tx_fee,

avg(tx_fee) as avg_tx_fee

from gnosis.core.fact_transactions

WHERE block_timestamp >= current_date-30

group by date