hessTotal Average
Updated 2022-12-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with final as ( select date(block_timestamp) as date, count(DISTINCT(tx_hash)) as total, count(DISTINCT(TX_SIGNER)) as total_user,
total/24 as tx_per_hour , total/1440 as tx_per_minute, total/86400 as tx_per_second,
total_user/24 as user_per_hour , total_user/1440 as user_per_minute, total_user/86400 as user_per_second
from near.core.fact_transactions
where block_timestamp::date >= CURRENT_DATE - {{N_Days}}
and tx_status = 'Success'
group by 1)
select avg(tx_per_hour) as avg_hour, avg(tx_per_minute) as avg_minute, avg(tx_per_second) as avg_second,
avg(user_per_hour) as avg_user_per_hour, avg(user_per_minute) as avg_user_per_minute, avg(user_per_second) as avg_user_per_second
from final
Run a query to Download Data