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?
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.
MARS Protocol Lockdrop Hunt
Mar 3, 2022 - -- Provide UST into the MARS-UST Bootstrapping Pool
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.
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-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.
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.
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
[Terra] Voting Records
Jan 18, 2022 - Select two Terra Validators of your choice and compare their voting history (governance votes). Off-chain data can be used to support your answer, but you must also utilize Flipside data in your answer to be eligible for full payment. BONUS: Can you find any proposals where your chosen validators voted differently? Why do you think this might be the case?
Near-9. New NEAR Users
Sep 8, 2022 - What actions does a user take when they deposit money into the NEAR ecosystem?
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.
Bounty #13 - Post-airdrop(s) activities -ENS Airdrop Stats
Jun 23, 2022 - For this bounty, choose an ERC20 token airdrop (or even multiple airdrops for comparison!) that you thought was interesting and worthy of data-backed narrative, then present data analysis, commentary, and story-telling on the Uniswap activities of the token(s) during the first two weeks after the airdrop.
NEAR Tournament Round IV: The Journeymen
Aug 18, 2022 - -- Analyze the journey of active NEAR users. -- After bridging to NEAR, where do they head first? -- How many users are day trading in the financial district, -- and how many are buyers and sellers on the NFT marketplaces of the Arts district? -- Who are the whales, and is their activity any different from that of smaller fish? -- Top submissions should provide an in-depth analysis of the typical NEAR user journey, from small fish to the biggest whales.
31.Solana-USDC, USDT, UST on Jupiter
Mar 5, 2022 - -- Question 31: Create a visualization comparing USDC, USDT, and UST (wormhole) popularity in swaps on Jupiter since December 1st -- (both in terms of count and amount - swaps from and swaps to). -- Is there a dominant stablecoin in swaps on Jupiter? -- What percentage of all Jupiter swaps are stablecoin swaps (as in a swap between USDC, USDT, and UST)? -- Have we seen more instances of users swapping USDC or USDT for UST over time? Why or why not based on your knowledge of Terra's cross-chain efforts?
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
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.
WETH/THOR Pool
Sep 13, 2022 - -- Q111. ThorSwap just recently partnered with Sushiswap to create an Onsen farm for ETH-THOR LP providers to stake their liquidity to earn extra rewards. -- Previously ThorSwap offered their own contract for the same purpose but this switch allows for higher rewards as well as lower slippage for the users. -- Show how users reacted to this change: -- - How many funds has been moved from the old contract to the new one? How much is still left in the old one? -- - How many unique wallets did already move their liquidity over? How many still have to switch?
Lido-7.Lido vs. The Field
Apr 4, 2022 - -- Q7. How does Lido usage compare to other top staking platforms? Choose 2 platforms to compare it to.
[Terra] Staking Yield, Mvmt 1: The Basics
Jan 18, 2022 - Explain in your own words (i.e. don't copy the documentations) how Terra's staking yield is calculated. Provide a graph that compares LUNA staking yield to LUNA price over a time period that you define.
Solana Flash Bounty: Saga
Jun 24, 2022 - -- How many wallets have pre ordered Saga (the new solana phone) so far? -- Note: the preorder is a NFT purchase on-chain. -- Who is preordering the phone? Provide a breakdown of the type of wallets ordering so far. -- Example metrics to investigate: what other programs are these wallets interacting with, how active have these wallets been on Solana, are they average users or whales?
Hop-2.Bridge Volume (Hop Protocol)
Jun 20, 2022 - -- Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? -- What is Hop’s total TVL? -- Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.
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.
Solana-48.Solport vs. Magic Eden
Apr 2, 2022 - Q48. Solport - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden? Solport is strongly connected to the NFT collection 'Taiyo Robotics', which incentivizes holders to increase Solport's adoption. Compare Taiyo Robotics sales on each marketplace. Do sellers care more about growing their own marketplace or capitalizing on the access to liquidity?
Sushi-84.Stablecoins
May 30, 2022 - -- Q84. The growth of non-volatile assets pegged to a fiat currency has been a one of the clear trends in crypto in the last few years. -- However, during the past days, a big fatal event occurred when Terra UST peg token started to depegging from $1. -- Many different projects proposed different models to define their own stablecoins. -- For this Bounty, analyse the stablecoin landscape on Sushiswap, identifying the various tokens available -- and their main metrics (volume, number of swaps, TVL, and other relevant for you). -- Argue why any of these stablecoins could succeeded in comparison to UST and why.
Market Volatility vs Terra NFT Floor Prices
Feb 11, 2022 - How do market conditions affect Terra NFT price movement? What is the correlation between the floor price of Galactic Punks, LunaBulls, and Levana Dragon Eggs with the price of LUNA? Does market volatility change how people trade "bluechip" Terra NFTs? Do you think NFT buyers/sellers price their assets in UST or in LUNA? Do your findings align with Ethereum NFT market trends or does the prominence of UST make the Terra market different?
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.
44.Sushi-Governance
Feb 20, 2022 - -- Question 44: Explain all the ways that SushiPowah can be obtained using visual aids. -- Are they limited or inflationary? I.e. are the total units of SushiPowah capped?
Tornado Cash Addresses
Aug 10, 2022 - -- Using those addresses: -- Which of the Tornado Cash addresses received the most # of transactions in the last month, quarter, year -- Which addresses received the most transaction volume (worth) in the last month, quarter, year -- Over all the addresses, group the transactions into buckets by value. -- How many tx in the 0.01-0.1 ETH range went to Tornado? -- How many in the 0.1-1ETH range? -- How many in the 1-10ETH range? -- How many in the 10-100 ETH range? -- How many above 100 ETH? (split further if better)
OP Price vs Swapper Activity
Oct 5, 2022 - -- Is there a relationship between OP price and trade volume? -- Make your case by including at least three visualizations.
Thor-90.$THOR Staking Wallets
May 23, 2022 - -- Q90. 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. -- How many unique wallets have staked $vTHOR? Chart this number over time.
Solana-MonkeDAO Validator
Feb 18, 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.
Solana-42.The Rise of DeGods
Mar 28, 2022 - Q42. DeGods have risen to become one of the most valuable NFT collections on Solana with an extremely devoted community. Create visualizations showing sales volume and unique wallet purchases since January 1st on Magic Eden. Using the NFT metadata, are there certain traits that have become more popular over time in anticipation of DeadGods? $DUST is the token created by DeGods for NFT auctions and will be a necessity for modifying the DeGod art to a DeadGod. Who is swapping for $DUST on Jupiter? Is it correlated with the wallets that have purchased the most DeGods? What do you think will happen to the price of the DeGods collection and $DUST when DeadGods launches on March 31st?
Sushi-60.Concentration of Capital
Apr 2, 2022 - -- How concentrated are Sushiswap's liquidity pools in terms of liquidity provider participation? -- How has the concentration evolved over time? -- How many pools are dominated by one single LP that holds more than 50% of funds?
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?
Rari-3.Fuse Pool Analysis
Mar 19, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Flow - 3. Daily Active Users
Apr 11, 2023 - Track how the Flow blockchains daily active users have evolved over time. What about monthly? All-time wallets? Recently, we’ve identified some interesting spikes (in both directions) in daily active users. Chart this activity, and try to uncover any reasonable explanations for the results.
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
Solana-Wormhole Hack
Feb 8, 2022 - This week a hacker managed to exploit the Wormhole contract and steal 120K wETH. Jump Crypto was able to restore the liquidity after a few hours, but for a brief period on 2/2 this created imbalances and a difficult situation since the stolen wETH backed all ETH on Solana. Create a dashboard showing the transaction volume change in the 2 most popular ETH pools on Solana compared to the previous week's volume. Can you visualize panic in the market? How long did it take for activity in that pool to stabilize?
[FLASH-Delphi] Number of daily active wallets
Nov 10, 2021 - -- The ask: We’re working on giving Delphi insights on some Terra data. -- A DappRadar report had mentioned that 2M daily unique active wallets interact with dapps, -- we want to see that stats on Terra alone. -- tl;dr: Query on-chain data to find the number of daily active wallets on Terra from the past 90 days -- and give an analysis on findings.
Solend TVL Tracking
Aug 25, 2022 - On August 17th, Solend announced their permissionless pools, where anyone can now create a pool. https://twitter.com/solendprotocol/status/1560003756736925696 How has this influenced user behavior on Solend so far compared to prior user activity? How many users have used a permissionless pool? What is the % of TVL contributed from isolated and permissionless pools, against the main pool over time? What is the amount/% of TVL that comes from PDAs/integrations or DAOs/Realm addresses, instead of normal signers? Overall how healthy does Solend appear as a protocol and is it gaining traction in the Solana ecosystem?
Uniswap V3 vs QuickSwap vs SushiSwap
Jan 27, 2022 - How does Uniswap V3 usage compare to QuickSwap or to SushiSwap? Compare TVL over time, usage (swaps and LP counts and volume). How has the launch of Uniswap V3 on Polygon impacted QuickSwap and SushiSwap’s TVL and user base?
Algo-69.Borrowing On Folks Finance
May 20, 2022 - Q69. 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.