SUM(CASE WHEN STATUS = 'SUCCESS' THEN 1 ELSE 0 END) AS total_transactions,

DATEDIFF(second, MIN(BLOCK_TIMESTAMP), MAX(BLOCK_TIMESTAMP)) AS total_seconds,

CAST(SUM(CASE WHEN STATUS = 'SUCCESS' THEN 1 ELSE 0 END) AS FLOAT) / NULLIF(DATEDIFF(second, MIN(BLOCK_TIMESTAMP), MAX(BLOCK_TIMESTAMP)), 0) AS tps

polygon.core.fact_transactions;

BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP);