mercury
Avalanche Gas Fees
Mar 25, 2023 - In this dashboard, we have investigated the amount of gas used in the Avalanche network. The dashboard has two major tabs: one for contracts and one for dApps. Each tab shows which ones generate the most network fees and use the most gas over a user-selectable time period. We have also added two more tabs to the report, by using them and using the parameters below, you can analyze your desired contracts or dApps in terms of the metrics related to the gas used.
AVALANCHE DEX PLATFORMAs ANALYSIS
May 3, 2023 - Flipside keeps shipping and these past weeks they shipped a DEX swaps table (avalanche.core.ez_dex_swaps). This DEX swap table includes swaps from BALANCER (soon), CURVE, FRAX, GMX, HASHFLOW, KYBER (both classic and elastic), PANGOLIN, PLATYPUS, SUSHI, TRADER JOE, UNISWAP (Soon), and WOOFI. Create a dashboard or a tool that utilizes this new table. Here are some ideas for inspiration: Popular Asset Monitor: Monitors the most popular and rising assets being traded into across Avalanche DEXes. Looks at the number of users trading the assets and at what volume. Popular LP Monitor: Monitors popular trading pairs and LP pools and calculates the pools with the largest volume of trading. Popular DEX Monitor: Looks at the USD volume of DEXes to help the ecosystem determine which DEXes are the most popular. Token Swaps History Explorer: A tool that allows users to explore and analyze their transaction history of token swaps on decentralized exchanges.
Avalanche Active Users
Apr 16, 2023 - Let’s analyze Active Users on the Avalanche network. Create a parameterized dashboard that lets us explore active users across the chain. We'd recommend at least 3 tabs: active users across the chain, active users by contracts, and what dApps have the most active users over the parameterized period of time. The goal of this dashboard is to show where most of the activity is taking place on chain and where the active number of users is growing on chain. Add any additional metrics or charts that will provide users insights into contracts and dApps with growing usage based off average active users, new active users.
Avalanche Swaps vs Transfers (Redux)
Dec 7, 2022 - Examine Avalanche USDC(0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E- https://snowtrace.io/token/0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e) swaps vs transfers and mints vs burns using the new fact_event_logs data and avalanche.core.fact_traces data. Lets look at volume of USDC swaps vs transfer by hour since 7/1. - What is the average amount of USDC transferred vs swapped? - Show number of unique swapper addresses vs transfer addresses by day for USDC Next lets look at mints and burns of pairs involving - Lets look at the volume of USDC mints and burns by hour since 7/1 - How many unique wallets are minting and burning USDC by day - What is the average mint vs burn for USDC by day - Note anything else interesting about USDC transactions 75, 112.5, USDC, Ethereum