date(block_timestamp) as date,

count(tx_id) as txs,

max(fee/pow(10,9)) as max_fee,

sum(fee/pow(10,9)) as fees,

avg(fee/pow(10,9)) as avg_fees

from solana.transactions

where year(block_timestamp) = 2022

group by 1

limit 100