block_timestamp::date as day,

count(distinct tx_id) as number_of_transactions,

count(distinct sender) as number_of_wallets,

sum(fee) as fee_amount,

sum(fee_amount) over (order by day) as cummulative_fee_amount

from flipside_prod_db.algorand.transactions

where day >= '2022-01-01'

group by day

order by fee_amount