anniecryptoTransactions per minute_NEAR
Updated 2022-07-20
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select date_trunc('day', minute) as day, status, avg(number_transaction) as avg_transaction_per_minute
from (select date_trunc('minute', block_timestamp) as minute,
case when status_value:Failure is not null then 'failed_transaction'
when status_value:Failure is null then 'successful_transaction' end as status,
count(distinct txn_hash) as number_transaction
from flipside_prod_db.mdao_near.receipts
where date(block_timestamp) >= '2022-01-01' and date(block_timestamp) < current_date
group by 1,2)
group by 1,2
Run a query to Download Data