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?
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.
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.
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
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
Thor-88.IL Protection Over Time
May 14, 2022 - -- Q88. With highly volatile prices recently, more IL protection has been paid out on THORChain. -- How do recent days or weeks compare to historical amounts?
Near-9. New NEAR Users
Sep 8, 2022 - What actions does a user take when they deposit money into the NEAR ecosystem?
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.
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.
Axelar Ecosystem Entrances
Oct 28, 2022 - -- Welcome to Axelar! What better to way to get used to Axelar data than to analyze how people enter the ecosystem? -- With that in mind, analyze the activity that occurs on Axelar's Satellite Bridge. -- Since inception, what are the top paths over Satellite. by volume and $ amount? -- What is the most used token to transfer (USDC, wETH, wAXL, etc.)? -- Top analyses will show bridging activity since inception and analyze how that has changed over time.
Sushi-92.Stable Coins Lent on Kashi
Jun 13, 2022 - -- Q92. Draw a chart showing the TVL of Stable coins on kashi pairs across all markets. -- Hint: You can include USDC, USDT, DAI and UST in your analysis and look for the transactions where they are deposited on Kashi for lending. -- The event name would be 'LogAddAsset'. Removing them will generate 'LogRemoveAsset'
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.
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.
3.FWB-FWBpro Airdrop
Feb 20, 2022 - Were people more likely to sell right after the start of the airdrop or has selling happened over time? Are there any patterns to holding vs selling behavior among wallets? Were larger holders of $FWB Classic more likely to try and mitigate risk after the hack? What percentage of people receiving the FWBpro airdrop have held onto their tokens?
Terra-189.What Happens To Liquidated Collateral?
Apr 12, 2022 - -- Q179. What do users do with liquidated collateral after winning a bid? Possible actions are: sell, swap (i.e. bLUNA->LUNA), hold, deposit into Anchor, etc.
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!
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?
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.
Terra - 11. Back to Basics: Account Activity
Jan 29, 2023 - The question of “active wallets” faces every ecosystem. Let’s investigate this question for Terra — and go beyond the “one transaction in 30 days” approach! Define what an active, high quality user looks like and how it can be measured. Assess how many active users exist on Terra, according to your definition. Additionally, provide a few brief, specific ideas to attract additional users, as well as an assessment of what it would cost to implement these ideas. What is the acquisition cost for a high-value user, according to your recommendations?
ETH Merge: Selling Event?
Sep 30, 2022 - -- Was the Merge a selling event? Why or why not? -- Were miners the source of sell pressure? Show any wallets miners have transferred ETH into, -- along with any other visualizations you think will add to your analysis.
Daily Active User
Oct 18, 2022 - -- Daily Active User -- What does a Daily Active User look like on Osmosis? -- First, plot out how many DAUs there are on Osmosis. -- For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. -- What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. -- Do they LP more or swap more? -- How often do they transfer tokens into Osmosis? -- Where are these transfers coming from?
143. Liquidity Space Voyage / Mini-Terra Tutorial
Jan 30, 2022 - Since the launch of Astroport, many have moved their liquidity from Terraswap pools to Astroport pools. Plot the total value of TVL that might have moved from Terraswap to Astroport for the LUNA/bLUNA pair by showing the total withdrawals from Terraswap and deposits to Astroport since Astroport launched.
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?
Solana-81.Smart Money NFT Traders
Jun 6, 2022 - -- Q81. Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year? -- What types of actions have led to being a profitable NFT trader on SOL? -- Is there a pattern behind their NFT trading strategy and can you define some of these traders as "smart money"? -- Do you think you need to be a "whale" to do well trading SOL NFTs, or can anyone have success in this market?
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?
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.
[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?
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.
Sushi-95.Celsius Swaps
Jun 19, 2022 - -- Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. -- From which one of their wallets did they conduct most of the swaps? -- Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels
Near-10.NEAR Distribution
Sep 8, 2022 - -- Q10.Calculate the distribution of $NEAR holdings by address. -- In terms of charts, feel free to create a histogram or whichever visual you think works best!
Hot-12.How Many Times was Hop used?
Apr 23, 2022 - -- Q12. How many times was the hop protocol used in 2022 in order to bridge funds to layer2? -- Use Ethereum_core schema. -- Hints: -- contract address for ethereum bridge for Matic : 0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2 -- MATIC contract address on ethereum: 0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0 -- Event name that sends token from user's wallet to the bridge is 'Transfer' -- Event name that sends token from the bridge to the layer 2 wallet is 'TransferSentToL2'
49. Node RUNE in/outflows
Jan 29, 2022 - Are Node operators selling/swapping more Rune per week than before EMISSIONCURVE changes? (blocks: 3636274 value: 16), (block: 3704556: value 8) Hint: use bond_events, swap_events, transfer_events
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-79.Tracking GMT into StepN
May 26, 2022 - Q79. StepN has remained the fastest growing Web3 app in the world, currently picking up tremendous hype for its move-to-earn concept. Track the flow of GMT into the app. How are users acquiring GMT? Is by swapping using a DEX like Jupiter, or do flows seem to be coming from centralized exchanges? How often is GST (the token earned in the game) swapped for GMT? What other actions are wallets that are sending GMT into the app doing? Additionally, where do SOL inflows into the app seem to be coming from? Does it seem like most StepN users were already active within the Solana ecosystem, or is there a lot of activity that originated from inflows from centralized exchanges? Essentially, is StepN onboarding users into Solana? Create visualizations showing these inflows of GMT and SOL into the StepN app and if the announcement of Coinbase adding StepN to their list of tokens sparked additional interest from sources outside of the Solana ecosystem."
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?