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".
-
hourly_token_prices
CTE: This CTE takes the average price of tokens per day, based on hourly prices from thecrosschain.core.ez_hourly_prices
table. It groups the data by day and token symbol, giving a daily average price for each token in USD. -
squid_txns
CTE: This CTE collects transaction data from theaxelar.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 namedcrosschain_pair
. -
satellite_txns
CTE: This CTE is similar tosquid_txns
, but it collects transaction data from theaxelar.core.ez_satellite
table (the "Satellite" router) instead. -
combined_router_txns
CTE: This CTE combines the transaction data from both "Squid" and "Satellite" routers using aUNION 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.