What are the top 5 most swapped assets on Harmony by volume and number of transactions?
Mar 12, 2022 - What are the top 5 most swapped assets on Harmony by volume and number of transactions? Present a dashboard with insights and thoughts
LUNA Price Volatility
Jul 31, 2021 - What has the daily volatility (standard deviation of price day over day) of LUNA price been over the past 2 weeks? How does that compare to the volatility of ETH over the past 2 weeks? What are events and/or factors potentially impacting these?
Governance
Jul 10, 2021 - How many smaller voting power addresses are voting vs. larger voting power addresses? Please include your defintion of larger vs. small.
Swing and a Miss
Feb 13, 2022 - In honor of the Terra <> Washington Nationals partnership, the Wormhole team is interested in “hit rate”: the percentage of successful vs. unsuccessful transactions. Create a Sankey diagram displaying failed transactions on Wormhole, selecting either starting chain or ending chain (or both). Briefly summarize the failure rate of transactions between blockchains.
Where’s The Pot of Gold?
Mar 19, 2022 - What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is.
MonkeDAO Vote
Apr 5, 2022 - Track the wallets that voted yes and no for the SMB proposal. What were people's voting preferences based on the number of SMBs that they owned? What have these wallets done with their SMBs since the voting? Was the nearly unanimous voting a bullish event? Have wallets that voted yes bought more monkes? Were those who voted no more likely to sell after the fact and on which marketplace? What percentage of all monke sales involved a selling wallet that voted at all?
New Validators - Last 60 Days
Dec 11, 2021 - how many new validators have been delegated to in the last 60 days? -What validators have gained the most traction in the last 60 days? -Why might these validators be gaining attention, why are people delegating to them?
Distance between LP position bounds
Jul 24, 2021 - What is the distance on average between the bounds of LP positions on the top 10 pools? Is this impacted by position size? Do larger positions tend to have larger bounds?
Release of AlgoDex
Feb 23, 2022 - AlgoDex launched on Feb 9, 2022, let's look at the performance of AlgoDex's first day:
MonkeDAO Validator
Feb 18, 2022 - How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
Algorand Unique Users Growth
Feb 7, 2022 - Chart how many unique wallets are added each day(Tip: Use the Account Table) Do we see an increase in wallets created during the governance commitment periods compared to non governance commitment times? Governance Commitment Period 2: September 20th 2021 - October 14th 2021 Governance Commitment Period 2: Dec 24th 2021 - January 7th 2022
Gainers and Losers
Jan 11, 2022 - Sort all of the liquidity pairs in terms of each of the following categories: fees in USD gained over the past 24 hours, volume in USD gained over the past 24 hours, and liquidity in USD gained in the past 24 hours. Repeat this process for the top 10 losers for each of the same categories.
End of Year CEX Transfers
Jan 19, 2022 - Did the volume of transfers to centralized exchanges increase towards the end of December compared to the volume of transfers at the beginning of December? (Hint: you will need to use the "Labels" table). Create a visual to show the trend of these transfers in the month of December. Based on the trends you discover, give some reasoning to why this occurred.
What Happens to the Loot
Dec 20, 2021 - Analyze to what extent Anchor stakers are selling their ANC rewards. What factors correlate with selling behavior vs. hodling behavior?
Marinade's Non-fungible Chefs
Apr 20, 2022 - Marinade Finance officially launched their protocol governance system on April 4, 2022. In order to participate in governance, holders of the protocol's native MNDE token lock their tokens in exchange for an NFT.
Marinade's Non-Fungible Chefs
May 2, 2022 - Marinade Finance Non-fungible Chef NFTs began minting on April 4, 2022. How many unique holders of the NFTs are there? Create a chart showing trading activity and SOL volumes on Magic Eden.
Average Trade Sizes
Sep 3, 2021 - What are the average trade sizes across the top 5 assets by volume traded with native Terra swaps currently?
LUNA Distribution, Mvmt II
Feb 5, 2022 - What is the distribution of LUNA for active wallets (i.e. wallets with at least one transaction in the past 90 days? What is the distribution of LUNA if wallets that have never transacted are excluded?
Impacts of Price Changes
Dec 26, 2021 - The Sushi token has been trending downwards in price for the month or so. How do the changes in price affect trade volume? How do they affect number of users staking and amount staked?
Fee Volatility
Aug 15, 2021 - What has the day over day change in fee generation been for Uniswap V3 over the past 1 month?
Anchor Borrows and Deposits
Dec 25, 2021 - How have the average and total borrows and deposits on Anchor changed over time?
How is UST Being Used?
Jul 1, 2021 - What are the main uses of the UST stablecoin on Terra? Is UST being used on protocols/apps or with centralized exchanges? Look at both volume and number of transactions.
Bonded vs. Unbonded LUNA Amount
Aug 28, 2021 - Visualize the amount of bonded LUNA vs unbonded LUNA there has been in the Terra ecosystem over the past 6 months. Has it remained fairly stable or is it volatile? Are you able to tell patterns of when people unbond their LUNA?
xSushi
Jan 24, 2022 - Explain the mechanism behind xSushi. Show the total supply of xSushi over the past 3 months. How does this relate to the total supply of Sushi over the past 3 months?
Self-Validating
Jul 25, 2021 - For the top 5 validators, what percent of the LUNA that they hold is their own as opposed to delegated to them? Has this proportion changed over time?
Stablecoin Pegs
May 12, 2022 - How have USD-pegged stablecoins across different chains, and with different backing mechanisms, fared through the last 5 days? Compare volume, peg stability, and any other metrics you think are relevant, and present a dashboard the summarizes your findings and conclusions.
ALGO Transaction Payment Size
Mar 31, 2022 - Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current.
Out of Range Positions
Aug 22, 2021 - Visualize the proportion of active positions on Uniswap V3 that have been out of range vs. in range daily since the launch of Uniswap v3.
Tinyman LP Actions
Mar 4, 2022 - - Show the number of mint and burn actions each day. - Create a table of the LP pools with the most mint and burn actions
Friktion SOL vs mSOL Volts
Feb 19, 2022 - 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?
Lets Get Rich Together
Dec 21, 2021 - This dashboard will show ETH holder two ways that they can use their ETH to get yealsd on sushiswap with more and less return/risk.
Mirror & Anchor TVLs
Aug 1, 2021 - How have the TVLs on Mirror and Anchor changed over the past two weeks? Are there any correlations that you can see? What might be some reasons for these relationships?
Governance Reaction to Terra
May 22, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals?
