banbannard
Weighted-Average LP Duration
May 4, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP?
New NFT Collections on Solana vs Ethereum
Sep 13, 2022 - Layer 1 War between Ethereum and Solana
Sushi on Polygon
Mar 21, 2022 - What are the 10 largest sushi liquidity pools on Polygon? What is their volume and TVL?
Bots and success rate
Apr 26, 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?
wETH & wBTC On- and Off- Ramps
Jun 6, 2022 - On the Osmosis Frontier, there are pools for wETH and wBTC. How do users respond and change their position in these pools in response to governance proposals involving extra incentives for these pools? Do their deposits and withdrawals of wBTC and wETH onto Osmosis change as well?
Getting Your Feet Wet, Part 2
Mar 6, 2022 - Assess the extent to which new users interact with each of the following projects. For Definition, clearly define what “interact with” means, e.g. “at least 1 transaction”, “at least 5 transactions”, etc. Anchor, Mirror, Pylon, Astroport, Terraswap, Prism, Mars
A Comparison Between Avalanche and Ethereum
Nov 29, 2022 - A Comparison Between Avalanche and Ethereum
Bot Activity
May 14, 2022 - Create a way of identifying bots within THORChain (could be something like a certain number of swaps / day made). What % of the swaps and swap volume are made by bots? Are there certain strategies you can see them employing (most of them are likely arbitrage bots)? Are there many bots or mainly just a few that conduct a high % of bot activity?
Metaplex Bot Free
May 7, 2022 - The summary is that bots will now have to pay a .01 SOL penalty for every transaction. Since this was implemented on April 29th, how many bot transactions and thus how much SOL has Metaplex captured? Display when these transactions occurred over time and if there were certain wallets that have been discovered to be guilty of botting the network.
Coinbase Adds SOL Ecosystem Coins
Feb 13, 2022 - On January 31st, Coinbase added two Solana ecosystem coins to its listings: Bonfida and Orca. Create a visualization that shows the amount of FIDA and ORCA transferred from within wallets in the ecosystem to Coinbase. Did transfers spike right after the listing or has there been continued volume?
Tracking top Solana NFT Collections
Apr 27, 2022 - Track sales volume and average sales price across marketplaces for the following NFT collections. How much wallet crossover is there between some of the top collections? How much wallet crossover is there between some of the top collections? What is the average time between buying and selling for each collection
Terra Altcoin Behavior
Feb 5, 2022 - Select a Terra “altcoin” (i.e. not LUNA/ANC/MIR) and assess their performance over the past 90 days, using a metric of your choice (examples: price, number of transactions, volatility.) What do you think are the prospects for your chosen altcoin?
Votes, Votes, Votes
Apr 20, 2022 - On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
Anchor bETH Collateralization
Mar 30, 2022 - Q6. Quantify the amount of bETH provided as collateral in Anchor Protocol. Note any trends or changes in user behavior in the last 90 days. Based on your results, should the bETH borrow limit be raised to 70% LTV? Include relevant data or visualizations to support your claim.
Learning Gnosis
Jul 31, 2022 - Let's learn about Gnosis together by looking at some Gnosis data and statistics!
Mind Your Ps and Ys
Mar 27, 2022 - Make your case for the relative value of pLUNA or yLUNA! Define the key inputs to the relative valuation for each; various methods of valuation (discounted flows, comparables, growth-based models) will be accepted as long as you make a reasonable case for them and support them with evidence.. Over a time period of your choosing, how has pLUNA or yLUNA’s price changed as these key inputs have changed?
Moonbirds Mint Analysis
Apr 20, 2022 - What was the distribution at mint? How many wallets minted? Who minted the most?
Lido Whales
Jun 1, 2022 - Identify the top Lido whales. What percentage hold stETH vs wstETH? What percentage among the holders have deposited their token into pools for extra yield?
Top Kashi Pairs (II)
May 16, 2022 - Find the top 5 Kashi pairs on Ethereum based on the number of loans they have given out so far. Choose one that you like, and describe the following information: How many people are lending on this pair at the moment ? How much each user is lending at the moment?
Bridge Transactions (Across)
Jun 22, 2022 - Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains?
Forefront Holder Distribution
Mar 27, 2022 - Create a histogram of token ownership amounts to understand the percentage of holders that buy tokens to provide access to these tiers. Where are token amounts most commonly distributed? In your opinion, does this token model make more or less sense than say gated NFT ownership? Why?
Super-Sized Swaps
Feb 2, 2022 - For each pool, what is the largest single swap it has processed? You can either do the largest denominated in token amounts or USD value.
Stargate TVL Metrics
Apr 25, 2022 - Show how the Total Value Locked (TVL) of Stargate on Ethereum has changed since its inception. What percentage of the TVL is made up by each token staked on Stargate?
stETH Most Common Pools
Apr 25, 2022 - Use the ethereum_core tables to 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?
First Time Deposits at Mango Markets
Feb 19, 2022 - How many new trading accounts have been created by users since February 10th? How much SOL has been transferred into Mango Markets (don't count the one time fee) since February 10th from first time deposits? What was the average deposit amount? Create a visualization showing these trends over the time specified.