-- forked from jennifertran / Average Transactions Last Month on Solana @ https://flipsidecrypto.xyz/jennifertran/q/2023-04-04-01-50-pm-andpZ8
with
lastMonthTransactions as (
select
*
from
cosmos.core.fact_transactions
where
block_timestamp BETWEEN DATEADD('day', -30, CURRENT_DATE()) AND DATEADD('day', -1, CURRENT_DATE())
and tx_succeeded = true
)
SELECT
COUNT(*) / DATEDIFF('second', MIN(block_timestamp), MAX(block_timestamp)) AS avg_transaction_per_second
FROM
lastMonthTransactions