USDC Coin is a digital stablecoin pegged to the United States dollar. USD Coin is managed by a consortium called Centre, which was founded by Circle and includes members from the cryptocurrency exchange Coinbase and Bitcoin mining company Bitmain, an investor in Circle. 

AXL is the native utility token that powers the Axelar network, built using the Cosmos SDK. As an interoperability network, the AXL token is a chain-agnostic asset that has representations on multiple blockchains

$axlUSDC is the wrapped version of $USDC introduced by Axelar and deployed on Avalanche, Polygon, Fantom, and Moonbeam.

AXL.USD Transfer from Osmo per destination

from osmosis.core.fact_transfers

when receiver ilike '%kujira%' then 'Kujira'
when receiver ilike '%cosmos%' then 'Cosmos'
when receiver ilike '%Axelar%' then 'Axelar'
when receiver ilike '%Juno%' then 'Juno'
when receiver ilike '%evmos%' then 'Evmos'
when receiver ilike '%terra%' then 'Terra' end as destination

where TX_STATUS = 'SUCCEEDED'
and currency = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858'
and block_timestamp::date >=  CURRENT_DATE - 120

Transfers USD.AXL per destination

from axelar.core.fact_msg_attributes
from crosschain.core.fact_hourly_prices

when attribute_value like '%uaxl%' then 'AXL' 
when attribute_value like '%uusdc%' then 'USDC' 
when attribute_value like '%ibc/6F4968A73F90CF7DE6394BF937D6DF7C7D162D74D839C13F53B41157D315E05F%' then 'UST' 
when attribute_value like '%ibc/9117A26BA81E29FA4F78F57DC2BD90CD3D26848101BA880445F119B22A1E254E%' then 'ATOM' 
when attribute_value like '%weth-wei%' then 'ETH' 
when attribute_value like '%ibc/4627AD2524E3E0523047E35BB76CC90E37D9D57ACF14F0FCBCEB2480705F3CB8%' then 'LUNA' 	
when attribute_value like '%wbtc-satoshi%' then 'WBTC'  end as assets 

where MSG_TYPE = 'coin_spent'
and ATTRIBUTE_INDEX = 1

Add Liquidity Activities

from osmosis.core.fact_liquidity_provider_actions
from osmosis.core.dim_prices

when pool_id = 674 then 'DAI-OSMO'
when pool_id = 818 then 'USDT.grv-OSMO'
when pool_id = 1 then 'Atom-Osmo'
when pool_id = 560 then 'USDC-Osmo'
when pool_id = 633 then 'USDC.grv-Osmo'
when pool_id = 678 then 'AXL.USD-Osmo' end as pool_ids

where TX_STATUS = 'SUCCEEDED'
and action = 'pool_joined'
and currency = 'uosmo'
and day >= '2022-01-01'

Remove Liquidity

from osmosis.core.fact_liquidity_provider_actions
from osmosis.core.dim_prices

case when pool_id = 674 then 'DAI-OSMO'
when pool_id = 818 then 'USDT.grv-OSMO'
when pool_id = 1 then 'Atom-Osmo'
when pool_id = 560 then 'USDC-Osmo'
when pool_id = 633 then 'USDC.grv-Osmo'
when pool_id = 678 then 'AXL.USD-Osmo' end as pool_ids

where TX_STATUS = 'SUCCEEDED'
and action = 'pool_exited'
and currency = 'uosmo'
and day >= '2022-01-01'

where symbol = 'OSMO'

AXL.USD Transfer from Osmo per destination

Number of transactions

• The highest number of transactions was on August 17th. On this day, of all the transactions, 520 transactions were on Axelar, 30 transactions were on Kujira, and 4 transactions were on Juno.
• The highest number of transactions on Axelar was on August 17th, with 520.
• The highest number of transactions on Kujira was on August 9th, with 54.
• The highest number of transactions on Terra was on August 24th, with only 2.
• The highest number of transactions on Axelar was on August 17th and October 25th, with 4.
• In total, the highest number of transactions transfer AXL.USD from Osmo went to Axelar as a destination. The total number of transactions that go to Axelar is 23.6k.
• The least number of transactions go to Terra with only 5 transactions.

Number of users

• The highest number of users who transferred AXL.USD was on October 28th. Of all the users, 264 chose Axelar as a destination, 6 chose Kujira, and only 1 chose Juno.
• The highest number of users who chose Axelar was on October 28th, with 264.
• The highest number of users who chose Kujira was on August 9th, with 31.
• The number of users who chose Terra was only on July 13th, August 22nd and 23rd, and October 24th, with only 1 user
• The highest number of users who chose Juno was on August 17th, with 4.

