isam-NuSprf
Liquidity Activity
Mar 6, 2022 - Which liquidity pools and platforms are users using to acquire BANK tokens? Which tokens are being swapped most to acquire BANK tokens?
Tracking USDH
Apr 22, 2022 - 57. Hubble is a decentralized finance protocol built on Solana. Hubble will offer multiple Hubble currently focuses on borrowing and minting USDH - a stable coin. Users can deposit multiple kinds of crypto assets like SOL, BTC, ETH, and others to borrow up to 90.9% LTV in USDH. While borrowing, users can earn yield on their deposits. Therefore you can take your USDH and invest it in other protocols. Track where USDH is being used the most on other Solana defi protocols. What are the most popular pools where users are depositing USDH? Why do you think wallets are choosing to interact with those protocols with USDH? What tokens is USDH most commonly swapped for? What are some ways that USDH can become more adopted within the Solana ecosystem?
Tracer Voters
Mar 3, 2022 - Tracer Q2: How many people (addresses) have voting rights in tracer? How much of that has been deposited in major decentralized exchanges(DEX)? what is the breakdown per DEX
NBA Playoff Usage
Jun 27, 2022 - Q.15 Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
MIM + Its Peg
Feb 9, 2022 - How has MIM performed at holding/regaining its peg over the past few weeks. Is MIM depegging correlated with the price of other stablecoins, especially UST?
Forefront Treasury
Mar 30, 2022 - Create a visualization showing Forefront's treasury holdings over time. How have they allocated funds over time between FF holdings, USDC holdings and ETH holdings?
Withdraw to my wallet or to my Bentobox?
Apr 28, 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.
Wildlife Warriors NFT Drop
Jun 23, 2022 - Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs.
$RUNE Upgrades
Jun 26, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated. Have you seen an uptick in the amount of $RUNE being upgraded recently? Look at both the $RUNE volume + number of wallets. What is the trend over time + also how much is ETH vs BNB?
Deposit rate from L1s
Jun 11, 2022 - Q105. Look at users swapping from native L1 assets to $RUNE. Are there any trends by chain or over time?
Impacts of UST on STBL
May 18, 2022 - Q67. This week we saw the depeg of UST(a stablecoin built on Terra) and it sent shockwaves through all blockchain ecosystems causing the crypto market to crash. STBL is a 100% fully collateralized stablecoin created by the AlgoFi protocol. Let’s look at how the circulating supply of STBL was impacted by the events from May 8th to May 14th. Let’s look at how much STBL was borrowed and how much repaid during the volatile week? What assets were swapped for STBL? Was there more swap volume into or out of STBL? Did we see a one to one swap swap volume with USDC? If not, why not? Were there certain trades causing this discrepancy? Look at actions regarding STBL such as staking on AlgoFi! Is there anything else interesting related to STBL that's worth noting? If so, describe what you've found! Tips STBL Market Contract Market Address:OPY7XNB5LVMECF3PHJGQV2U33LZPM5FBUXA3JJPHANAG5B7GEYUPZJVYRE Market App ID:465814278 Bank Asset ID:465818563 Underlying Asset ID:465865291 https://app.algofi.org/lend https://docs.algofi.org/algofi-lending/stbl https://docs.algofi.org/stbl-stability-system/stbl-peg-index https://docs.algofi.org/algofi-lending/master/borrowing-assets
Net Synth Amounts
Apr 29, 2022 - Show the net synth amounts (mints - burns) for each chain and each asset? Are there any patterns? Hint: use thorchain.swaps (synthetics with have a “/” in the asset name)
Swap Increase on May 11 + 12
Jun 9, 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 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!
Whale Swaps
May 4, 2022 - How many swaps are above x$ and how much total amounts were swapped in such transactions? Hint: you should use parameters. you can set X as $150,000 by default.
LoftyAI Tokenized Real Estate
Mar 3, 2022 - Algorand Q27: LoftyAI is a tokenized real estate platform(https://www.lofty.ai/). You can invest in property via tokens distributed by Lofty AI, each being worth $50. Rank the properties listed by LoftyAI based on total token investment price. (Each property has its own asset created by the address 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'). How many wallets have bought a token for at least one property? What wallet has invested in the most Lofty AI properties? How many properties are they invested in?
Friktion Bitcoin Volt
Mar 22, 2022 - Friktion is a new DeFi portfolio management project that helps users maximize profits by generating yield. The Friktion BTC Covered Call Volt is one such yield opportunity for interested participants who want to generate income while holding BTC
Friktion SOL vs mSOL Volts
Feb 20, 2022 - "Friktion offers an income generating covered call product to users. A covered call option involves holding a long position in a particular asset, for example, SOL, and writing a call option on that same asset with the goal of realizing additional income from the option premium. How much SOL was deposited during the February 4th and February 11th epochs and how many unique users were in the SOL covered call volt? How much mSOL was deposited during those same epochs and how many unique users were in the covered call volt? Why do you think one volt has been gaining more adoption than the other?
New DEX Users
Mar 31, 2022 - 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? What percent of wallets for each of the new DEXes(swap_programs:PactFi, AlgoFi, Wagmiswap) had previously used Tinyman to perform a swap?
MIM Use Cases
Feb 10, 2022 - How is MIM used in comparison to USDC / USDT / UST or a stablecoin of your choice? Describe user behavior. What protocols or contracts are users interacting with? Compare the count and volume of transactions
Total Metamask Users
Jun 24, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Mango Markets Bounties
Feb 18, 2022 - Mango Markets is a decentralized, cross-margin trading platform with lightning speed and near-zero fees because it is natively built on Solana. There is a one time fee of .035 SOL to open a trading account on Mango Markets. How many new trading accounts have been created by users since February 10th? How much SOL has been transferred into Mango Markets (don't count the one time fee) since February 10th from first time deposits? What was the average deposit amount? Create a visualization showing these trends over the time specified.
Distinct Wallets (Optimism Bridge)
Jun 16, 2022 - Q1. Many blockchain bridges exist allowing users to move assets between different blockchains. One of the blockchains currently receiving a lot of bridge volume is Optimism. There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in Optimism’s bridge. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Saber and daoSOL
Feb 18, 2022 - Saber is the leading cross-chain stablecoin and wrapped assets exchange on Solana. As we learned in the scavenger hunt last week, you can create a liquidity pair with staked SOL from the MonkeDAO created DAOPool with SOL to earn additional yield on Saber. Sejak awal Februari, berapa banyak likuiditas yang telah disimpan di kumpulan daoSOL-SOL per hari? Berapa banyak dompet unik yang telah menambahkan likuiditas ke kumpulan itu sejak 1 Februari? Buat visualisasi yang menunjukkan tren likuiditas dengan kumpulan ini.
Active Daily Wallets
Feb 28, 2022 - this dashboard to show the number of unique wallets in algorand in december and january
StepN Growth
Feb 27, 2022 - StepN is a Solana based ""move-to-earn' game (you earn the game's native token GST by moving around using their NFT sneakers and GPS system). The game has seen steady growth in popularity since it launched at the end of December (transitioned from a private beta mode to its current public mode). Create a visualization showing the number of unique wallets that have transacted with GST by day since January 1st. How much total GST has been transacted per day since January 1st? Provide some insights over the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
Opensea Fees
Jul 28, 2022 - 6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Algorand Governance Period 2 Voting
Mar 10, 2022 - Question 34: Algorand's 2nd Governance Voting Period Ran From January 31st to February 28th 2022(https://governance.algorand.foundation/governance-period-2), lets take a look at how wallets voted for or against xGovs.
Saber Locked Over Time
Mar 25, 2022 - Review the scavenger hunt (dropping Monday!) on veSBR for an explanation on the Saber Wars! Create a visualization showing the amount of SBR locked in governance over time since January 1st. Are there any notable trends on when SBR has been locked or wallets have exited from their locked positions? For example, have there been certain dates when we can expect there to be more locking activity than others? Provide some insight on locking behavior.
Getting Started With Solana Bounties
Feb 17, 2022 - In this dashboard I visualize my specific Marinade staking transaction as part of all the Marinade staking transactions that happened during each hour of the day on whick my transaction occurred.
HODL or Sell?
Jun 15, 2022 - 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?
USDC Deposits
Jun 22, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
What makes a Top Shots moment valuable? (Part I)
Jul 16, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. 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.