shadil
Friktion's Crab Strategy
Apr 26, 2022 - Friktion recently launched a new product offering, Volt #03 - a volatility yield strategy for stablecoins in crab markets.
Profit for AMMs
Apr 11, 2022 - Q63. What is the total profit (in dollars) per day that is generated from swaps out of the liquidity pools in 2022?
Withdraw to my wallet or to my Bentobox?
Apr 27, 2022 - What percentage of users choose to withdraw directly to their wallet rather than withdrawing to bentobox when they perform a borrowing or when they withdraw from lending? Hint: look for ""LogWithdraw"" events. This event will show you what token is withdrawn from your bento address to your wallet address. In order to make sure this has been a lending or borrowing operation, you need to make sure you can find a ""Kashi medium risk"" token in other events of the same transaction.
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well).
Algorand x Fifa Partnership
May 8, 2022 - On May 2nd, Algorand announced a technical partnership with Fifa causing the price to move 25%. Over the rest of the week, how did this impact Algorand blockchain activity?
UST-LUNA Highway
Apr 15, 2022 - -daily minted UST and burned LUNA -daily burned UST and minted LUNA
Transaction Fees
May 19, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
Quixotic NFT Dashboard
Aug 3, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism!
Collateral Impact (May 13)
May 14, 2022 - Q2. How does the volume on MakerDAO (in terms of DAI minting) change as more collateral tokens are added to the platform? Which tokens have impacted volume the most?
Friktion Lightning OGs
Mar 27, 2022 - Q45. Friktion has a community NFT created for its loyal supporters called the Lightning OGs. How do these OG NFTs work?
Impact of Terra integration on new wallets created
Apr 14, 2022 - Show the daily number of new Thorchain wallets created in the 10 days prior to and after the integration of LUNA and UST.
Velodrome Health
Aug 16, 2022 - Q10. Create 3 dashboards on Velodrome with a description for each that showcase traction and success in a data-driven manner.
Failed Transactions
Oct 2, 2022 - Which user action results in the highest rate of failed transactions?
Flow Speed
Jun 3, 2022 - Q4. One of Flow's main features is its speed compared to other blockchains. Blockchain performance can be measured as Transactions per minute. Measure the transactions per minute of Flow since May 9th and 'Successful transactions per minute' and create a chart showing how that metric has fluctuated during that time period.
Solana NFT Championship
Oct 9, 2022 - There’s no shortage of sports-related NFTs on Solana, from Collectorz Club and Suites to Laidback Lions and Aaron Jones’ Showtime collection — but who can lay claim to the title of Solana sports NFT champion?
Hop Bridge Volume
Apr 19, 2022 - How many Matic token were bridged in 2022 per day from ethereum to layer2 using Hop?
Let’s look into wallet activity with regards to Algorand NFTs
Jun 1, 2022 - Q95. How many active wallets are buying/selling/transferring NFTs monthly? What percent of Algo wallets hold an NFT? What’s the number of total wallets that have minted NFTs and put them up for sale, month over month and cumulatively? What projects are the most popular, generating the most transaction volume this month?
Forefront Curators
Apr 15, 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?
Synth Utilization
Apr 8, 2022 - Q57. THORChain launched synths on the network last month. You can read more about them here - https://docs.thorchain.org/thorchain-finance/synthetic-asset-model
The Octorand Universe
May 24, 2022 - Q81. Octorand is a virtual world of opportunity built on top of the Algorand blockchain. Octo Primes are the only form of life existing in the world of Octorand. You can collect these Octo Primes, transform them to increase their value and trade them through the inbuilt marketplace.
ASA Asset Transfers
Apr 3, 2022 - What have been the most popular assets to transfer since the beginning of February 2022 by the number of asset transfers and number of users who have transferred that asset? What announcements could have lead to these assets being popular?
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?
Swap Increase on May 11 + 12
Jun 5, 2022 - Q98. 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 too? 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!
Price + Circulating Supply
Jun 4, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
1M New Algorand Wallets In May
May 15, 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:
LUNA Market Cap
May 7, 2022 - Q201. Back to basics! Display the LUNA price and market cap trend over 30, 60, 90 days; the past year; and all time.
Pricing ASAs
May 8, 2022 - Q61. 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.
WETH/THOR Pool
Sep 12, 2022 - ThorSwap just recently partnered with Sushiswap to create an Onsen farm for ETH-THOR LP providers to stake their liquidity to earn extra rewards.
Successful Bids on Kujira
Apr 11, 2022 - Q178. Determine the total unique users placing bids on Kujira since its inception. Compare bids on bLUNA vs bETH. What portion of these users are seeing their bids filled?
Orca User Growth
May 21, 2022 - Q76. Orca, a popular decentralized exchange on Solana seems to have been gaining significant adoptions over the last few months, especially compared to other exchanges. Create a visualization showing Orca adoption in terms of swap volume and number of unique wallets compared to at least two other popular Solana exchanges and Uniswap on Ethereum? What can explain this increase in adoption? Provide some insights on this trend and the types of users using Orca (hint look into which popular app on Solana is using Orca).
200K ALGO Donated Toward Tree Planting
Mar 7, 2022 - Question 32: Algorand is a carbon negative blockchain and the carbon operations produce is often offset by tree planting. Gilbert the Goanna(https://algoanna001.com/) is Goanna #001 from the Al Goanna NFT collection and an organization that has planted over 40,000 trees. Recently they reached the benchmark of 200K ALGOs in donations for tree planting(https://twitter.com/Gilbertgoanna01/status/1498135551588769798).
Fuse Pool USDC Allocation
May 21, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Member Roles
Mar 7, 2022 - Question 1: A member is a user who has 35,000 or more $BANK tokens in their wallet (not counting members with Guest passes). A whale is a user who has over 150,000 $BANK tokens in their wallet. Show the number of members and whales on Bankless DAO over time (not counting Guest Passes for members).
Mona Lisa- Lil Pump ft Soulja Boy MFT
May 22, 2022 - Q79. Opulous is a launchpad for music NFTs, where you can take ownership in artists’ songs, albums, and artworks and earn royalties from them. One of the first songs released was Mona Lisa- Lil Pump ft Soulja Boy
Genopets Staking
May 29, 2022 - Q78. Genopets is a move-to-earn game reminiscent of Pokemon Go on Solana.
Overtime Markets - Volume
Aug 20, 2022 - Analyze the total volume on Overtime Markets over the past two weeks. Which games received the most activity, both in total users and total $ volume? Which sports are receiving the most bets in total dollar volume on a daily basis? Explain your findings.