mehrancrypto-H2EvNK
Bridge Users (Hop Protocol)
Jun 18, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Price + Circulating Supply
Jun 8, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Getting Started With Terra Bounties 2.0
Feb 11, 2022 - At first we summarize monthly UST deposits to the anchor protocol. anchor is a lending and savings protocol on the Terra blockchain
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.
New Wallets In May
Jun 16, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May? How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap? Finally, note anything else interesting about these wallets! Why are these wallets being created and what are they doing on Algorand?"
HODL or Sell
Apr 6, 2022 - In a time period of your choice, 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?
Does Time of Day Affect Price?
May 12, 2022 - Crypto does not follow a 9-5 schedule, but some traders may take advantage of different time zones. Using the Prices Swap table is there an hour (or hours) of the day that more frequently exceeds or falls short of the average of the day. Find the top 10 assets that are swapped to, then use the prices swap table to see if the hour of the day has an affect on the price Create a visualization that shows the impact on price based on hour of the day
Let it burn!
Apr 27, 2022 - Find the week that the most volume of Luna burning happened. What caused this event? Show some effects of this burning had on Terra ecosystem by your opinion.
Flow Scavenger Hunt (Vietnamese)
Mar 11, 2022 - Làm quen với Hệ sinh thái dòng chảy
Getting Started With Terra Bounties (Vietnamese) (March 24)
Mar 25, 2022 - Đáp lại: tìm tất cả các giao dịch ủy quyền LUNA cho Flipside vào ngày bạn hoàn thành Terra Scavenger Hunt, tạo biểu đồ trực quan hóa các giao dịch đó và đánh dấu giao dịch ủy quyền của bạn bằng một màu khác.
Pricing ASAs
May 12, 2022 - 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. Part One: Using the Price Swap table, pick a single day in the last 30 days and find the top 5 most and least expensive ASAs Pick an hour in that day and visualize the distribution of prices across all ASAs for that hour. Tip: filter the results by SWAPS_IN_HOUR to only include ASAs that had at least one swap in that hour Part Two: Find the top 10 ASAs by volume in the last 90 days using the VOLUME_USD_IN_HOUR. Which had the highest average volatility? Which was the most swapped? Tip: Take a look at the other numeric measures, outside of the price, within the Prices Swap table
ETH Staked
Apr 5, 2022 - 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?
Bots and success rate
Apr 27, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
Terra Scavenger Hunt (Farsi)
Feb 11, 2022 - ابتدا با پولی که داخل کیف پول است مقداری لونا میخریم. در ادامه آن را دلیگیت(استیک) می کنیم.
Stablecoin Arbitrage on Jupiter
Mar 21, 2022 - 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.
stETH vs. ETH
Apr 6, 2022 - How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
Algorand Foundation New CEO Staci Warden
Mar 18, 2022 - 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?
Bridge Volume (Hop Protocol)
Jun 19, 2022 - Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? What is Hop’s total TVL? Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.
Forefront Participation Incentives
Apr 17, 2022 - Q4. Compare the incentives for participating in Forefront with at least two other social tokens/DAOs of your choice citing two metrics of your choice. In terms of payout opportunities and upside, does the S2 Forefront seem optimal for encouraging development? Create a dashboard showing payouts aggregated for each role type and if each role has influenced what contributors do with their payments? What are some methods that would encourage payments to be reinvested into Forefront besides just time?
HODL or Sell
Jun 15, 2022 - In a time period of your choice, 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?
Bot Swappers
Apr 27, 2022 - Define bot swappers. How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. What percentage of swaps were executed by bots in the past 30 days? What pools and what pairs were most popular among bot swappers in the past 30 days.