sunshine-juliaSuccessful transaction for Terra & ETH
Updated 2022-03-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with ETH_tab1 as (select date_trunc('month', block_timestamp) as month, count(distinct tx_id) as ETH_transaction
from ethereum.transactions group by 1),
ETH_tab2 as (select date_trunc('month', block_timestamp) as month, count(distinct tx_id) as ETH_successful_transaction
from ethereum.transactions where success ='TRUE' group by 1),
Terra_tab1 as (SELECT date_trunc('month', block_timestamp) as month, COUNT(DISTINCT tx_id) as Terra_successful_transaction
FROM terra.msgs
WHERE tx_status = 'SUCCEEDED'
GROUP BY 1),
Terra_tab2 as (SELECT date_trunc('month', block_timestamp) as month, COUNT(DISTINCT tx_id) as Terra_transactions
FROM terra.msgs
GROUP BY 1)
select ETH_tab1.month, ETH_successful_transaction*100/ETH_transaction as success_rate_ETH,
Terra_successful_transaction*100/Terra_transactions as success_rate_Terra
from ETH_tab1 join ETH_tab2 on ETH_tab1.month = ETH_tab2.month
join Terra_tab1 on Terra_tab1.month = ETH_tab1.month
join Terra_tab2 on Terra_tab2.month = ETH_tab1.month
where ETH_tab1.month >= '2021-06-01'
Run a query to Download Data