jackguy
THORChain and $vTHOR Overlap
May 23, 2022 - Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards.
Standardized TVL over time (all pools)
Apr 18, 2022 - Traditional TVL metrics are imperfect because they are influenced by both the quantity and price of the tokens over time. We would like to see a version of this metric that abstracts out the price influence on this metric.
The call is coming from inside the house
Dec 11, 2021 - The sushi price briefly spiked on December 8th. Determine if the price jump was driven by dex trades (as opposed to off-chain trades) by looking at trades in any SUSHI/WETH, SUSHI/USDC and SUSHI/USDT pools on Uniswap and Sushiswap on that day.
Top LDO Holders
May 31, 2022 - Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
stETH Most Common Pools
Apr 27, 2022 - determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
Stablecoin Total Supply
Sep 3, 2021 - Make a visualization that shows the total circulating supply of each pegged currency in the Terra ecosystem over the past 6 months.
Scanner Sweep
Apr 7, 2022 - What metrics are most usefull in determining the health of the Terra Ecosystem. What is effective about these metrics of the Terra ecosystem? What would you add or change to make your chosen submission(s) an even better resource for LUNAtics?
Sushi Farming
Apr 6, 2022 - How many farms are there on Ethereum, Polygon and harmony. And what is the TVL per farm? which farms offer the most TVL? How has this changed over time?
Terra -> Osmosis
May 22, 2022 - Are Terra projects interested in migrating over to Osmosis? What is most important to Terra developers when looking for a chain to migrate to and why might Osmosis be a good choice?
Whale Dependency Index
Jan 21, 2022 - Which of our pools are highly dependent on whales….because lower number of wallets associated with the highest liquidity pools will tell us this for each pool. This type of info can help us figure out our own “whale dependency” index, which could help guide us on how to best allocate farming rewards. In general, do we want to keep one whale happy or is it better for us to keep a lot of farmers happy?
IL Protection Over Time
May 15, 2022 - With highly volatile prices recently, more IL protection has been paid out on THORChain. How do recent days or weeks compare to historical amounts?
Loop Liquidity Pools
Oct 19, 2021 - What Loop liquidity pools are people using and how often are they using these pools.
Tinyman Assets
Jan 12, 2022 - Before the Tinyman hack, what were the most popular assets to swap with Algo in the Tinyman Dex[App ID 350338509]? Does the average amount of algo swapped changed based on the asset that it was swapped for?
Around & Around We Go
Feb 20, 2022 - Display the circulating supply of LUNA over the past 3 months. Use on-chain data for your calculation, but you are welcome to reference outside sources to support and validate your answer.
Terra LFG
Mar 11, 2022 - Create a dashboard that updates daily to display the Luna Foundation Guard yield reserve. As well, provide at least one visualization and one metric that you think is related to the yield reserve’s growth or depletion.
ETH Price Drop affect on Uniswap liquidity pools
Jun 24, 2021 - With ETH dropping below $2000 how is it affecting the liquidity pools for ETH? Are people decreasing liquidity of their v3 pools and re-entering it in a new range or are they staying put? With the people who are decreasing liquidity and not coming back in are they holding the amount they took out of their positions or are they moving it to another DEX pool (Sushi, Uni v2)?
Calls vs. Puts
Feb 5, 2022 - Ribbon offers both covered call and put-selling automated strategies. Between its four main pools (ETH and BTC covered calls, yvUSDC-ETH, USDC-ETH puts) what is the most popular strategy by TVL? Are put-selling strategies or covered calls currently more popular? Has that trend always been the case? Create a visualization showing this trend. Why do you think that is?
Anchor Repayments
Jul 10, 2021 - How much is being repaid in loans on Anchor? How much UST debt is outstanding?
Uniswap Volume Projections
Aug 16, 2021 - What is going to happen to Uniswap swap volume in the coming quarter?
Stablecoin Swappers
Jan 9, 2022 - Show the number of users swapping between stablecoins on Curve every day for the past 90 days. Which stablecoin pairs generate the most volume? Why might this be?
Algomint Bridge
Jan 24, 2022 - Algomint is a centralized bridge that allows you to wrap your BTC and ETH to use in the Algorand ecosystem. They custody your BTC and ETH in return you receive goBTC and goETH. When the goBTC and goETH is ""minted"" by a wallet it is distributed from ETGSQKACKC56JWGMDAEP5S2JVQWRKTQUVKCZTMPNUGZLDVCWPY63LSI3H4 to the Algorand wallet. When a wallet wants to ""redeem"" their goETH and goBTC for their original asset, they send it back to the wallet it was distributed from. How much goBTC and goETH is currently in circulation? How much goBTC and goETH has been minted by users over time? How many wallets have minted goBTC and goETH? How much goBTC and goETH has been redeemed by users over time? If a user redeems their goBTC and goETH for their original asset do they redeem the whole amount or only a portion? Bonus: What is the average hold time for goBTC and goETH if a user does redeem their original asset?
Distributed Validator Technology
Apr 13, 2022 - Explain what Distributed Validator Technology (DSV) through the Obol network is and why it might help with decentralization on Ethereum 2.0 or other Proof-of-Stake chains.
Trend of Pools
May 18, 2022 - What kind of pools do user usually withdraw or deposit into for the last 90 days? is there any pattern/trend we can see from it?
Biggest Losers
Jan 21, 2022 - Who lost the most upside by redeeming their PEOPLE tokens instead of selling them? Build a future proof query that shows how much they would make by selling them now. Build another query that shows how much they would have made if they had sold the top (if we reach a new high, the query should identify that as the new top)
Historic bAssets Price Movements
Oct 11, 2021 - What is the most bLuna has dipped in a X second window (based on bLuna price oracle timing)? Focus on the events of the Black swan event in mid-May. Make the default size of the window 30 seconds. - How much has bLuna drifted from its Luna peg? - How much has bEth dipped in a 30-second window - How much has bEth drifted from the Ethereum Price
New User Activity
Feb 11, 2022 - For new users, what is the most common first program that users interact with on Solana (as in what is the most popular first transaction for a new wallet)? What is the average number of transactions a "new wallet" makes in their first 24 hours? (New wallet defined when a wallet makes its first transaction). Do you think this is more or less than other chains? Note: Limit this analysis to the month of February.
Active Addresses
Jun 4, 2022 - How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related some how to the price?
What percentage of CVX lockers are re-locking their tokens
Feb 25, 2022 - Display not only the percentage, but select a time period of your choosing and provide a brief analysis of what you think might impact the decision to re-lock tokens.
ENS vs Gas
Dec 11, 2021 - ENS registration is cheap, but gas is not. Do more people register domains when gas is lower? Was there a spike in registrations when during recent ETH price dips?
Whale Transaction Volume
Feb 4, 2022 - Question 35: Show the daily swap volume of wallets with over 1 million Sushi tokens. How has this volume changed over time? How has the number of ‘whales’ changed over time?
Increase/Decrease Liquidity Frequency for Uniswap
Jun 17, 2021 - How many times have unique wallets increased liquidity (using lp_actions) in the past week? How about decreased liquidity?
DAI on the Market
Jan 18, 2022 - Analyze large shifts in the amount of DAI on the market over the past year. What might have caused these shifts? Are these events related to Maker directly? Are they related to the crypto ecosystem as a whole? Provide metrics to support your analysis.
User Growth Per Sector
May 4, 2022 - What sectors / Apps are driving user growth on Terra ?Choose the top apps per sector (DEXs, Borrowing, Staking, NFTs ...) and create a dashboard of user growth per sector and App. Are there any sectors / apps that are driving more user growth than others?
Borrowing On Folks Finance
May 18, 2022 - Let’s look at borrows on Folks.Finance a borrowing and lending protocol built on Algorand. We want to get an understanding of how what assets users most want to borrow, how often borrows are happening, and the average collateral ratio between the collateral offered and the asset that is borrows. Ultimately, we want to get a better understanding of what people are borrowing, and what the collateral ration looks like.
Terra NFT Trading Volume Trends
Feb 9, 2022 - For the 10 most popular project on RandomEarth, what projects have seen the greatest increase in volume in the last 30 days? (LUNA + UST figures) Create a visualization showing percentage change in volume over the past 30 days for these projects. What projects seem to be trending and what seems to be fading?
Moonbirds Mint Distribution
Apr 22, 2022 - What was the mint distribution of the Dutch Auction? Plot the distribution at various price points and/or the mints over time with the cost.
% of Solana Staked
Feb 12, 2022 - Using the "Events" table, what percentage of Solana that has been transacted is staked? How has that percentage changed throughout the month of January? Create a visualization showing % SOL staked over time. What is the average amount of Solana staked during a staking transaction?