CryptoIcicle
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 28, 2022 - Celsius Network listed a $1.19 billion deficit on its balance sheet in a bankruptcy court filing a day after the cryptocurrency lender filed for Chapter 11. Currently Celsius owns a large portion of the CEL tokens. What are the top addresses swapping and transferring CEL? How have the CEL swap volumes changed over the past 90 days? How are Celsius wallets interacting with the CEL token? Hint: Here is the list of Celsius Wallets Identified by @lawmaster on twitter: https://app.flipsidecrypto.com/velocity/queries/c5c1ca1b-5299-4105-aed5-7968e2426d94
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
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.
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.
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.
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?
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.
Terra - 10. Light as a Feather
Jan 25, 2023 - -- The announcement of Station has generated hype in the Terra community. -- Has this type translated to an increase in activity? -- Define and visualize at least 2 metrics for ecosystem activity and analyze them in the week before and after the Station. -- Did the launch have any measurable impact? Are there other factors that might be in play affecting the metrics you’ve chosen?
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.
Open Analytics Bounty: ETH vs Solana - Battle of the NFT Marketplaces
Sep 15, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic. For this bounty, submissions should compare ETH + Solana in some way.
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!
Osmosis - 2022 Stablecoin of choice ?
Jan 26, 2023 - Submit a deep dive dashboard that explores a specific topic in detail using Osmosis data. Open Analytics (OA) bounties are bounties without specific prompts, just a direction and a reward. It’s your chance to have your brain follow your heart — got a spark of interest, or a loose thread, or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
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?
Near-9. New NEAR Users
Sep 8, 2022 - What actions does a user take when they deposit money into the NEAR ecosystem?
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.
Toke-1.Top TOKE Holders
Jun 23, 2022 - -- Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
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.
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.
Merry $BONK-ing Christmas
Jan 4, 2023 - -- Total # of holders -- % of holders that are active wallets -- Average amount $bonk in holder wallets -- Average time holding bonk -- Any other notable trends or outliers you see -- Then, give us context! What kinds of Solana users are $bonk holders? How active are they, what other tokens do they tend to hold, etc. -- Has Solana activity as a whole risen in conjunction with recent $bonk activity, and how much Solana activity does Bonk Inu account for? -- And as always, don't forget to tweet about your dashboard and $bonk, to share your insights with others!
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?
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?
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?
Bridger Destinations (redux)
Oct 31, 2022 - -- Where do people go when they bridge to Optimism from Ethereum? -- What are the 10 most popular first destinations for users that have just bridged from Ethereum? -- What has this been for each day in the past month? How has this changed over the last three months? Last six months? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
2.FWB-ETH + USD in the FWB Treasury
Feb 20, 2022 - -- Question 2: Create a visualization showing the amount of ETH and USDC held by the treasury wallet over time (quantity and USD value). -- What other assets has this wallet been holding? -- How do you think treasury wallet performance affects $FWB token price?
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?
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
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-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?
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?
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
Most Popular Jupiter Swaps
Feb 26, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users.
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.
Hot-10.Sablier Top 10 Users
Apr 23, 2022 - -- Q10. List 10 users who received the most funds and 10 users who sent the most funds through cash streams. -- Use Ethereum_core schema.
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?
31. - Sushi and Uni Gas
Jan 30, 2022 - Compare the daily ETH gas fees on Sushiswap over the past 2 months to those on Uniswap. Show the average gas fee per transaction as well as total gas fees collected.
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?
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."
Solana-Balloonsville Rug Pull
Feb 21, 2022 - -- Balloonsville is an NFT project that launched on the Magic Eden marketplace on February 5th, 2022 and rugged the following day. -- Due to the nature of the rug, this caused a large controversy in the Solana NFT community. -- Since February 5th, what is the total volume of Balloonsville secondary sales on Magic Eden? -- Over the same time period, what is the average sales price of Balloonsville NFTs on Magic Eden? -- Create a visualization of the sales volume and price over time of Balloonsville NFTs and provide insights about any spikes or trends you see. -- Bonus: Tell the full story of the rugpull using screenshots from Twitter and other social media. -- Can you find the rugger’s large Solana transfer to FTX that allowed him to be doxxed? -- How many balloons were sent to the Magic Eden Balloonsville treasury wallet -- (address: 8uE4uoCSQ3ZHNTR616qN3nL5xBBxQV7AqEQ95RSficyz) for a 1 Solana refund?
149.Terra-Killer Crossover, Mvmt. I: LUNA/Solana
Feb 21, 2022 - Friktion on Solana offers a “covered call” strategy for numerous assets, including LUNA. 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?
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.