with Axelar as (with tab1 as (select block_timestamp::date as "Date", avg(fee)/pow(10,6) as "Average Fee per TX", count(distinct tx_id) as "TXs Count" from axelar.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and fee_denom='uaxl' and tx_succeeded='true' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Axelar' as "Chain" from tab1), arbitrum as (with tab1 as (select block_timestamp::date as "Date", avg(tx_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from arbitrum.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and Status='SUCCESS' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Arbitrum' as "Chain" from tab1), avalanche as (with tab1 as (select block_timestamp::date as "Date", avg(tx_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from avalanche.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and Status='SUCCESS' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Avalanche' as "Chain" from tab1), base as (with tab1 as (select block_timestamp::date as "Date", avg(tx_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from base.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and Status='SUCCESS' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Base' as "Chain" from tab1), blast as (with tab1 as (select block_timestamp::date as "Date", avg(tx_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from blast.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and Status='SUCCESS' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Blast' as "Chain" from tab1), bsc as (with tab1 as (select block_timestamp::date as "Date", avg(tx_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from bsc.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and Status='SUCCESS' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'BSC' as "Chain" from tab1), ethereum as (with tab1 as (select block_timestamp::date as "Date", avg(tx_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from ethereum.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and Status='SUCCESS' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Ethereum' as "Chain" from tab1), gnosis as (with tab1 as (select block_timestamp::date as "Date", avg(tx_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from gnosis.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and Status='SUCCESS' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Gnosis' as "Chain" from tab1), near as (with tab1 as (select block_timestamp::date as "Date", avg(transaction_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from near.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and tx_succeeded='TRUE' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Near Protocol' as "Chain" from tab1), optimism as (with tab1 as (select block_timestamp::date as "Date", avg(tx_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from optimism.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and Status='SUCCESS' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Optimism' as "Chain" from tab1), polygon as (with tab1 as (select block_timestamp::date as "Date", avg(tx_fee) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from polygon.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and Status='SUCCESS' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Polygon' as "Chain" from tab1), cosmos as (with tab1 as (select block_timestamp::date as "Date", avg(fee)/pow(10,6) as "Average Fee per TX", count(distinct tx_id) as "TXs Count" from cosmos.core.fact_transactions where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and fee_denom='uatom' and tx_succeeded='TRUE' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Cosmos' as "Chain" from tab1), flow as (with tab1 as (select BLOCK_TIMESTAMP_HOUR::date as "Date", avg(TOTAL_FEES_NATIVE) as "Average Fee per TX", sum(TRANSACTION_COUNT) as "TXs Count" from flow.stats.ez_core_metrics_hourly where BLOCK_TIMESTAMP_HOUR::date>='{{Start_Date}}' and BLOCK_TIMESTAMP_HOUR::date<='{{End_Date}}' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Flow' as "Chain" from tab1), aptos as (with tab1 as (select block_timestamp::date as "Date", avg((gas_used * gas_unit_price) / pow(10, 8)) as "Average Fee per TX", count(distinct tx_hash) as "TXs Count" from aptos.core.fact_transactions where success = 'true' and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}' group by 1 order by 1) select corr("TXs Count","Average Fee per TX") as cc, 'Aptos' as "Chain" from tab1) select * from axelar union all select * from arbitrum union all select * from avalanche union all select * from base union all select * from blast union all select * from bsc union all select * from ethereum union all select * from gnosis union all select * from near union all select * from optimism union all select * from polygon union all select * from cosmos union all select * from flow union all select * from aptos

Unveiling Insights into the Cosmoshub Ecosystem