Axelar : CrossChain Activity

    Query Breakdown 🔨


    This SQL query defines several Common Table Expressions (CTEs) to prepare and process data related to blockchain transactions, specifically those involving token transfers between different chains (crosschain transactions) using two routers named "Squid" and "Satellite".

    1. hourly_token_prices CTE: This CTE takes the average price of tokens per day, based on hourly prices from the crosschain.core.ez_hourly_prices table. It groups the data by day and token symbol, giving a daily average price for each token in USD.

    2. squid_txns CTE: This CTE collects transaction data from the axelar.core.ez_squid table (the "Squid" router) and calculates the USD amount of each transaction by joining the hourly_token_prices CTE based on the token symbol and transaction day. It also concatenates the source and destination chains to create a new column named crosschain_pair.

    3. satellite_txns CTE: This CTE is similar to squid_txns, but it collects transaction data from the axelar.core.ez_satellite table (the "Satellite" router) instead.

    4. combined_router_txns CTE: This CTE combines the transaction data from both "Squid" and "Satellite" routers using a UNION ALL.

    The overall purpose of this query is to prepare a dataset that combines information about crosschain token transactions from two different routers ("Squid" and "Satellite")

    What is Axelar?


    Axelar delivers secure cross-chain communication for Web3, enabling you to build Interchain dApps that grow beyond a single chain. Secure means Axelar is built on proof-of-stake, the battle-tested approach used by Ethereum, Polygon, Cosmos, and more. Cross-chain communication means you can build a complete experience for your users that lets them interact with any asset, any application, on any chain with one click.

    db_img
    Introduction
    Methodology

    Data Limitations


    Even though we used crosschain.core.ez_hourly_prices , we weren't able to find the amount in USD for around 12 tokens.

    Hence we have used ~ to approximate the value of volume_usd.

    Nearly 90% of the txns are unlabeled when we combine it with dim_labels