mehdimarjan
Algorand New DEX Users
Mar 31, 2022 - who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange?
Getting Your Feet Wet, Part 1
Mar 9, 2022 - In this analysis, we intend to take a look at the activity of the new wallets of the Tera network.
Sushi Activity on Ethereum
Jun 28, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
Polygon Block Performance
Jul 25, 2022 - What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Osmosis Swap Fees
Jun 29, 2022 - Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis?
soheil- Standardized TVL Over Time (1 Pool)
Apr 25, 2022 - Select one pool of your choice and show the total number of asset tokens (non-RUNE tokens) in that pool over time
Stablecoin Popularity for Swaps
Apr 7, 2022 - Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022.
What Are Whales Swapping For?
Apr 13, 2022 - look at the whales are swapping for on the DEXes.
Lido ETH Staked
Jun 14, 2022 - What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
More Mints
Apr 17, 2022 - How many NFTs have been minted over the past week? Since the beginning December, how many NFTs have been minted per week? Chart the growth of unique purchasers over time. What percentage of all mints have been via Metaplex's Candy Machine?
What makes a Top Shots moment valuable? (Part I)
Jul 22, 2022 - What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
DIY Most Popular Centralized Exchange For Algorand Wallets
Mar 24, 2022 - In this tutorial, I am going to show you how to create a graph of the volume of ALGOs that have been transferred to each CEX and from each CEX since the beginning of 2021. But before that, you need to get acquainted with the terms and concepts in the section on ctypto currencies and the ALGORAND network, as well as how to monitor databases in SQL. This tutorial is divided into two parts: ALGORAND network concepts and crypto currencies, as well as coding using SQL language.
Staci Warden; New CEO In Algorand Foundation
Mar 10, 2022 - On February 10, the Algorand Foundation announced the appointment of Staci Warden as CEO. Warden, who has served on the board of the Algrand Foundation since September 2021, will take on the additional role of CEO from this day forward. Warden has led global teams at the Milken Institute, JP Morgan, the Nasdaq Stock Exchange and the US Treasury Department.
Voting Activity
Jun 20, 2022 - analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
The Battle of the Solana NFT Aggregator
Oct 30, 2022 - Comparing KPIs between Hyperspace and Coral Cube. Which marketplace has done more volume? Which collections are popular on each marketplace? Why would I use one marketplace over the other?
Algorand x Fifa Partnership
May 13, 2022 - How has the collaboration between FIFA and ALGORAND affected Algorand blockchain activity?
Swapping goBTC and goETH on DEXs
May 19, 2022 - Let's look at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC - especially during the price crash in May.
Pricing ASAs
May 13, 2022 - Finding a market price for ASAs (Algorand Standard Assets) can be difficult at times due to the lack of prices being listed on sites like CoinMarketCap or CoinGecko. In this dashboard, an attempt has been made to display the price of Algrand's assets along with their volume and fluctuations at a specific time.
Swap Increase on May 11 + 12
Jun 9, 2022 - On May 11th and 12th we saw a spike in number of swaps and volume across the DEXs. Breakdown what happened? What were users swapping from and to? Were users swapping from ALGO to stables? Was the average swap size bigger than normal? Is this tied to the price of ALGO? Help us understand what took place and why the volume and number swaps increased!
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 29, 2022 - Identify active wallets with a high balance of ETH (whales). Visualize the ETH transaction history of these whales in May and June 2022.
What's Going On With Gnosis?
Oct 17, 2022 - There’s been some unusual activity with Gnosis as pointed out by our community. Time to figure out exactly what’s going on.
DUST is in the Air
Sep 8, 2022 - How is $DUST being used in the Solana ecosystem? What are its most popular use cases and where are buyers of $DUST coming from? Highlight at least 3 metrics showing $DUST trends in Solana.
Pooly NFTs
Jun 22, 2022 - How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
What Are Users Swapping gALGO3 For?
Apr 28, 2022 - Show the number of trades to gALGO3 and from gALGO3 by day? Also chart the volume of trades to gALGO3 and from gALGO3 by day? Are there any notable days? If so, what may have caused this? What DEXes are users swapping gALGO3 on? Show the breakout of number of gALGO3 swaps(to or from) by day for each dex. What are the top 10 most popular to swap from to get gALGO3? What are the top 10 most popular to swap to from gALGO3?
Most Popular ASA To Swap From ALGOs
Apr 14, 2022 - Let’s look at what ASAs are most popular to swap into from ALGOs in 2022 using the swaps table
Highest Sales Volume
Jun 10, 2022 - In this dashboard, we review NFTX and examine the 3 collections that had the highest sales volume in the last 60 days on NFTX.
Trending NFT Projects
Jun 11, 2022 - Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?