Zanyar_98
Algorand New Wallets In May
Jun 16, 2022 - How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May?
NFTx User Activity
Jun 14, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults.
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.
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
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 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
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.
Osmosis Privacy Coins + Politics
Jun 14, 2022 - Do major news events result in more people swapping to SCRT?
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.
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.
Paraswap Bounties (New Active Users)
May 6, 2022 - Description of work: Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months. First, we extract the DEX Paraswap addresses. Then we extract the addresses that made the transaction using Paraswap. Finally, we extract the wallet addresses that have made a transaction using Paraswap in the last 2 months.