CryptoIcicle
Across-2.Single-Sided Liquidity Pools
Jun 20, 2022 - -- Q2. Across uses single-sided liquidity pools to execute transactions between chains. -- How are Ethereum mainnet users interacting with these pools? How do these pool rewards compare to other liquidity pools?
Solana NFT Championship
Oct 10, 2022 - There’s no shortage of sports-related NFTs on Solana, from Collectorz Club and Suites to Laidback Lions and Aaron Jones’ Showtime collection — but who can lay claim to the title of Solana sports NFT champion?
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?
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-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'
Thor-105.Active Wallet Addresses
Jun 21, 2022 - -- Q105. We are interested in knowing how many users are currently in the ecosystem. -- In this case, how many are holding $RUNE in their wallet or have an open LP position. -- What is this number currently, and how has it trended over time? -- Hint: use thorchain.liquidity_actions and thorchain.transfers
Aave - 7. AAVE and stAAVE movements
Aug 10, 2022 - -- Create visualizations showing the following: -- Daily AAVE supplied and withdrawn on Aave protocol. -- Daily AAVE staked and unstaked.
Thor-104.$RUNE Movement from Crypto.com
Jun 20, 2022 - -- Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
NEAR - 12. The Whales of NEAR
Feb 15, 2023 - Where in the ocean of NEAR do the whales hang out? Examine the top 20 addresses by amount of NEAR held - excluding any custodial or exchange addresses that you can. Can you identify any “power players” or wallets of interest? What behaviors do these whales exhibit?
Aave - 1. AAVE Flash Loan Users
Jul 29, 2022 - -- Flash Loans allow users to borrow any available assets without putting up any collateral, -- as long as the liquidity is returned to the protocol within one block transaction. -- Show the frequency and volume of AAVE Flashloan use in 2022. -- Create a profile for a typical Flashloan user in 2022. -- Some of the metrics to look at could be wallet balance, transaction frequency, and dapps usage. -- Be sure to set a daily refresh rate for your data on flashloan use.
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?
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?
Overtime Markets - Profitable Traders
Aug 24, 2022 - -- Identify the 5 most profitable traders on Overtime Markets in the last two weeks. -- How much has each wallet won by sport?
Terra - 6. New Year, New LUNA?
Jan 7, 2023 - The holidays and New Year are often chaotic in the crypto and DEFI space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts. Has this flurry of winter activity impacted the Terra ecosystem? Are users creating new wallets or buying tokens with their newfound holiday wealth? Are they staking all those new tokens once they get them? Or are they selling tokens to pay for their own gifts and holiday travel? Create a dashboard documenting significant trends in transactions, wallets, supply, staking, development, or other aspects of the Terra ecosystem. Note any changes in metrics such as the average and total transactions per week and the fees associated with them, the total and average number of new wallets created each week, the total and average number of contracts deployed, LUNA staked, and anything else you interesting.
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.
axlUSDC: Soon to be forgotten?
Nov 4, 2022 - Recently, Circle announced the implementation of an IBC-native USDC, inserting itself into an ecosystem where axlUSDC currently dominates. Let's look at how pervasive axlUSDC is within IBC. Track Satellite bridge activity strictly related to axlUSDC transfer. Which app-chains have the most/least flows of axlUSDC? Looking at Osmosis specifically, analyze how dominant axlUSDC has become compared to both ATOM and other USDC assets in trading and pools.
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?
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!
In the News - 12. Groundhog Day
Jan 17, 2023 - It’s been a harsh few months of winter in the crypto market, with token prices falling hard and once-stable companies and organizations reducing workforces or even vanishing overnight. With Coinbase announcing another layoff of nearly 20% of employees, some might be feeling like Bill Murray in Groundhog Day, forced to relive events over and over again. With that in mind, let’s turn to our friend the groundhog for an early crypto-winter prediction: are we nearly through to spring, or will winter’s cold snap continue on even longer? Back your assertion by creating a dashboard with on-chain data that supports your arguments in favor of either a continued downturn in the space or a soon-to-come rally.
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?
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.
Algo-49.Governance Period 2 Payouts - Daily
Apr 13, 2022 - -- How many reward payments were sent? And what was the total amount of ALGO rewards paid out? -- How much time elapsed from the first to the last rewards payment? -- What wallet had the largest rewards payout and how much did they receive? -- Create a plot to show the distribution of rewards payouts. -- Tips: We expect the decoded transaction note to look something like
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.
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?
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
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.
48. DOGE-RUNE LP-ers
Jan 29, 2022 - How many of the THORChain wallets that added liquidity to the $DOGE-$RUNE pool were new (created on or after Jan 15th)? Of the existing wallets (created before Jan 15) that added liquidity to the $DOGE-$RUNE pool, how many of them withdrew liquidity from other pools before adding to the $DOGE-$RUNE pool?
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'
Hot-6.Moonbirds Gas Fees
Apr 21, 2022 - -- Q6. How much gas was spent minting? Was any gas lost due to failed transactions? How does it compare to other recent launches? -- Use the Ethereum_core schema. -- Hint: https://etherscan.io/address/0x23581767a106ae21c074b2276d25e5c3e136a68b
Metamask-2.Most Common Transactions
Jun 25, 2022 - -- Q2. What are the most common transactions for Metamask users? -- Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Bot Swappers
Apr 24, 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.
Algo-Defly Token Launch
Feb 11, 2022 - Defly(https://defly.blockshake.io/) is a mobile wallet and swapping platform that is currently being developed on the network. They recently had there token presale and liquidity pools have been provided for swaps on Tinyman. Chart the number of Defly Swaps by day on Tinyman What was the biggest swap for Defly on Tinyman? Chart the distribution of Defly among in wallets. Tips: -Defly asset ID is 470842789 Here is a Defly Tinyman swap example: https://algoexplorer.io/tx/group/7fT9AYyUiLqVZGX8sZyRlYrQC8W8VoPysU6Kz%2FasrYs%3D Tinyman Defly Contract Address: XLNMBK3GMC4YEF562DMEOZEYTNDWJLQRN2GFQ3MGLVNIJTOTVGVD75DVKM
Thor-47. DOGE Debut
Jan 29, 2022 - -- Dogecoin was added to the THORChain network last week. -- What was the $DOGE swap volume in the first 24 hours after it was added? -- How does that compare to other tokens in their first 24 hours listed on THORChain? -- Which token had the highest swap volume in its first 24 hours on THORChain?
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
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.
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.
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-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
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?
Solana - 4. The Solana Smart Money
Feb 4, 2023 - Create a dashboard that tracks the most profitable traders on Solana (both in terms of token swaps and with NFTs). Use parameters to help define who falls under the category of most profitable and over what timeframe. What has "smart money" been doing on Solana over the past month? Over the past week? Are they active traders or do they hold positions for days at a time? What projects have yielded the most profit for Solana traders? Are there any indicators of what their next trades or strategy will be? How does your dashboard compare to Hellomoon's smart money inflows and outflows?