with transactions as ( select date(block_timestamp) as date, count(DISTINCT(tx_id)) as total,
sum(total) over (order by date asc) as cum_tx
from terra.core.fact_transactions
where block_timestamp >= CURRENT_DATE - 60 and TX_SUCCEEDED = 'TRUE'
group by 1
)
select
date , total , total/24 as per_hour , total/1440 as per_minute, total/86400 as per_second, cum_tx
from transactions