-- ETH with eth_total_avg_for_minute as ( select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from ethereum.core.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' ) , eth_success_per_min as (select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from ethereum.core.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' and tx_succeeded = True ) , base_eth as ( select * from ( select tx_per_min, 'Total' as type from (select * from eth_total_avg_for_minute) UNION select tx_per_min, 'Success' as type from (select * from eth_success_per_min) ) order by type ) , final_eth as ( select 'Ethereum' as chain, round(sum(case when type = 'Total' then tx_per_min end), 2) as tps, round(sum(case when type = 'Success' then tx_per_min end), 2) as stps, stps/tps*100 as percentage from base_eth ) -- POLYGON , poly_total_avg_for_minute as ( select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from polygon.core.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' ) , poly_success_per_min as (select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from polygon.core.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' and tx_succeeded = True ) , base_poly as ( select * from ( select tx_per_min, 'Total' as type from (select * from poly_total_avg_for_minute) UNION select tx_per_min, 'Success' as type from (select * from poly_success_per_min) ) order by type ) , final_poly as ( select 'Polygon' as chain, sum(case when type = 'Total' then tx_per_min end) as tps, sum(case when type = 'Success' then tx_per_min end) as stps, stps/tps*100 as percentage from base_poly ) -- AVAX , ava_total_avg_for_minute as ( select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from avalanche.core.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' ) , ava_success_per_min as (select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from avalanche.core.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' and tx_succeeded = True ) , base_ava as ( select * from ( select tx_per_min, 'Total' as type from (select * from ava_total_avg_for_minute) UNION select tx_per_min, 'Success' as type from (select * from ava_success_per_min) ) order by type ) , final_ava as ( select 'Avalanche' as chain, sum(case when type = 'Total' then tx_per_min end) as tps, sum(case when type = 'Success' then tx_per_min end) as stps, stps/tps*100 as percentage from base_ava ) --- BSC , bsc_total_avg_for_minute as ( select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from bsc.core.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' ) , bsc_success_per_min as (select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from bsc.core.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' and tx_succeeded = True ) , base_bsc as ( select * from ( select tx_per_min, 'Total' as type from (select * from bsc_total_avg_for_minute) UNION select tx_per_min, 'Success' as type from (select * from bsc_success_per_min) ) order by type ) , final_bsc as ( select 'BSC' as chain, round(sum(case when type = 'Total' then tx_per_min end), 2) as tps, round(sum(case when type = 'Success' then tx_per_min end), 2) as stps, stps/tps*100 as percentage from base_bsc ) --- Monad , monad_total_avg_for_minute as ( select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from monad.testnet.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' ) , monad_success_per_min as (select count(*)/count(DISTINCT block_timestamp::date)/86400 as tx_per_min from monad.testnet.fact_transactions where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2025-02-19' and tx_succeeded = True ) , base_monad as ( select * from ( select tx_per_min, 'Total' as type from (select * from monad_total_avg_for_minute) UNION select tx_per_min, 'Success' as type from (select * from monad_success_per_min) ) order by type ) , final_monad as ( select 'Monad - Testnet' as chain, round(sum(case when type = 'Total' then tx_per_min end), 2) as tps, round(sum(case when type = 'Success' then tx_per_min end), 2) as stps, stps/tps*100 as percentage from base_monad ) , final as ( select * from ( select * from final_eth UNION select * from final_poly UNION select * from final_ava UNION select * from final_bsc UNION select * from final_monad ) order by chain ) select chain, round(tps,2) as tps, round(stps,2) as stps, round(percentage,2) as percentage, round(avg_block_time,2) as avg_block_time from final join $query('38b6c7b1-8e6d-45bc-b199-a4f93e1c81e2') using (chain) order by avg_block_time desc

sol-phenna