binhachonDaily Transactions on ETH
    Updated 2022-07-21
    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