select blockchain, max(transaction_count/ 3600) as max_TPS

from crosschain.stats.ez_core_metrics_hourly

where blockchain in (

'polygon',

'bsc',

'base',

'avalanche',

'arbitrum',

'optimism',

'ethereum'

)

--and block_timestamp_hour > '2025-02-18'

group by 1),

monad as (

select (select'Monad') as blockchain,

(select "overall"

from $query('de434495-e102-4625-aea2-23f67c37b837')

where "metric" = 'Max TPS'

qualify row_number()over (order by hr desc) =1) as max_tps

),

combined_chains as (

select *

from monad

union all

select * from cross_chain

),

paid_ratios AS (

SELECT

'arbitrum' as blockchain,

ROUND(COUNT(CASE WHEN tx_fee > 0 THEN 1 END) / COUNT(*), 3) as paid_ratio

FROM arbitrum.core.fact_transactions

WHERE block_timestamp >= '2025-02-19'

UNION ALL

SELECT