john6003cosmoshub17
Updated 2023-02-19
9
1
2
3
4
5
6
7
8
›
⌄
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