date_trunc('day',block_timestamp)as date,

sum (tx_fee) as TX_Fee,

avg (TX_Fee) as Average_Fee

from gnosis.core.fact_transactions

where status = 'SUCCESS'

and block_timestamp >= CURRENT_DATE - 30

group by date

order by date asc