Eman-RazStatus of Transactions
Updated 2022-12-11
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with flow as (select date_trunc('day',block_timestamp) as date, count(distinct tx_id) as "Tx Count", tx_succeeded as tx_status, 'flow' as blockchain,
case
when tx_status='FALSE' then 'Failed'
when tx_status='TRUE' then 'Successful'
end as transactions_status
from flow.core.fact_transactions
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1,3
order by 1),
algorand as (select date_trunc('day',block_timestamp) as date, count(distinct tx_group_id) as "Tx Count", inner_tx as tx_status,
'algorand' as blockchain, case
when tx_status='FALSE' then 'Failed'
when tx_status='TRUE' then 'Successful'
end as transactions_status
from algorand.core.fact_transaction
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1,3
order by 1),
avalanche as (select date_trunc('day',block_timestamp) as date, count(distinct tx_hash) as "Tx Count", status as tx_status, 'avalanche' as blockchain,
case
when tx_status='FAIL' then 'Failed'
when tx_status='SUCCESS' then 'Successful'
end as transactions_status
from avalanche.core.fact_transactions
where block_timestamp::date>='2022-01-01' and block_timestamp::date<>current_date
group by 1,3
order by 1),
bsc as (select date_trunc('day',block_timestamp) as date, count(distinct tx_hash) as "Tx Count", STATUS as tx_status, 'bsc' as blockchain,
case
when tx_status='FAIL' then 'Failed'
when tx_status='SUCCESS' then 'Successful'
end as transactions_status
from bsc.core.fact_transactions
Run a query to Download Data