date_trunc('day', block_timestamp) as date,

sum(tx_fee) as total_tx_fee,

count(*) as no_of_txs,

avg(tx_fee) as avg_tx_fee

from polygon.core.fact_transactions

group by 1

order by 1 desc