with transactions as ( select 'Success' as type , date(block_timestamp) as date, count(DISTINCT(TX_HASH)) as total,
sum(total) over (order by date asc) as cum_tx
from near.core.fact_receipts
where regexp_substr(status_value, 'Success') is not null and BLOCK_TIMESTAMP::date >= '2022-01-01' and receiver_id = 'v2.ref-finance.near'
group by 1,2
)
select
date , total , total/24 as per_hour , total/1440 as per_minute, total/86400 as per_second, cum_tx
from transactions