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