WITH TokenTransfersTotal AS (
SELECT
COUNT(*) AS TotalTokenTransfers
FROM ethereum.core.fact_token_transfers
WHERE BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE)
),
TransactionsTotal AS (
SELECT
COUNT(*) AS TotalTransactions
FROM ethereum.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE)
)
SELECT
tt.TotalTokenTransfers / (30 * 24 * 60 * 60) AS TokenTransfersPerSecond,
td.TotalTransactions / (30 * 24 * 60 * 60) AS TransactionsPerSecond
FROM TokenTransfersTotal tt, TransactionsTotal td;