select block_timestamp::Date as date, count(*) as Transactions,
sum(Transactions) over (order by date asc rows between unbounded preceding and current row) as Cumulative_transactions
from algorand.transactions
where
date(block_timestamp) between current_date()-366 and current_date()-1
group by date