date_trunc('day', block_timestamp) as Date,

count(distinct tx_id) as tx_count,

sum(fee) as fee_collected,

sum(fee)/tx_count as avg_fee

from terra.core.fact_transactions

where date >= current_date - 30

group by 1

order by 1