shahdadi-9ptm8Ysuccess rates of transactions
    Updated 2022-07-10
    with a as(select
    block_timestamp::date as date,count(tx_id) t1
    from solana.core.fact_transactions where date >= CURRENT_DATE - 365 and succeeded = 'TRUE'
    group by date
    ),b as(
    select
    block_timestamp::date as date,count(tx_id) t2
    from solana.core.fact_transactions where date >= CURRENT_DATE - 365 and succeeded = 'FALSE'
    group by date
    )
    select
    (t1/(t1+t2)) rate,a.date
    from a join b on a.date=b.date
    Run a query to Download Data