flipside

    Solana tps count over the time since the beginning of 2022[Excluding past 30 days]
    MufasaSolana tps count over the time since the beginning of 2022[Excluding past 30 days]
    Updated 2022-07-13
    SELECT
    block_timestamp::date as date,
    count(tx_id)/86400 as transaction_per_second
    FROM solana.core.fact_transactions
    WHERE
    date >= '2022-01-01' and date <= CURRENT_DATE - 30
    and succeeded = 'TRUE'
    GROUP BY date
    Run a query to Download Data