ML61opintropt
    Updated 2023-03-06
    with axelar_table as (select count(*) as c , count(distinct tx_from) as u from axelar.core.fact_transactions where year(block_timestamp)=2023)
    , osmosis_table as (select count(*) as c , count(distinct tx_from) as u from osmosis.core.fact_transactions where year(block_timestamp)=2023)
    , cosmos_table as (select count(*) as c , count(distinct tx_from) as u from cosmos.core.fact_transactions where year(block_timestamp)=2023)

    select 'AXELAR CHAIN' , c , u from axelar_table
    UNION
    select 'OSMOSIS CHAIN' , c , u from osmosis_table
    UNION
    select 'COSMOS CHAIN' , c , u from cosmos_table
    Run a query to Download Data