adriaparcerisasBlast 2.2
Updated 2024-05-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
trunc(block_timestamp,'day') as hour,
count(*) as total_tx,
sum(case when status='SUCCESS' then 1 else 0 end) as succeeded_tx,
succeeded_tx/total_tx as succeess_rate,
sum(case when status='FAIL' then 1 else 0 end) as failed_tx
from blast.core.fact_transactions
where block_timestamp>'2024-02-29 10:00'
and block_timestamp<current_date
--origin_function_signature
group by 1 order by 1 desc
QueryRunArchived: QueryRun has been archived