date_trunc('day', block_timestamp) as days,

sum(fee/1e9) as tx_fees,

avg(fee/1e9) as avg_fees,

max(fee/1e9) as max_fees,

min(fee/1e9) as min_fees,

count(tx_id) as tx_per_day,

tx_fees/tx_per_day as fees_per_day

from flipside_prod_db.solana.fact_transactions

where days >= '2022-01-01'

and succeeded = 'TRUE'

group by days