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