where year(md)=2023

group by 2)

, osmosis_table as (select count(*) as c , trunc(md, 'DAY') as d from( select sender , min(block_timestamp::date) as md from osmosis.core.fact_transfers group by 1)

where year(md)=2023

group by 2)

, cosmos_table as (select count(*) as c , trunc(md, 'DAY') as d from( select sender , min(block_timestamp::date) as md from cosmos.core.fact_transfers group by 1)

where year(md)=2023

group by 2)

select 'AXELAR CHAIN' , c , d from axelar_table

UNION

select 'OSMOSIS CHAIN' , c , d from osmosis_table

UNION

select 'COSMOS CHAIN' , c , d from cosmos_table