date_trunc('day', block_timestamp) as Date,

sum(fee) total,

sum(total) over (order by date) as cum_fee

from terra.core.fact_transactions

where date >= current_date - 30

group by 1

order by 1