flipside

    SOLANA TPS
    lagandispenserSOLANA TPS
    Updated 2022-07-13
    with last_month as (select (count(tx_id)/(24*60*60*30)) as TPS from solana.core.fact_transactions where block_timestamp::date>=CURRENT_DATE - 30 and SUCCEEDED=true),
    last_6_month as (select (count(tx_id)/(24*60*60*180)) as TPS from solana.core.fact_transactions
    where block_timestamp::date>=CURRENT_DATE - 210 and block_timestamp ::date < CURRENT_DATE - 30 and SUCCEEDED=true)
    select 'last month' as type , TPS from last_month
    UNION
    select 'last 6 months' as type , TPS from last_6_month
    Run a query to Download Data