BTC on Avalanceh
Welcome to the Avalanche Network BTC.b Dashboard. This dashboard provides insights into the usage and activity of BTC.b on the Avalanche network, including trends and patterns of transactions, swaps, and bridging activity.
In this dashboard, we aim to explore the behavior of wallets that have used the BTC.b bridge on Avalanche, and what they are doing with their assets after bridging them to Avalanche. We also examine the destinations of BTC.b that are being bridged via the Layer0 bridge to other chains, such as Arbitrum, Polygon, BSC, Ethereum, and Optimism.
Moreover, we analyze the protocols and contracts being used by these wallets on Avalanche, the number of transactions made on the network, and whether they are swapping their assets for other tokens on Avalanche.
By analyzing these data points, we can better understand the usage and adoption of BTC.b on the Avalanche network and provide insights into user behavior on the network. We hope that this dashboard will be useful for researchers, investors, and anyone interested in exploring the Avalanche ecosystem.
The assessed metrics in this dashboard refer to the various data points and visualizations that have been analyzed and compiled to gain insights into the usage patterns of BTC.b on Avalanche. These metrics include the volume and count of minted and burned BTC.b, the popular destinations of transferred transactions, the trend of swapping BTC.b on the Avalanche network, the usage of the Layer0 bridge to transfer BTC.b to other blockchains, and the usage of contracts and protocols on Avalanche. These metrics are used to provide a comprehensive view of the ecosystem and to identify key trends and patterns that can inform decision-making for users and stakeholders in the BTC.b community.
The purpose of this dashboard is to provide an in-depth analysis of BTC.b token transactions on Avalanche and other EVM chains, including the protocols and contracts used, the number of transactions, and asset swapping activities. The analysis is conducted using the avalanche.core.fact_token_transfers and avalanche.core.fact_event_logs tables, and the avalanche.core.dim_labels table.
To begin, we extracted data from the avalanche.core.fact_token_transfers table, where we identified all transactions originating from the null address ('0x00...0000'), indicating that the BTC.b tokens were minted. Similarly, transactions sent to this address indicated that tokens were burned. This allowed us to identify the wallets that have used the BTC.b bridge on Avalanche.
Next, we used the avalanche.core.fact_event_logs table to distinguish between swap and transfer transactions, which provided an overview of what BTC.b interactors do with their tokens. This allowed us to identify the chains users are bridging the BTC.b to with Layer0.
To further analyze the BTC.b transactions, we used the avalanche.core.dim_labels table to find where BTC.b transferrers sent their tokens by project name and label type.
In addition, we looked at bridging activities on other EVM chains like Ethereum and BSC, by using the BTC.b bridging address, '0x22...42e3'.
The analysis was conducted on a weekly basis and the timeframe of analysis can be changed using the Time_Interval parameter to meet the desired timeframe.
Overall, this methodology provides a comprehensive analysis of BTC.b transactions on Avalanche and other EVM chains, which can be viewed through separate tabs in the dashboard for each topic.