Algorand Week: Gard + Yieldly 2022 Yieldly Staking Pool Analysis
May 20, 2022 - in this work we want to find the most popular Yieldly staking pools by Amount of YLDY staked, Total number of stakers, Average amount staked, number of addresses participating in Yieldly staking Pool in 2022, wallets participating in staking pools but committing less amounts, ALGO price impact the number of users participating and staking pools and find standout wallets that have staked in a lot of these Yieldly staking pools
Swapping for YLDLY on DEXs
May 20, 2022 - Q77.Show us the total volume inflow and outflow of Yieldly(YLDY: Asset ID: 226701642) by day in 2022 then break it out by DEX as well. Is swapping for YLDY more popular on some DEXs than others? Additionally what assets are users swapping for YLDLY? Are there any standout days of swap volume for Yieldly? If so, write about what may have caused that spike. Note any other interesting findings related to YLDY swaps! Description of work: to calculate total volume inflow and outflow of Yieldly, we use algorand.swaps table and SWAP_TO_ASSET_ID and SWAP_FROM_ASSET_ID column to identify inflow and outflow. to calculate assets that users swapping for YLDLY, we extract records that have SWAP_TO_ASSET_ID = 226701642 to identify users swapping for YLDLY, then we join extracted records on algorand.asset table to find asset names that swapping for YLDLY.
NEAR - 18. Social Dashboard
Mar 5, 2023 - Analyzing Near Social protocol from different aspects.
Ecosystem or Project Analysis
Feb 12, 2023 - Optimism is explored in this dashboard. The examined parts include market performance, network performance, inflow and outflow on bridges, and fees spent.
Algorand -New Wallets from NFTs
Jun 9, 2022 - Q99. Let’s look at the month of May and June to understand if the Algorand NFT scene is onboarding new wallets. For this we want to focus on wallets that have >1 ALGO and look at two different groups all wallets >1 ALGO and wallets created in May and June with >1 ALGO. Also note we only want to look at arc69 NFTs.
Solana - Smart Money NFT Traders
Jun 3, 2022 - Check the status of Solana NFT traders and find smart money and NFT Whales.
Solana Bounties It's the Catalina Whale Mixer
May 13, 2022 - Catalina Whales are a popular NFT collection on Solana with an experienced team from the entertainment industry. Chart their sales history and unique holder trends over time.
Sushiswap Bounties (Sushiswap DEX Loyal Users)
May 6, 2022 - Description of work: Rank wallets that used SushiSwap based on the number of trades and number of days they used the DEX. to answer questions, for rank wallets based on trades, we find all swaps done last month on Sushiswap DEX using ethereum_core.ez_dex_swaps table. Then we join the result on ethereum_core.fact_transactions table on tx_hash field to find the number of trades and we get the number of trades for each address based on the transactions that have been successful. for rank wallets based on trading days, we do calculations like part 1 but with differences in grouping results. finally, we define loyal users and calculate number of loyal users on Sushiswap.
Algorand - Let's look into stablecoin data on Algorand
Jun 1, 2022 - In this work, we examine the stablecoins on the Algorand Blockchain.
Sushiswap Bounties(Trend of Pools)
May 13, 2022 - Description of work: What kind of pools do users usually withdraw or deposit into for the last 90 days? is there any pattern/trend we can see from it? To do this, we first extract pools in which successful transactions over the past 90 days have been performed in Sushiswap. then we group these records based on pools and days. Then we extract the top 5 pools in terms of deposit / withdraw.
Algorand Bounties
May 3, 2022 - goMint was launched on Algofi, Tinyman, and Pact on March 30th, 2022. goMINT, is the first Algorand-native three-way listing so let's look at the performance of the goMint release between the 3 DEXs. Description of work: Question 1: calculate the volume of ALGOs swapped for goMint by day on each DEX (Algofi, Tinyman, and Pact) since the token release Question 2: calculate the number of swaps and the number of wallets by day by DEX (Algofi, Tinyman, and Pact) for goMINT/algo swaps in the first week of the token release. Question 3: In the first 24 hours of the token release- chart the average swap price in ALGOs for goMint across each DEX(AlgoFi Tinyman Pact). Do we see a higher average price for goMint on any of the DEXes? Question 4: Note any other interesting findings between the DEXes related to the release of the goMint and the goMint/algopools, such as volume, number of swaps, or number of wallets swapping.
Terra Bounties(Active Wallets on Terra)
Apr 30, 2022 - Description of work: In this question, we first provide a definition for active wallets on the Terra blockchain. Then, based on this definition, we calculate the number of active wallets in the days and months of 2022 and show them in a chart.
Terra Bounties(LUNA Market Cap)
May 6, 2022 - Back to basics! Display the LUNA price and market cap trend over 30, 60, 90 days; the past year; and all time.
Market volatility
May 27, 2022 - The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety
Algorand Bounties (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?
Sushiswap Bounties (Trident)
Apr 30, 2022 - Describe using a visual document how Sushi's Trident works and compare, if possible, with other similar products in Defi.
Solana - Saber Proposals & Gauges
May 28, 2022 - Q79. Create a visualization showing the total amount of SBR locked over time and voter participation rates.