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?
![149.Terra-Killer Crossover, Mvmt. I: LUNA/Solana 149.Terra-Killer Crossover, Mvmt. I: LUNA/Solana](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
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?
![[Flash] Solana Swaps - V2 [Flash] Solana Swaps - V2](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
[Flash] Solana Swaps - V2
Feb 7, 2022 - -- Analyzing swaps on Solana is difficult because each major DEX uses a slightly different data structure. -- The location of the tokens and amounts swapped can vary in index and between pre and postTokenBalances as well as the Instruction. -- On each of the major Solana DEXes, what 5 tokens have seen the most volume in each week in January? -- What is the volume of each stable coin for each DEX for each week in January? -- Use the Solana events table to solve this problem
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
![Across-2.Single-Sided Liquidity Pools Across-2.Single-Sided Liquidity Pools](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
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.
![148.Terra-Anchor Dominance 148.Terra-Anchor Dominance](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
148.Terra-Anchor Dominance
Feb 14, 2022 - Question 148: What is the “Anchor dominance” for wallets on Terra? For active Terra wallets*, how much of their total asset value is held in Anchor at the time of analysis? *Select your own definition for “active wallets”; for example, wallets with at least 1 transaction in the last 30 days
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?
![31.Solana-USDC, USDT, UST on Jupiter 31.Solana-USDC, USDT, UST on Jupiter](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
![Flow-13.Flow vs Other L1s Flow-13.Flow vs Other L1s](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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
![Terra-145. Wherefore Art Thou, Rewards? Terra-145. Wherefore Art Thou, Rewards?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Terra-145. Wherefore Art Thou, Rewards?
Feb 9, 2022 - Question 145: What are users doing with their Anchor rewards? Quantify and visualize the differences between how users deploy rewards earned from each of the following: borrowing, staking, liquidity pooling.
![NEAR Tournament Round IV: The Journeymen NEAR Tournament Round IV: The Journeymen](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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.
![SUSHI-34. - Gaming Tokens SUSHI-34. - Gaming Tokens](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
SUSHI-34. - Gaming Tokens
Jan 30, 2022 - Find the 5 largest crypto gaming tokens on Sushiswap. How did volume on Sushiswap get impacted when each of these tokens got added to the protocol? What tokens are most often used to exchange into new gaming crypto tokens?
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.
Secondary NFT Market Mega Dashboard
Oct 5, 2022 - -- Secondary NFT Market Mega Dashboard -- Create a dashboard on the secondary market for NFT sales on Optimism!
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?
![3.FWB-FWBpro Airdrop 3.FWB-FWBpro Airdrop](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
![Hacks, Scandals and Scams - 3. Whales On Alert Hacks, Scandals and Scams - 3. Whales On Alert](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 29, 2022 - -- Identify active wallets with a high balance of ETH (whales). -- Visualize the ETH transaction history of these whales in May and June 2022.
![Yield Maximization 2 Yield Maximization 2](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Yield Maximization 2
Mar 8, 2022 - Question 51: Of the people who have used Sushi's lending service on ethereum, show the top 50 addresses that have realized the most profit (ROI) considering gas fees. what where they lending? for how long?
![Solana-51.MonkeDAO Whale Voters Solana-51.MonkeDAO Whale Voters](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Solana-51.MonkeDAO Whale Voters
Apr 12, 2022 - -- A month ago, the MonkeDAO pressed the Solana Monkey Business team for various changes to be made to the royalty and NFT structure to foster growth for the collection. Ultimately this resulted in the first NFT on-chain vote on Solana to accept or reject the SMB team's proposal, with a 'no' likely resulting in a separation of the two groups. In the end, the MonkeDAO voted to unify with the SMB team and to grow their relationship together.
Aave - 8. How does BTC funding affect rates?
Aug 11, 2022 - Create a dashboard that shows: Supply and lending rates for at least five tokens in Aave V2, and Total amount of Wrapped BTC supplied over time. Provide analysis on the volatility of rates. Measure the correlation between USDC borrow rates and total wBTC
![Terra-189.What Happens To Liquidated Collateral? Terra-189.What Happens To Liquidated Collateral?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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.
![ENS-6. [Hard] How much money is being spent on temporary premiums? ENS-6. [Hard] How much money is being spent on temporary premiums?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
![5.Solana-Phantom Wallet Growth 5.Solana-Phantom Wallet Growth](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
5.Solana-Phantom Wallet Growth
Feb 5, 2022 - -- Question 5:This week, Phantom (the most popular wallet in the Solana ecosystem) released its mobile app. -- There is an expectation that this will gradually increase adoption. -- Track and visualize at least two metrics to compare growth in Solana activity in the start of February -- (when Phantom mobile launched) to the month of January.
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!
![Solana-96.Moving to Earn in the Bear Market Solana-96.Moving to Earn in the Bear Market](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
![Metamask-2.Most Common Transactions Metamask-2.Most Common Transactions](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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.
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
Terra - 7. Price Run Investigation
Jan 16, 2023 - Beginning in the wee hours of Monday, January 9 (ET), the price of LUNA skyrocketed, from $1.37 to a high of nearly $2 before settling down at roughly $1.60. Identify some of the major reasons for this recent upshot in price, and back up your assertions with data. Why did the price jump so suddenly on Monday night? Will prices remain at, or above, current marks in the coming weeks or will it return to at or near $1? Why?
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.
![MARS Protocol Lockdrop Hunt MARS Protocol Lockdrop Hunt](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
MARS Protocol Lockdrop Hunt
Mar 3, 2022 - -- Provide UST into the MARS-UST Bootstrapping Pool
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?
Open Analytics - 9. Osmosis - Governance, Proposals and Voters
Jan 20, 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!
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
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
![Uniswap V3 Fee Volatility Uniswap V3 Fee Volatility](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
![Solana Flash Bounty: Saga Solana Flash Bounty: Saga](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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?
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-54.NFT Mint Sweet Spot Solana-54.NFT Mint Sweet Spot](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Solana-54.NFT Mint Sweet Spot
Apr 19, 2022 - -- Q54. Compare the mint price of popular Solana NFT collections to their resale price. -- Is there a ‘sweet spot’ for Solana NFT mint prices that fetch higher percentage returns on the secondary market? -- Do collections that cap the number of NFTs a wallet can mint have higher returns? -- Create a dashboard that discusses these points. Start using Magic Eden marketplace data. -- For grand prize eligibility: Consider all marketplaces and see if the “sweet spot” differs between marketplaces. -- Hints: Look at this analysis on Ethereum NFTs for inspiration. Use the “mints” field and join to the labels table -- to determine which collection an NFT belongs to. -- Replicate table #2 here for Magic Eden Solana NFT's: https://a16z.com/2022/03/31/nft-mint-data-early-decisions/
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
11.Solana-Solend SOL Lending/Borrowing
Feb 15, 2022 - Since February 5th, How much SOL has been supplied by lenders? How much SOL has been borrowed? Are there any noticeable trends in the net flows during this time? Provide insights and a visualization on the day-to-day trends of SOL and lending vs borrowing. How many SOL withdrawals and repayments happened during that timeframe on Solend? (Hint do small txs on Solend to identify the accounts you need)