ML61opintropt
Updated 2023-03-06
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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