john6003cosmoshub17
    Updated 2023-02-19
    select 'Cosmosis hub' , count(TX_ID) , sum(AMOUNT/1e18) , count(distinct receiver) , count(distinct sender) , trunc(block_timestamp, 'year') from cosmos.core.fact_transfers
    group by 6
    UNION
    select 'Osmosis' , count(TX_ID) , sum(AMOUNT/1e18) , count(distinct receiver) , count(distinct sender) , trunc(block_timestamp, 'year') from osmosis.core.fact_transfers
    group by 6
    UNION
    select 'Axelar' , count(TX_ID) , sum(AMOUNT/1e18) , count(distinct receiver) , count(distinct sender) , trunc(block_timestamp, 'year') from axelar.core.fact_transfers
    group by 6