CryptoIcicle
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?
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?
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?
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 - 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?
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'
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.
ERC20 Tokens (zkSync)
Jun 14, 2022 - -- Q2. ZkSync is a scaling solution for Ethereum that is live on mainnet. -- Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. -- Users can also deposit ERC20 tokens into ZkSync. -- Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
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?
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!
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?
NEAR - 11. Insight of the Week - NFT Creators & Honorary Bored Ape
Feb 5, 2023 - The NEAR Foundation is running an "Insight of the Week" series. Keeping your analysis short and focused on excellent-quality visualization - provide the most fascinating or illuminating fact or insight that you can about the NEAR ecosystem, or any of the projects building on NEAR, over the past 7 to 14 days. When you tweet about the insight, don't just describe it - do your best to explain "why" what you chose is unusual, valuable, or noteworthy.
THOR-Node Operators Over Time - # operators over time
Jan 15, 2022 - -- How many unique node operators have ever bonded $RUNE? -- How has that number progressed over time?
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.
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.
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
Aave - 3. AAVE positions in Euro stablecoins around July 13th.
Jul 29, 2022 - -- Aave - 3. AAVE positions in Euro stablecoins around July 13th. -- On July 13th, for the first time in 20 years the Euro reached 1:1 parity with the U.S. Dollar. -- Show daily or hourly positions (supply and borrow) of Euro stablecoins on AAVE before and after July 13th. -- If appropriate, you may set your data to refresh daily.
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?
NEAR - 7. Weekly Report - Redux
Jan 14, 2023 - Each week, the NEAR Foundation publishes data to help the NEAR community understand the ecosystem's health as part of their Transparency Report. We want your help in making the NEAR ecosystem even more transparent. How can you improve on the existing NEAR 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. Grand prize-winning dashboards will go above and beyond the existing report, allowing readers to get the best possible snapshot of NEAR, its users, and its ecosystem.
[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?
Hot-19.RocketPool: User Profile - LIDO vs. RocketPool
Apr 24, 2022 - -- Lido is another application that also offers ETH2 liquid staking. -- Compare and contrast activity on RocketPool vs. Lido over the past three months. -- Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? -- Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? -- Visualize and explain your conclusions.
34.Algo-Algorand Governance Period 2 Voting
Mar 10, 2022 - -- Show wallet votes over time -- Which had more individual wallet votes, A or B? -- Show the voting result(A vs B) based on the ALGOs committed by wallets for this governance period.
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?
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?
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?
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?
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.
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?
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?
stETH/ETH Fluctuation
Jun 11, 2022 - -- Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation. -- Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, -- Curve stETH/ETH pool composition, etc.
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?
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.
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.
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.
NFTx-1.Highest Sales Volume
Jun 11, 2022 - -- Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? -- These are transactions where someone redeems their NFTX tokens for a specific NFT.
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)
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.
Wallet Balances & Ecosystem Growth
Oct 26, 2022 - -- With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. -- Provide insights into following metrics: -- How has the ratio of liquid to staked OSMO changed overtime? -- Are the top 100 OSMO holders the same now as they were at the start of the year? -- What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. -- Do wallets normally hold a majority of OSMO, or another token? How has this changed over time? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
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.
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?
Rari-2.Fuse Pool USDC Allocation
Mar 19, 2022 - -- Q1. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
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?