SELECT

Date_trunc('day', block_timestamp) AS Date,

COUNT(DISTINCT tx_hash) AS tx_count,

COUNT(DISTINCT tx_hash) / 86400 AS TPS

FROM near.core.fact_transactions

WHERE block_timestamp::date >= '2024-01-01'

AND TX_SUCCEEDED = 'True'

GROUP BY 1

),

NEAR_AVG_TPS AS(

SELECT

AVG(TPS) AS AVG_TPS

FROM NEAR

),

FLOW AS (

SELECT

Date_trunc('day', block_timestamp) AS Date,

COUNT(DISTINCT tx_id) AS tx_count,

COUNT(DISTINCT tx_id) / 86400 AS TPS

FROM flow.core.fact_transactions

WHERE block_timestamp::date >= '2024-01-01'

AND TX_SUCCEEDED = TRUE

GROUP BY 1

),

Flow_AVG_TPS AS(

SELECT

AVG(TPS) AS AVG_TPS

FROM Flow

),

ETHEREUM AS (

SELECT