Punks of the punks: Cryptopunk Sales and Traders
Sep 1, 2022 - A dashboard to look at who have been the most successful cryptopunk traders in terms of both money and number of cryptopunks. Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
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.
Optimism NFT Purchasing Behavior
Oct 19, 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? Do you think that there is a limit to how high a floor for a NFT collection on Optimism can reach compared to on Ethereum?
Rand Gallery NFT Sales
May 5, 2022 - Rand Gallery is one of the largest NFT marketplaces on Algorand. Let’s take a deeper look into rand gallery’s history and the performance of the marketplace.
Tinyman Hack (January 2022)
Oct 24, 2022 - Analyze the impact of the Tinyman hack of January 1, 2022. Provide a list of all wallet addresses impacted by this hack. For each wallet address, show how much value it had in the Tinyman protocol, and how much it lost in the hack. Additionally calculate the total loss value from the hack.
ALGOxNFT Marketplace
May 12, 2022 - ALGOxNFT is one of the largest NFT marketplaces on Algorand. Let’s take a deeper look into ALGOxNFT’s history and the performance of the marketplace.
BendDAO Balance Sheet
Sep 8, 2022 - Build a comprehensive balance sheet dashboard for BendDAO.
Ref.Finance, the Bank of Near ?
Aug 10, 2022 - NEAR Tournament Round 3: The Financial District Provide and explore key health metrics, as well as detailed data on at least 1 key project. In your analysis, provide visualizations of USN, USDC and USDT breakdowns (i.e. which dapps and addresses hold the majority of USDC and USDT, and what cumulative flows to & from exchanges look like over time)
Hacks, Scandals and Scams - 2. Bored Phish
Jul 29, 2022 - This spring the Bored Ape Yacht Club Discord and Instagram accounts were hacked. The hackers sent a phishing link to the community. As a result of this phishing scam, users lost some Bored Apes, Mutant Apes, and other assets. How many NFTs were stolen? What is the total value of all NFTs stolen? Show the percentage of compromised wallets that bought back more NFTs from the same collection that was stolen.
The battle of NFT marketplace.
Sep 28, 2022 - Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year.
Mirror Fundraising
Jun 25, 2022 - How much total funds has Mirror raised? How many unique sponsors are there? How many total publications have been written? What are the most popular accounts?
Secondary Sales Activity
Jun 22, 2022 - How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Mirror Funding Mechanisms
Jun 25, 2022 - Show a breakdown of Mirror’s funding mechanisms on Ethereum mainnet. How much have auctions raised vs. crowdfunds? Which mechanism contributes to the most funding for the treasury?
Sushi Activity on Ethereum
Jun 27, 2022 - Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
CEX to zkSync: Visualizing Ethereum Deposits and User Adoption
Sep 18, 2023 - This dashboard provides a comprehensive view of Ethereum (ETH) deposits into the zkSYNC chain originating from major centralized exchanges (CEXs) like Binance and OKX. By visualizing real-time and historical data, we aim to shed light on user adoption trends and the growing influence of zkSYNC as a Layer 2 solution. Whether you're an investor, developer, or crypto-enthusiast, this dashboard offers valuable insights into the evolving landscape of Ethereum scaling solutions.
Sushibar Servings
Apr 22, 2022 - Q66. Draw charts showing sushi tokens transferred to the Sushibar. Do it at different frequencies and describe the trends if any.
Stargaze of cosmos
Oct 12, 2022 - Cosmoverse was full of amazing announcements and alpha leaks. Analyze your favorite token’s LP & trading activity on Osmosis over the past week. Please provide volume and user growth metrics into this analysis and focus on deep insights on ONE token.
Flipside's World Cup Kick Off: Gas Guzzlers
Nov 15, 2022 - A gas tracking dashboard that looks at gas usage by a chain over the last couple of months
Optimistic sushi : is sushi the first meal of optimists ?
Oct 26, 2022 - Show the contribution of SushiSwap to the growth of the Optimism user base. What share of total daily new Optimism users do these new SushiSwap users represent ?
$MATIC Liquid Staking
Sep 21, 2022 - Define what liquid staking is in your words, and evaluate the different liquidity staking options based on three different metrics of your choice. Bonus: How do people use these "liquid" derivatives? Do you see any trends?
Anirand Rug Pull?
May 13, 2022 - Q63. Crypto assets can have high volatility. On March 28th 2022, the price of ANIRAND (604643747) dropped when 99% of the liquidity was removed from the ANIRAND/ALGO pool on Tinyman. For reference: https://twitter.com/AlgoScout/status/1508495588148531208
Fault tolerant staking
Apr 12, 2022 - Q2. Define Fault Tolerant Staking (FTS). What are the advantages of FTS? What are the disadvantages? Explain what problems FTS might help solve.
Flipside World Cup: USDC Transfers
Nov 22, 2022 - we are focusing on the use of USDC across multiple chains: Ethereum, Solana, Algorand, Flow, NEAR, Optimism, Osmosis, and Axelar. compare and monitor which chains are most active and liquid in their transfers of USDC.
stETH vs. ETH 2
Jun 7, 2022 - Q6. How has the price of stETH changed compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
Transaction nature
Mar 31, 2022 - Q171. In your own words, briefly explain how transaction volume relates to fees paid to stakers. Then, create a graph to show the fees derived from transactions and native swaps.
Forefront Curators
Apr 19, 2022 - Q2. Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? How could Forefront incentivize growth in curator roles?