SalehNetwork Performance Dashboard-daily
    Updated 2022-07-09
    with lst_last_month as (
    select
    date_trunc(day,block_timestamp)::date as date
    ,count(tx_id) as tx_count
    ,count(DISTINCT signers[0]) as wallets
    ,tx_count/86400 as TPS
    from solana.core.fact_transactions
    where block_timestamp::date>=CURRENT_DATE-30
    and SUCCEEDED=true
    group by 1
    order by 1
    )
    , lst_before_month as (
    select
    date_trunc(day,block_timestamp)::date as date
    ,count(tx_id) as tx_count
    ,count(DISTINCT signers[0]) as wallets
    ,tx_count/86400 as TPS
    from solana.core.fact_transactions
    where block_timestamp::date>='2022-04-01' and block_timestamp::date<CURRENT_DATE-30
    and SUCCEEDED=true
    group by 1
    order by 1
    )
    select 'During_the_year' as type,* from lst_before_month
    union all
    select 'Last_month' as type,* from lst_last_month
    Run a query to Download Data