trunc(block_timestamp,'day') as date,

sum(fee/1000000000) as fees,

sum(fees) over (order by date) as cum_fees,

avg(fee/1000000000) as fees_per_transaction

from solana.transactions where block_timestamp>='2022-01-01'

group by 1

order by 1 asc