princefarzamSolana TPS fluctuation
    Updated 2022-02-23
    SELECT DISTINCT
    date_trunc('day',block_timestamp) AS DAY,
    COUNT(tx_id) AS TXNS_COUNTER,
    (TXNS_COUNTER/86400) - 120 AS TPS_fluctuation -- SECONDS IN ONE DAY: 1DAY*(24HR/1DAY)*(3600S/1HR)=86400S
    --TXNS_COUNTER /22~=120 as AVG_TPS
    FROM solana.events
    WHERE block_timestamp::DATE >= '2022-02-01'
    AND block_timestamp::DATE <= '2022-02-22'
    AND SUCCEEDED = TRUE
    AND INSTRUCTION:program <> 'vote' --Except for vote transactions
    GROUP BY DAY
    ORDER BY DAY ASC
    Run a query to Download Data