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

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

count(distinct tx_from) as num_users from cosmos.core.fact_transactions

where date_trunc('day', block_timestamp) >= current_date - 7

group by 1