princefarzam
200K ALGO Donated Toward Tree Planting
Mar 10, 2022 - Show the donations to the wallet over time. Has the donation wallet sent any of the ALGOs anywhere? If so, what addresses have most of the ALGOs been sent to? Have any of the ALGOs been sent to a centralized exchange(CEX)? If so, how much?
Getting Started With Algorand Bounties 2.0
Mar 31, 2022 - This analysis will assess the popularity of the ALGO token on centralized exchanges. We will ascertain the volume of ALGO moved to and from CEXs since the beginning of 2021 by: charting the volume of ALGOs moved to each CEX per day, and charting the volume of ALGOs moved from each CEX per day in this time period. send some ALGOs from a centralized exchanges to your algorand wallet. Then identify the transaction in the algorand.transactions table.
Uniswap on Polygon Scavenger Hunt
Feb 12, 2022 - In this hunt we learned how to swap Matic to wETH in uniswap dex, then we provided liquidity for Matic-wETH pool.
zkSync Scavenger Hunt
Jun 14, 2022 - 1. Create a zkSync wallet 2. Migrate ETH to zkSync 3. Swap for USDC
Flow Scavenger Hunt: NFTs and FLOATS (May 24)
May 25, 2022 - In this dashboard, I did these three steps: Show your acquisition of FLOW Show your FLOW reaching your wallet Show your activity on BloctoBay + FLOAT
Stablecoin Popularity for Swaps
Apr 7, 2022 - Q45. 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.
Anchor Emissions
Feb 23, 2022 - In response to Question 152: Create a table of all addresses that have made at least one Anchor borrow in the last 3 months. Do some basic analysis and produce at least one interesting insight about Anchor borrowers.
Genopets Staking
Jun 1, 2022 - 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?
Overtime Markets - Volume
Aug 22, 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.
SOL Swaps on Jupiter
Feb 19, 2022 - In response to Since January 1st, how much SOL has been swapped for other tokens using Jupiter per day? Over the same time period, how much SOL has added from swaps using Jupiter per day? Create a visualization showing the flow of SOL from swaps on Jupiter since January 1st per day and provide insights around any spikes you see.
Solana Fees
Feb 5, 2022 - In response to: Question 6: One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction fees per transaction on each day. Do fees ever seem to spike or is it consistent?
Flow Scavenger Hunt: Dapper Wallet (May 31)
Jun 1, 2022 - In this dashboard, we first sent ETH to the dapper wallet and charged it about 5 dollars, then we bought an nft via NBA TopShot website, and finally, we purchased an nft on Gaia.
Daily Transactions and Unique Addresses
Jul 13, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022. In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
USDC, USDT, UST on Jupiter
Mar 6, 2022 - Question 31: Create a visualization comparing USDC, USDT, and UST (wormhole) popularity in swaps on Jupiter since December 1st (both in terms of count and amount - swaps from and swaps to). Is there a dominant stablecoin in swaps on Jupiter? What percentage of all Jupiter swaps are stablecoin swaps (as in a swap between USDC, USDT, and UST)? Have we seen more instances of users swapping USDC or USDT for UST over time? Why or why not based on your knowledge of Terra's cross-chain efforts?
Highest Sales Volume
Jun 12, 2022 - Q1. Which three NFT collections have the most total sales volume in the last 60 days on NFTX?
Getting Started With Algorand Bounties 3.0
Apr 28, 2022 - Q.The number of swaps from ALGO to other assets by day in March 2022 by DEX. what assets wallets are trading their ALGOs for in March 2022.
NEAR Gas Guzzlers
Jul 27, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
[Pool Together Bounties] 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?
Friktion SOL vs mSOL Volts
Feb 21, 2022 - In response to 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?
ETH Staked
Jun 12, 2022 - Q9. 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?
Algorand Foundation New CEO Staci Warden
Mar 10, 2022 - Question 31: Algorand Foundation appointed a new CEO Staci Warden on February 10th 2022. How did this impact the Algorand ecosystem? The week following announcement did we see an increase of ALGOs being moved from CEXs(centralized exchanges) to wallets? Or did we see an increase of ALGOs being moved from wallets back to CEXs?
Active Daily Wallets
Mar 3, 2022 - Algorand Q30: Compare the number of active daily wallets for the month of January 2022 to December 2021 and January 2021. What day had the most active number of wallets in January 2022? Was there an event on Algorand associated with this date?
Flow Scavenger Hunt
Mar 11, 2022 - In this scavenger hunt we delegated small amount of flow to a validator.
StepN Growth
Feb 26, 2022 - In response, Create a visualization showing the number of unique wallets that have transacted with GST by day since January 1st. How much total has GST been transacted per day since January 1st? Provide some insights into the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
The Road So Far, Mvmt. I: Validators
Mar 16, 2022 - Review all the Terra submissions to date that discuss validators and delegators. Provide a brief summary of what we have learned so far, via various bounties, about Terra's validator network.
Stablecoin Arbitrage on Jupiter
Mar 23, 2022 - Q40: Because Jupiter is a dex aggregator, there are naturally opportunities where one could take advantage of liquidity pairs across the ecosystem to create arbitrage. Since February 1st, what percentage of all swaps (with a size of at least $100) where a wallet starts the transaction with USDC or USDT and ends the transaction with either USDC or USDT have resulted in at least a 1% gain? Are there any patterns behind the most common sources of arbitrage on Jupiter? List the top 10 wallets in terms of total arbitrage gains and provide insight over their strategy.
Getting Started with Terra Bounties (Mandarin)(March 1)
Mar 2, 2022 - In response to find all delegations to Flipside that happened on the day you did the Terra Scavenger Hunt, and highlight your delegation among all the others.
Algorand Stablecoin Popularity USDC vs USDT
Feb 10, 2022 - In response to Question 17: Now that xBacked(a decentralized stablecoin: https://www.xbacked.io/) is in testnet, let’s take a look at two of the biggest stable coins on Algorand: USDC and USDT. What’s the number of people who currently hold USDC vs USDT? Create a time series chart counting the number of transactions a day for each stablecoin. Create 1 chart for each stablecoin visualizing the current distribution of holders. Does one have a better distribution than the other? If so, explain why.
Song That Own Itself(STOI) Airdrop #3
Apr 7, 2022 - Q44. Let's look at how many wallets have claimed the STOI Song #3 “Million Scars” Airdrop. How many users have claimed the airdrop? Chart the STOI Song #3 airdrop token distribution by day.
Swap Fees
Jun 25, 2022 - Q21. 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?
Coinbase Adds SOL Ecosystem Coins
Feb 13, 2022 - In response to Question 10: On January 31st, Coinbase added two Solana ecosystem coins to its listings: Bonfida and Orca. Create a visualization that shows the amount of FIDA and ORCA transferred from within wallets in the ecosystem to Coinbase. Did transfers spike right after the listing, or has there been continued volume?
ASA Asset Transfers
Apr 7, 2022 - Q41. 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? Create a table using the asset_transfer_transaction table that show the top 10 assets by number of transfers since February 2022. Chart these transfers over time by day as well. Create a table using the asset_transfer_transaction table that show the top 10 assets by number of wallets that initiated a transfer since February 2022. What announcements and events could have led to the popularity of some of these assets?