CryptoIcicle
Solana-50.Magic Eden Whales
Apr 10, 2022 - Track the top 20 wallets in terms of sales volume on Magic Eden since March 1st. What have these wallets been buying and selling the most over that time period? As in, which collections seem to have their attention? Do these wallets tend to ""sweep"" (buy a lot of the same collection at once) or patiently buy collections? How often are these wallets buying vs selling NFTs and what does their profit look like?
Wallet Balances & Ecosystem Growth
Oct 26, 2022 - -- With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. -- Provide insights into following metrics: -- How has the ratio of liquid to staked OSMO changed overtime? -- Are the top 100 OSMO holders the same now as they were at the start of the year? -- What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. -- Do wallets normally hold a majority of OSMO, or another token? How has this changed over time? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Solana-46.Saber Locked Over Time
Mar 26, 2022 - Q46. Review the scavenger hunt (dropping Monday!) on veSBR for an explanation on the Saber Wars! Create a visualization showing the amount of SBR locked in governance over time since January 1st. Are there any notable trends on when SBR has been locked or wallets have exited from their locked positions? For example, have there been certain dates when we can expect there to be more locking activity than others? Provide some insight on locking behavior.
Terra: 138. Lockdrops Keep Fallin’ on my Head
Jan 22, 2022 - -- Explain, in your own words, what a “lockdrop” is. -- Choose a metric for ASTRO tokens (price, circulating supply, amount sold vs. HODL) -- and display it visually over a time period of your choosing.
MARS Protocol Lockdrop Hunt
Mar 3, 2022 - -- Provide UST into the MARS-UST Bootstrapping Pool
Terra-169.Transaction Failure - Reason
Mar 21, 2022 - 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.
Algo-77.Rand Gallery Wallets
May 26, 2022 - Q77. Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior. How many wallets are buying NFTs on rand gallery. What is the total number of unique wallets that have purchased from rand gallery? Create a distribution plot of how many NFTs each wallet has purchased from Rand Gallery Are we seeing new wallets purchasing on Rand Gallery or is it only wallets that have purchased from Rand Gallery before? Chart the first purchase on Rand Gallery by wallet over time. Create a table of the top 10 wallets that are purchasing from rand gallery by ALGOs and number of NFTs Tips: Check out these analyses for some inspiration on how to write your queries: https://app.flipsidecrypto.com/dashboard/algo-rand-gallery-nft-sales-Fdtzb6 and https://app.flipsidecrypto.com/dashboard/rand-gallery-nft-sales-SYCxCf NFT Sale Example: https://algoexplorer.io/tx/group/m5Xmjvw60T%2B%2F9%2Bxo15Oi5GjffoRHNRtBkSYDDZBeLgc%3D Fees are sent to: RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE NFT Statistics and Explorer: https://www.nftexplorer.app/stats
Solana-Bridgesplit and MonkeDAO's DAOJONES
Feb 20, 2022 - -- Bridgesplit enables any unique asset to become liquid and yield generative via NFT-collateralized lending, indexes, and more. -- Essentially, Bridgesplit allows for NFT fractionalization. In partnership with MonkeDAO, a Solana Monkey Business NFT -- (the MonkeDAO mascot) was fractionalized on 12/6 and trading began soon after. -- Create a chart showing daily transaction volume and the number of distinct wallets that transacted with DAOJONES. -- When was the peak amount of trading volume and seemingly ""hype"" around DAOJONES? -- What was the most amount of distinct wallets that made a transaction with DAOJONES in a day? -- Provides some insights around why these numbers peaked when they did.
NEAR - 10. The Path to Decentralization
Jan 29, 2023 - -- Create a stylish, refined dashboard that enables viewers to assess both individual validators on NEAR, and validation as -- a whole (bonus points if you find a way to enable parameters or dropdowns that display different validators). -- As ever, you are welcome to draw on past/existing work that explores governance on NEAR, as long as you provide credit to -- your original sources.
NFTx-1.Highest Sales Volume
Jun 11, 2022 - -- Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? -- These are transactions where someone redeems their NFTX tokens for a specific NFT.
THOR-It's Raining $RUNE!
Jan 15, 2022 - -- Which node operators have received the most rewards? -- Hint: Use thorchain.bond_actions
Flow-13.Flow vs Other L1s
Jun 17, 2022 - Q13. How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum
Uniswap V3 Fee Volatility
Aug 14, 2021 - What has the day over day change in fee generation been for Uniswap V3 over the past 1 month?
Liquid Staking ETH Platforms Analysis
Sep 1, 2022 - -- Consider all possible liquid staking ETH platforms. Then, find out the following: -- How much ETH was staked over time? -- How many unique depositors are there? -- How likely are depositors to use multiple platforms vs using a single platform? -- Are depositors Dollar cost averaging their ETH into the platforms? -- What is the avg/median/max/min/distribution of ETH deposits? -- Compare all the metrics above between the various ETH staking methods/platforms
Hot-18.RocketPool Recent Activity
Apr 24, 2022 - -- Using the Ethereum_core schema, analyze inflows and outflows to RocketPool over the past three months. -- As we near the ETH 2 merge, are there any emerging trends? -- What is the average deposit size and how has that changed vs. historical performance?
Lil-Nouns-2.Secondary Sales Activity
Jun 17, 2022 - -- Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? -- Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) -- between their mint price and secondary sale price? Visualize and analyze your findings. -- Hint: This query looks at Nouns traits. You will need to modify it for Lil Nouns!
Tracking top Solana NFT Collections
Apr 24, 2022 - -- Track sales volume and average sales price across marketplaces for the following NFT collections: -- Solana Monkey Business (hint you will need to use the SMB marketplace programId) -- -DeGods -Degen Ape Academy -Shadowy Super Coders -Aurory -Stoned Ape Crew -Cets on Creck -Taiyo Robotics -SolGods -Portals -Boryoku Dragonz -Catalina Whale Mixer -The Famous Fox Federation -Galactic Geckos -Thugbirdz -Mindfolk -Solsteads -Astrals -Pesky Penguins -Meerkat Millionaires Country Club -- How much wallet crossover is there between some of the top collections? -- What is the average time between buying and selling for each each collection? -- How likely are wallets to buy back into a collection after selling?
SUSHI-79.Top Kashi Pairs
May 18, 2022 - -- Q79. Find the top 5 Kashi pairs on Ethereum based on TVL. Choose one that you like and describe the following information: -- How many people are borrowing on this pair at the moment ? -- How much collateral has each user added to the pair? -- How many users have already partially paid their loans?
NEAR Tournament Round 2: Local Government
Aug 2, 2022 - -- NEAR Tournament Round 2: Local Government -- Every city has its governors, and the City of NEAR is no different. -- Assess the state of governance on NEAR, with an eye toward assessing its decentralization.
THOR-Node Operators Over Time - # operators over time
Jan 15, 2022 - -- How many unique node operators have ever bonded $RUNE? -- How has that number progressed over time?
Rand Gallery NFT Sales
May 2, 2022 - -- Show Daily NFT sale volume in # of sales, ALGOs, and USD over time. -- Show how much Rand Gallery has earned in fees daily and accumulated over time. -- How many NFTs have been sold through Rand Gallery and what is the total volume in ALGOs of NFT sales.
Solana-96.Moving to Earn in the Bear Market
Jul 13, 2022 - -- Q96. Move to Earn projects have been growing in popularity, especially on Solana after the explosion of StepN. -- Projects like Genopets and Stepn both won Solana Hackathon awards and are two of the most popular games in the field. -- Each of their own NFT ecosystems and two native tokens ($GMT and $GST for StepN, $GENE and $KI for Genopets). -- Compare these two projects in terms of users, token flows, and NFT volume. -- How can these tokens stay popular in bear market and build their own resilient gaming economies?
MIM + Anchor - Deposits vs Withdraws
Feb 10, 2022 - How much of the current deposits to Anchor Protocol’s Earn product are from the MIM Degenbox Strategy? How has this changed over the past 30 days ? What would be the implications of Disabling MIM Degenbox Strategy? Referencing this poll: https://app.anchorprotocol.com/poll/14 Could Anchor limit the MIM Degenbox Strategy to a certain percentage of deposits?
Osmo-10.Privacy Coins + Politics
Jun 13, 2022 - -- Q10. Do major news events result in more people swapping to SCRT? :Look at the volume of swaps to SCRT over the past three months. -- Do periods of high volume swaps into SCRT line up with major international news events? Or is there a pattern in SCRT swap volume?
Flash Bounty: Post Merge Behavior
Sep 24, 2022 - -- The merge has occurred. How have users responded in days that followed? -- Analyze any notable trends or outliers you can see since ETH switched to POS. -- Compare this to user behavior in the days and weeks leading up. -- What major changes can you see?
NEAR - 6. NEAR Foundation Transparency Report: Q3, 2022
Jan 10, 2023 - Each quarter, the NEAR Foundation publishes data to help the NEAR community understand the health of the ecosystem as part of their NEAR Foundation Transparency Report. We want your help in making the NEAR ecosystem even more transparent. How can you improve on the existing Transparency Report? Explain which metrics should be taken into consideration and why. Then, analyze those metrics over the last several weeks and draw your own conclusions on the health of the NEAR ecosystem.
Aave - 3. AAVE positions in Euro stablecoins around July 13th.
Jul 29, 2022 - -- Aave - 3. AAVE positions in Euro stablecoins around July 13th. -- On July 13th, for the first time in 20 years the Euro reached 1:1 parity with the U.S. Dollar. -- Show daily or hourly positions (supply and borrow) of Euro stablecoins on AAVE before and after July 13th. -- If appropriate, you may set your data to refresh daily.
Sushi-109.Liquidity Providers Stats
Aug 22, 2022 - Q109. Liquidity providers stats 1. Evaluate the distribution of various target segments who provide liquidity (LP): - What’s the total no. of unique LP providers? - What’s the ratio between Yield farmers vs. LP Providers? - What’s the average no. of LP positions opened by each unique wallet address - What’s the ratio of liquidity (Based on TVL) owned by the Protocol vs. Retail LP in both LP Pool and yield farms - The percentage (%) increase/decrease of LP Providers in Sushi over the last 1 year 2. Evaluate the profitability of an LP Provider & Yield Farmer - Evaluate if there’s a correlation between profitability vs. length of time? - Evaluate if there is a correlation between profit vs. time of withdrawal - Correlation between profitability vs type of pool? EX: stable pool
Solana TPS
Feb 20, 2022 - One of Solana's main features is its speed compared to other blockchains. Blockchain performance is usually measured in Transactions per Second (TPS). Measure the TPS of Solana in February (non votes) and 'Successful TPS' per day and create a chart showing how TPS has fluctuated during that time period.
In the News - 13. DYDX Unlock
Jan 26, 2023 - DYDX holders are bracing for a massive event next month, as 105% of the circulating supply will be distributed to investors and team members. Have holders begun preparing for this massive unlock? If so, what actions are they taking to prepare? How do you expect the market to react in the weeks leading up to and following the unlock? Back up your assertions with data.
BendDAO Metrics
Sep 8, 2022 - -- Q1. Analyze deposits and withdrawals into BendDAO over the past month. Provide metrics such as total ETH volume and unique wallets, and explain any interesting findings
Flow-9.Crossover with NBA Top Shot
Jun 12, 2022 - -- Q9. Which Flow NFT projects appear to have the most crossover of buyers with NBA Top Shot addresses? -- Is NBA Top Shot an effective onboarding tool in getting users interested into other Flow collections? -- Does this crossover tend to come from Top Shot "whales", or does the crossover come from average to smaller players? -- How can Flow projects better attract liquidity from Top Shot players?
Flash Bounty: GMX Protocol Overview
Sep 18, 2022 - -- GMX, a perp protocol, has been attracting attention recently for the massive fee revenue being generated. -- Examine and compare the protocol over recent days and weeks on Arbitrum. -- How has the protocol been performing over the past month? Three months? How is it absorbing these massive fees? -- Note any overarching themes or narratives that you find.
ENS-6. [Hard] How much money is being spent on temporary premiums?
Dec 12, 2021 - When an ENS name first expires and becomes available for reregistration, it starts with a temporary premium of $2000 on top of the usual price, which diminishes to 0 over a 28 day period. How much is being spent on these premiums, and what percentage of names are registered with a premium? What is the average premium paid on a name?
EVM - 8. Up The Mountain
Feb 16, 2023 - An Avalanche has been building up steam as of late — the price of AVAX rose by nearly 100% in the month of January and BTC hodlers have been moving holdings to the Avalanche chain. What’s been fueling this growth over the past month — and what does the future hold for Avalanche? Will this growth continue into the new year? Or will growth stagnate as 2023 continues to progress?
Terra - 8. New Year’s Resolutions
Jan 16, 2023 - 2022 was a rough year for Terra and $LUNA. So what will the future hold — and what New Year’s Resolutions could the protocol make to ensure 2023 is better than 2022? Identify at least three goals that the Terra ecosystem and community should have in the New Year, how they can achieve them, and what good fortune those changes would bring. Back up your assertions with on-chain data.
The Eclipse Score
Apr 27, 2022 - -- Invent an easy-to use ""Eclipse Score"", based on at least 3 metrics, to display validators who are not effectively representing their delegators via voting. -- For example: if you participate in only 5% of votes but are in the top 5% of validators by LUNA delegated, -- you should have a terrible Eclipse Score. Alternatively, if you participate in 5% of votes but are in the bottom 10% of Validators by amount delegated, you're not letting down the community quite as badly, and your score should reflect that (but it still shouldn't be very good; 5% is awful1) -- Provide a table and at least 1 visual that displays validators according to your Eclipse Score, -- e.g. a bubble chart with LUNA Delegated vs. Votes Attended. -- Top Score Worthy: Additionally, analyze the top 5 best and top 5 worst validators according to your Eclipse score. -- For Insight, provide your analysis or commentary on one, several, or all of these validators.
Across-1.Bridge Transactions (Across)
Jun 20, 2022 - -- Q1. Analyze bridge transactions via the Across bridge over the last two weeks. -- What assets are users bridging from Ethereum, and to what chains? -- Across transaction event data is undecoded in the Ethereum core tables. -- Users can use these functions to parse and decode the data: -- regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data ethereum.public.udf_hex_to_int() -- Hint: A user begins a bridge transaction by calling the deposit function on the SpokePool contract from the origin chain. -- Ethereum SpokePool contract : 0x4D9079Bb4165aeb4084c526a32695dCfd2F77381
Aave - 2. Borrow Durations
Jul 29, 2022 - -- How long on average and median do wallets borrow on AAVE? -- Measure this duration across at least three different tokens. -- Compare the borrow duration on AAVE with at least one other lending platform like Compound.