Saleh
New DEX Users
Mar 28, 2022 - Q40. Let's use the algorand.swap table to look at users who are using the new DEXes(Decentralized Exchange): PactFi, AlgoFi, WagmiSwap and whether or not they previously used the Tinyman exchange?
Outbound Traffic
Mar 16, 2022 - Outbound Traffic Question 166: The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
wETH Deposit Rate
Jun 12, 2022 - Q11. Calculate the deposit rate of wETH over time on Osmosis. How does this compare to SushiSwap and Thorchain now? How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? Is Osmosis growing at a faster rate than Thorchain and Sushiswap?
Osmosis One Year Anniversary
Jun 23, 2022 - What did the users who received the initial airdrop of OSMO do with their tokens? Create a visual that shows how many sold, staked, LPed, swapped, and held. How many individuals who received the airdrop still hodl their OSMO one year later?
Solana NFT Purchasing Behavior
Apr 27, 2022 - Show the distribution of all Solana NFT sales on Solana. What percentage of all sales have been above 1 SOL? Above 10 sol? How many unique wallets have made a NFT purchase that was above 10 SOL? Above 100 SOL? Do you think that there is a limit to how high a floor for a NFT collection on Solana can reach compared to on Ethereum?
Unique Buyers and Sellers
May 4, 2022 - Are more people joining or leaving the Moon Birds community? Look at unique buyers and sellers over a period of time
New Wallets In May
Jun 15, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May? How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap?
Terra Scavenger Hunt (Farsi)
Feb 10, 2022 - طبق جدول پایین , عملیات استیک کردن با ولیدتوری فلیپساید انجام شد
User Growth per Sector
May 4, 2022 - What sectors / Apps are driving user growth on Solana? Choose the top apps per sector (DEXs, Borrowing, Staking, NFTs ...) and create a dashboard of user growth per sector and App. Are there any sectors / apps that are driving more user growth than others? Share your findings.
2. Algorand Governance
Jan 10, 2022 - Percentages and numbers were extracted from the Algorand database And according to the Algorand documentation for the first time period from '2021-10-01' to '2021-12-31' and for the second time period from '2022-01-01'. Also, to understand Governance in records, the ascii code filtering method was used, which is as follows:
Bot Swappers
Apr 27, 2022 - Define bot swappers. How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. What percentage of swaps were executed by bots in the past 30 days? What pools and what pairs were most popular among bot swappers in the past 30 days.
User Segmentation Analysis
Jan 1, 2023 - Last week we analyzed how users join pools, single or double-sided, which showed that most users join two-sided. This means that most users are already engaged within the Osmosis ecosystem.
Algorand Competitive advantages Algorand NFTs Atomic Transfer Sales
Jun 16, 2022 - Q104. On Algorand there is a functionality called the atomic swap(or atomic transfer) which allows you to safely sell an asset to a buyer without the need of a marketplace. One place to perform this is https://www.randswap.com/. Using https://www.asalytic.app/ and https://www.nftexplorer.app/stats as references lets look at atomic transfer volumes for NFTs in 2022.
Untitled BoardUSDC Declining on Solana?
Oct 7, 2022 - It looks like over the last few weeks the market cap of USDC on Solana has been declining.
1M New Algorand Wallets In May-wallets
May 19, 2022 - Q66. From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand? Some things to look at: -Using the account table, show the distribution of ALGOs these wallets have? -Are these wallets swapping assets? If so, what assets are these wallets swapping for? -What assets do these wallets hold using the account_asset table? -Do we see any commonalities our patterns across these wallets?
stETH vs. ETH
Apr 5, 2022 - Q6. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
Genopets Staking
Jun 1, 2022 - Q78. Genopets is a move-to-earn game reminiscent of Pokemon Go on Solana. Recently, Genopets launched staking for their $GENE token (read more here https://medium.com/@genopets/announcing-gene-token-staking-1513e08ecbe). Create a visualization showing the amount of staked GENE over time. How many unique wallets have staked $GENE since its inception on May 18th? What percentage of those stakers have previously purchased a Genopets NFT? What trends are you seeing with the Genopets NFT collection?
Solport vs. Magic Eden
Apr 2, 2022 - Q48. Solport - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden?
RocketPool: User Profile - LIDO vs. RocketPool
Apr 27, 2022 - Q19. Lido is another application that also offers ETH2 liquid staking. Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions.
IL Insurance
Apr 13, 2022 - Q54. What % of users that are removing liquidity are receiving IL insurance?
Optimism NFT Purchasing Behavior
Oct 18, 2022 - Show the distribution of all NFT sales on Optimism by price. What percentage of all sales have been above .01 ETH? Above .1 ETH? 1 ETH?
Assets Removed from Osmosis
Jun 10, 2022 - On June 8th, a critical bug was found on Osmosis that led to the theft of several million dollars from liquidity pools. In an effort to help provide the Osmosis team with important data, we’ve curated these flash bounties to surface metrics that the team has requested. The upgrade that contained the exploited bug occurred at block height 4707300, and the chain was halted at block 4713064. What was the total dollar amount of assets that was improperly removed from pools due to the bug, and what is the list of addresses that had joined a pool since the upgrade? What is the dollar value deposited of those addresses joining pools? What is the cumulative value of funds that joined and exited?
Pooly NFTs
Jun 22, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Getting Your Feet Wet, Part 2
Mar 5, 2022 - Question 161: Assess the extent to which new users interact with each of the following projects.
NFT Buying Behavior on Flow
Jun 14, 2022 - Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
5. User Actions
Jan 12, 2022 - The most common things that new curve users do after depositing money are as follows. And as expected, it is approve in the first place, then transfer, withdraw, and again deposit and mint, ...
Untitled BoardBinance Bonanza
Nov 1, 2022 - On October 28th, 2022 Binance became the first CEX to list spot trading for $OSMO. Abruptly, OSMO price shot up around 32%. How did this news impact trading on Osmosis. Analyze OSMO trading activity on October 28th and this past week vs. daily & weekly averages. This analysis should occur against two time periods: the 60-day averages & the 60-days prior to the May Terra collapse. Did any other tokens see a spike in trading on Osmosis?
HODL or Sell?
Jun 13, 2022 - Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
SOL Staker Activity
Apr 13, 2022 - Q52. How frequently are SOL stakers interacting with DeFi protocols over the past month? Which protocols are they interacting most with? Which actions are they mostly taking? Staking? Farming? Swapping? Mining?
Stability Fee
Jan 18, 2022 - We created a range below based on which: 1- We made a classification between the amount of fee in dollars 2- Based on the above category, we displayed the loan amount 3- We also showed the amount of fees accordingly 4- Finally, we showed the number of borrowers in those areas