Date_trunc('d',block_timestamp) as "Date",

sum(cast(fee as INTEGER)/pow(10,6)) as "Total Fees",

avg(cast(fee as INTEGER)/pow(10,6)) as "Average Fees"

from cosmos.core.fact_transactions

where fee_denom = 'uatom'

group by 1