What is Squid?

Introduced in 2021, the Axelar network is a blockchain of connected blockchains that allows for cross-chain communications. Squid provides cross-chain liquidity that connects decentralized exchanges (DEX) with more users in a more user-friendly way that doesn't involve the security risks of cross-chain bridges.

What is Satellite?

Axelar is a permisionless network and gateway that enables you to build secure cross-chain applications. Satellite is a web app built on top of the Axelar network. Use it to transfer assets from one chain to another.

In this dashboard, we are going to check Axelar bridges (Squid and Satellite) since the start of Airdrop Arbitrom on March 16th and the time of airdrop distribution on March 23th, and analyze the behavior of users for the volume of Arbitrom inflow and outflow to these bridges.

For this purpose, we first find the users who have claimed airdrop and then analyze their behavior in Excell bridges.

Tables used in this dashboard:

• arbitrum.core.fact_transactions
• axelar.core.ez_satellite
• axelar.core.ez_squid
• ethereum.core.fact_hourly_token_prices
• osmosis.core.ez_prices

To get the volume, we needed to get the price of the exchanged tokens from the ethereum.core.fact_hourly_token_prices and osmosis.core.ez_prices table. The tokens that are on these bridges and we need them are (axlUSDC, axlUSDT, axlDAI, axlFRAX, axlATOM). Because there is no ATOM token in table ethereum.core.fact_hourly_token_prices, we join it with table osmosis.core.ez_prices

Those who have claimed airdrop: For this purpose, we use table arbitrum.core.fact_transactions and find the list of users who have claimed Airdrop Arbitrum with the following conditions.

ORIGIN_FUNCTION_SIGNATURE IN ('0x4e71d92d', '0x78e2b594') AND TO_ADDRESS = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9' AND BLOCK_NUMBER more than 70506697 AND STATUS = 'SUCCESS'

For this piece of code above, I used Lordking.