USD volume

\

• The highest USD volume was on October 9th. On this day, the total USD volume of Axelar was 6.2 million and Kujira was 1034.
• The highest USD volume of Axlera was on October 9th at 6.2 million.
• The highest USD volume of Kujira was on October 25th at 30.5k.
• The highest USD volume of Terra was on August 22nd at only 213.
• The highest USD volume of Juno was on October 24th at 20k.

Transfers USD.AXL per destination

Number of transactions

• The highest number of transactions was on August 17th. On this day, of all the transactions, the number of transactions that went to Kujira was 398, to Polygon was 95, to Osmosis was 74, to Ethereum was 44, to Juno was 44 and to Avalanche was 28.
• In total, the highest number of transactions goes to Kujira. The total number of transactions on Kujira was 7135.
• The least number of transactions goes to Fetch with only 2 transactions.

USD volume

• The highest USD volume was on October 9th. On this day, the total USD volume of Ethereum was the most with almost 13 million and the least USD belonged to Cosmohub with 1304.
• The highest USD volume belongs to Ethereum with 188.4 million.
• The least USD volume belongs to Injective with almost 30 USD.

• The average USD volume was the most on October 9th. On this day, the average USD volume of Ethereum was the most with 202k and the average USD volume of Fantom was the least with 24.
• In total, the average USD volume of Ethereum was the most with 16.3k and the average USD volume of Aurora was almost 2 USD.

\

• The maximum USD volume was the most on October 9th.
• The maximum USD volume is the most on Ethereum with almost 6 million.
• The maximum USD volume is the least on Aurora with almost 2 USD.

Add Liquidity Activities

Number of transactions

• The highest number of transactions was on February 28th. On this day, of all the transactions, 38.2k transactions belonged to Atom-Osmo, almost 20k transactions belonged to USDC-Osmo and only 2 transactions belonged to USDC.grv-Osmo.
• In total, the highest number of transactions belongs to Atom-Osmo with 413.2k.
• The least number of transactions belongs to USDT.grv-Osmo with 314 transactions.

Number of user

USD volume

• The highest number of users was on February 28th.
• On this day, of all the users who had transactions, 33.5k users had transactions on Atom-Osmo, 16.6k users had transactions on USDC-Osmo and 2 users had transactions on USDC.grv-Osmo.
• The total number of users belongs to Atom-Osmo with 372.8k.
• The least number of users belongs to USDT.grv-Osmo with 219.

• The highest USD volume was on February 28th. On this day, the USD volume of all the added liquidity transactions was the most on Atom-Osmo with 27.2 million.
• In total, the USD volume of Atom-Osmo is the most with almost 260 million and the least USD volume belongs to USDT.grv-Osmo pool with 82.3k.

Remove Liquidity

\

• The highest number of users who removed liquidity was on May 23rd. On this day, 2652 users removed liquidity on the USDC-Osmo pool which was the most number of users on this day.

• In total, the highest number of users belongs to the Atom-Osmo pool with 54.4k, and the least number of users belongs to USDT.grv-Osmo with 49.

• The highest number of transactions in order to remove liquidity was on May 23rd. On this day, the number of transactions on USDC-Osmo pool was 2671 and the least number of transactions on USDC.grv-Osmo with 31.
• The highest number of remove liquidity transactions belongs to Atom-Osmo with 56.4k.
• The least number of remove liquidity trasactions belongs to USDT.grv-Osmo with 233.

Number of user

USD volume

Weekly Swaps to Selected token

Number of transaction

\

• The highest number of swaps to tokens was on October 24th. On this day, the most number of transactions transferred to USDC.axl with 62k.
• In total, the highest number of transactions transfers to USDC.axl with almost 939k.
• The least number of transactions transfers to UST.grv with 404.

Number of traders

\

• The highest number of traders was on October 24th. On this day, of all the users, 11.18k users transferred axlUSDC to USDC.AXL.
• In total the highest number of users transfer axlUSDC to USDC.axl. The total number f users in this category is almost 49k.
• The least number of users transfer axlUSDC to USDT.grv with 108 users.

USD volume

-- POOLS ID CREDITED TO CryptoIcicle

Number of transaction

• The highest USD volume of removed liquidity transactions was on March 21st. On this day, the most volume belongs to Atom-Osmo pool with 17 million USD.
• In total, the highest USD volume belongs to Atom-Osmo pool with 184.5 million USD.
• The least USD volume of removed liquidity belongs to USDT.grv-Osmo with almost 16k.

\

• The median USD volume was the most on September 30th.
• The median USD volume is the most on Ethereum with 1822.
• The median USD volume is the least on Aurora with almost 2 USD.