berta
Trend Analysis
Apr 4, 2022 - Q63. Analyze the trend of active users and number of swaps for sushiswap and draw a comparison with Uniswap. Describe the trends that you see
The Nightmare Scenario
Apr 22, 2022 - Q183. Recently, attacks have been leveled against Terra, suggesting that it is doomed to collapse as UST reaches unsustainable levels. Specifically, concerns have been raised that at a low enough LUNA price, users will no longer be able to redeem $1 of UST for $1 of LUNA.
LUNA Distribution Mvmt 1
Jan 27, 2022 - People who do not like crypto often cite wealth inequality as a reason: they claim that the tokens are concentrated in the hands of a few whales. Assess this claim for LUNA. How much of circulating supply is held by the top 100 addresses? Top 1%? Top 10%?
MonkeDAO Validator
Feb 20, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. 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.
Bot Swappers
Apr 28, 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.
Untitled Board
Dec 3, 2022 - Since the $AXL token launch, how have wallets that bought $AXL used it? Are most wallets hodling or trading? What is the average holding period for wallets buying $AXL in the last month? Generally speaking, have users kept $AXL on exchange (in their Osmosis wallet) or have they bridge to other places? Analyze $AXL balances on Osmosis as compared to native on Axelar. How have these balances changed over time?
Untitled Board
Nov 10, 2022 - What does the average Optimism user's portfolio look like and how has that changed over time? What % of a user's activity (in OP terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed over time?
16. UNI Market Correlation
Apr 2, 2022 - Does the price of UNI correlate with the price of ETH? Compare this with the correlation of UNI to other DEX coins (such as AAVE, SUSHI, or anything else you find suitable)
wETH & wBTC On- and Off- Ramps
Jun 7, 2022 - Q9. 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?
Dai on the market analysis
May 19, 2022 - Q3. 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.
Untitled Board
Nov 2, 2022 - What is the volume of ETH and three stablecoins of your choice that's moved between the Optimism network and the Ethereum network across the bridge? How has that changed over time? Note any interesting trends or outliers that you see.
Terra Builder
Mar 2, 2022 - Terra Q156: Imagine you are a Terra Developer. What are your main pain points? What tooling, services, and resources would make you more productive? Describe at least 2 pain points that make building on Terra more difficult (these can be technical but non-technical pain points are also acceptable). Describe at least two (2) services/tools/capabilities that would address these pain points. Provide a concise explanation for each of them and the value they would unlock. For example: Graph queries for Terra NFT index for Terra like Open Sea API used on Ethereum Terra Developer documentation For each capability you describe, provide a real-world example from another ecosystem and show how it enables/empowers developers in that ecosystem (can be another blockchain, but non-crypto examples are also acceptable).
Votes, Votes, Votes
Apr 22, 2022 - Q185. 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?
Killer Crossover, Mvmt. I: LUNA/Solana
Feb 24, 2022 - Question 149: Friktion on Solana offers a “covered call” strategy for numerous assets, including LUNA. This strategy’s overall return depends on how often the call options are exercised, i.e. how often LUNA ends up above the strike price of the option. Determine how many weeks during the past month that LUNA’s price has increased more than 15% in a 7-day period. Based on this performance, what insights or implications can you draw about the true profitability of a LUNA covered-call strategy?
Untitled Board
Dec 7, 2022 - The ACX airdrop took place this week. Create an analysis of the Across protocol bridge volumes, airdrop distribution and TVL. In light of the Bored Ape Yacht Club's introduction of Staking, provide an analysis on the token and project. Provide data on APE token distribution in March 2022 and show how the activity has evolved since. Share analysis on future emissions schedule. How have the first hours of APE staking been? How do the staking rewards for each pool compare? Provide any relevant data.
Weighted-Average LP Duration
Apr 29, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP?
Untitled Board
Nov 5, 2022 - A war of the trading platforms? GMX (native to Arbitrum) - GNS (native to polygon, but announced will be launching on Arbitrum soon). Both platform native tokens (GMX - GNS) have seen meteoric price growth during a bear market. Since June GNS has gone from $0.68 to $3.68 and GMX has gone from $13.70 to $41.56 Observe Trading volume. Has one platform absorbed more volume than the other? How impactful is GNS volume to polygon? GMX volume to Arbitrum? Are there any insights that can reveal why Gains Network wants to move into the Arbitrum ecosystem? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Transaction Failure
Mar 20, 2022 - Q169. Make reference to this tweet: https://twitter.com/alphaDefi_/status/1504522066674003972/photo/1 Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
Question 63: Profit for AMMs
Apr 14, 2022 - Q63. What is the total profit (in dollars) per day that is generated from swaps out of the liquidity pools in 2022? Do you see a trend? Can you compare sushiswap with Uniswap?
Cross-chain Anchor
Mar 29, 2022 - Q7. Compare the Earn sides of Anchor protocol on Terra vs. Avalanche. What does the Earn side look like on Avalanche? In the last week, are people using it more? Is there more volume? Hint: Here's an example deposit transaction from Avalanche, which you can look up in the terra.msgs or terra.msg_events table: F808E26CA0D243AC5E997949EA0861B0209EBEA4E41516CB738B1E3ADB1FD8AB
DEX Change
Nov 17, 2022 - What does the average Optimism user's portfolio look like and how has that changed over time? Earlier this year, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs? Feel free to provide any information that you think is related to token price.
32. - Whales Comin’ and Goin’
Feb 1, 2022 - Define a whale. Show the number of whales leaving liquidity pools on Sushiswap each day over the past 2 months. Do the same for the number of whales entering liquidity pools.
Moonbirds Crossovers
May 5, 2022 - Are there any notable cross overs between the Moon Birds community and other communities? How many holders also have BAYC, Doodles, etc
Untitled Board
Jan 5, 2023 - A retrospective on the NFT market in 2022. NFT project with the highest volume of trades in 2022? Which NFT project had the largest mint by dollar? Which NFT project decreased the most in value this year? Which NFT project gained the most value this year? What was the price of the highest-selling individual NFT? Which NFTs had the longest hold time this year? Which NFT project had the least amount of NFTs listed for sale on an exchange? Which project had the most NFTs listed for sale on an exchange?
Untitled Board
Dec 12, 2022 - Governance in the Cosmos Hub has gotten spicy, to say the least. Despite gaining the support of some of the most influential names in the space, Prop #82 was rejected after more than 1/3 of voters chose "NoWithVeto". Take a look at governance behavior surrounding Proposal #82 - specifically first time voters and vote switching. Is it possible to identify any key "swing voters" (ie ATOM whales or influential validators) that really turned the tide of the vote? Were any of them first-time voters? What is the average wallet size (in ATOM) of the people voting? Of the people who changed their vote? Further, is Prop #82 significantly different than other proposals from an engagement perspective? Analyze voting for Cosmos #82 vs. other recent governance proposals in the Hub. Has overall governance participation increased or decrease since Prop #82? Finally, have ATOM holders re-delegated their staked ATOM as a result of the vote? Highlight any interesting patterns in re-delegation activity.
Untitled Board
Nov 13, 2022 - What does the average Optimism user's portfolio look like and how has that changed over time? Earlier this year, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs? Feel free to provide any information that you think is related to token price.