binhachonDaily Transactions on ETH
Updated 2022-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tab1 as (select date_trunc('day',block_timestamp) as date,count(distinct tx_hash)/1440 as transactions
from ethereum.core.fact_transactions
where block_timestamp>=current_date-30
group by date
order by date asc),
tab2 as (select date_trunc('day',block_timestamp) as date, count(distinct tx_hash)/1440 as transactions_fail
from ethereum.core.fact_transactions
where block_timestamp>= current_date-30
and STATUS = 'FAIL'
group by date
order by date asc)
SELECT tab1.date,tab1.TRANSACTIONS,tab2.TRANSACTIONS_fail,(tab2.TRANSACTIONS_fail*100)/tab1.TRANSACTIONS AS percent_fail
FROM tab1
LEFT JOIN tab2 ON tab1.date = tab2.date
ORDER BY date;
Run a query to Download Data