Ali3N
LUNA Price Run Investigation (Terra)
Jan 12, 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?
Exchange Flows in the Bear (Ethereum)
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior. Explore trends in exchange withdrawal (specifically, moving money from CEX addresses onto the chain) patterns over the last 6 months. Have those withdrawals increased? Has the typical size of them changed? Most important: are people creating new wallets to take custody of their CeFi deposits?Also have a look at what people do after a withdrawal: are they holding their withdrawn tokens? Or are they fiat-on-ramping so they can swap, provide liquidity, buy NFTs, etc.hint: find centralized exchange addresses in [chainname].core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet' other hint: feel free to include a couple of major chains for this analysis, but certainly at least include Ethereum
FTX, Alameda and the Solana ecosystem
Nov 10, 2022 - How has the recent tumult surrounding FTX and Alameda impacted SOL and the Solana ecosystem?
FLOW User Retention vs Other Chains
Dec 16, 2022 - How sticky are the users on Flow? Create a detailed analysis comparing user retention on Flow vs. other L1 chains like Ethereum and Solana. How often do users who make a transaction come back and make another transaction one month later? How do monthly active users compare between chains? Bonus: add a section of your analysis comparing retention specifically with regard to NFT purchases. How often do users who purchase an NFT come back and make another purchase one month later?
ETH Positive Price Action
Jan 19, 2023 - Let’s examine ETH's positive price action this year: Looking at Ethereum Mainnet activity from block: 16310000 (Jan 1, 2023) to block 16420000 (Jan 16, 2023) what on-chain activity could correspond to the recent increases in ETH's price? What major dapps, tokens, or similar have risen with or more than ETH over that time span? How has user activity, including in specific protocols, changed over the time period?
Polygon Block Performance
Jul 23, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Pool Props: Decentralized Sports Exchange
Nov 25, 2022 - Pool Props just surpassed $1M USD in volume on their decentralized sports exchange where players can purchase and trade assets based on game and player odds and receive payouts based on the results. Let’s create a parameterized dashboard(based on wallet address) to help players understand their activity on pool props: How many pools they’ve traded in how many positions they’ve taken How much they’ve won or lost, in USD and native currency At the top of your dash create a top all-time leaderboard show both the biggest winners and losers, how many they’ve taken and how much they’ve won or lost.
Solana Phantom/Slope Hack (August 2022)
Feb 24, 2023 - One of my closest friends was a victim of Solana Phantom hack and as a result, he lost more than $1000 money.
Flow Down Bad Really?
May 3, 2023 - Recently, an article published by The Block has raised concerns about the success of Dapper Labs' projects such as NFL All Day and NBA TopShot. However, we believe that some of the data presented in the article might be misleading. To provide a comprehensive comparison and clear any confusion, we suggest conducting a thorough analysis of the top NFT collections on FLOW, Ethereum, and Solana.
Solana | Governing the Underworld
Mar 4, 2023 - Hadeswap governance voting analysis and the behavior of voters.
A Surge of Optimism
Dec 16, 2022 - The price of Optimism (OP) fell sharply in early November, dropping from highs above $1.30 on November 6 to as low as $0.79 on November 9. In the weeks since, prices have been on the rise, with OP hit $1.19 on December 14. Analyze the network and diagnose some of the possible reasons for the sudden drop, and slow climb, of OP price in recent weeks. Are there any notable trends in users, transactions, or any other metrics that could explain these events? Note any patterns or outliers you see.
Solana Hack on August 2022
Aug 5, 2022 - Starting on August 1st, a total of over 8,000 users were hacked on Solana mainly the Slope and Phantom wallets. The users' private keys were compromised and their wallets were drained. Four Solana addresses are suspected of having committed the attack. reveal some information about this hack attack!
Quix vs Magic Eden vs OpenSea
Sep 24, 2022 - Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year. What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace or ecosystem of NFTs? Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume. Is the turnover rate (number of transactions) for collections on Quix noticeably higher than on OpenSea and Magic Eden? Provide some insights on these findings.
USDC Declining on Solana?
Oct 3, 2022 - It looks like over the last few weeks the market cap of USDC on Solana has been declining. What appears to be the cause of this? Where is USDC being removed from the ecosystem and where is it being sent to? Does this trend seem to be driven by a few big whales, or does it seem more broad-based throughout the ecosystem. Are other stablecoins also dropping in market cap on Solana?
Solana Staking Madness
Nov 11, 2022 - How has staking pool behavior on Solana responded to recent events? Analyze Flipside's new staking pools data to analyze staking behavior in the Solana ecosystem over the past week. How are stakers responding to recent events? Have there been any notable inflows or outflows to staking pools? What staking pools have seen the most notable behavior? Can you link any staking behavior to other defi activity or other accounts on Solana? Note any trends or outliers you see.
Hadeswap Wash Trading
Oct 20, 2022 - A new sector of NFT marketplaces have begun to gain popularity on Solana, the NFT AMM. One of the most notable NFT AMMs on Solana so far is Hadeswap. It's clear that this new type of marketplace is gaining popularity in the ecosystem. But how much of it is real trading and how much is 'wash trading' to drive up volume numbers? Note there are no fees in the marketplace so it can be easy to swap back and forth. Create a definition for 'wash trading 'and use that to track sales activity on Hadeswap with our newly curated models in the NFT sales table. How much of the volume seems "legit"? Are there certain accounts that seem to be creating the majority of the volume? What collections have had the most activity on Hadeswap, and how much of that was from 'wash trading'? Now that Magic Eden has moved to 0% royalties, compare Hadeswap 'wash trading' to wash trading on Magic Eden. Does an AMM create more wash trading?
NFT Wallet Behavior Comparison (Flow Bounty)
Jul 15, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
Ailing Alameda
Nov 8, 2022 - Analyze what Alameda is experiencing. Rumors over the weekend began swirling that alameda research is on the brink of insolvency. Observe net in and outflows of USD tokens from known Alameda or FTX accounts throughout different chains. Are they going somewhere specifically? Are there any signs of potential insolvency?
Quixotic NFT Dashboard (Optimism Bounty)
Jul 30, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
Who's Escaping FTX?
Nov 16, 2022 - Who's managing to escape from the FTX debacle mostly unscathed? Create a single chart showing trading volume on dydx, gmx, and gns to show how people are exiting ftx and entering margin trading dapps. Are they off-boarding through any other methods? Are any particular exchanges, chains, or dapps seeing large increases in new users or trading volume? Note any trends or outliers you see.
The Rise of Tensor on Solana
Mar 13, 2023 - Tensorswap is an NFT marketplace built for traders (think Blur on Solana). Recently, the first season of rewards for their airdrop was released with similar reward mechanics as Blur along with the start of season 2. Since then, activity on the marketplace has started to heat up and Tensor has risen to being the 2nd largest marketplace on Solana only behind Magic Eden and climbing. In this dashboard and using Flipside's newly curated Tensor NFT sales data, you are gonna see an in-depth analysis of this marketplace since its debut.
Waiting for Aurory (Solana Bounty)
Jul 16, 2022 - Aurory is one of the most highly anticipated games to come out on any chain. Create a dashboard highlighting wallet trends around both the tokens and NFTs. Does the price of Aurory token has positive correlation with volume of nft sales? How have token staking and nft expedition patterns changed in the bear market? What have wallets been doing with their airdropped NFTs?
Tensor NFT Marketplace on Solana
Aug 28, 2023 - Explore the Tensorswap NFT Analytics Dashboard—a data-driven journey into the world of Solana's second-largest NFT marketplace. Uncover trading insights, user behavior shifts, and the impact of key announcements shaping Tensorswap's dynamic evolution.
USDC 2023 Journey in Solana vs Ethereum
Dec 29, 2023 - This analysis offers a concise exploration of the trends and activities surrounding the USDC stablecoin on Solana and Ethereum throughout the year 2023.
Impact of FTX & Alameda on Solana Ecosystem and FTX,Alameda-Invested Tokens
Nov 19, 2022 - How has the recent tumult surrounding FTX and Alameda impacted SOL and the Solana ecosystem?
New Year New Activity
Jan 6, 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. How has this activity impacted the crypto and DEFI ecosystems? 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?
Solana NFT Championship
Oct 8, 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? Create a dashboard that shows off the top collections. Include at least these metrics, along with any others you find notable or interesting: Sales volume (daily/weekly/monthly) Total Sales Volume Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day
Flipside's World Cup Kick Off: Gas Guzzlers
Nov 12, 2022 - Welcome to Flipside's World Cup of Bounties. To celebrate the arrival of the FIFA World Cup, we'll be holding a tournament to determine the top bounty hunters in the world across several blockchains, projects, and more. This year's theme is cross-chain comparisons. To qualify for this tournament, create a gas tracking dashboard that looks at gas usage by a chain over the last couple of months. Include Ethereum, Solana, Algorand, Flow, NEAR, Optimism and Osmosis, and add any other chain you think is worth noting. Breakout the following metrics by a chain in the dashboard Total amount USD of gas spent on the chain in the last 30 days. Average cost of gas in USD per $1,000,000 of liquidity transferred on each chain 30 days Average block gas price hourly and daily The top 10 addresses on each chain that spend the most on gas in the past month Daily amount spent on gas by chain tracked over the last 30 days Chart gas spend to network token price
Ovols vs Claynosaurz !
Dec 16, 2022 - An in-depth comparison of Elixir: Ovols vs Claynosaurz NFT Projects.
The Battle of the Solana NFT Aggregator
Oct 27, 2022 - Hyperspace and Coral Cube are the two most popular NFT aggregators on Solana. This means that they list all NFTs across different marketplaces along with allowing listings on their own marketplace. Create a dashboard comparing KPIs between Hyperspace and Coral Cube. Which marketplace has done more volume? Which collections are popular on each marketplace? Why would I use one marketplace over the other?
City Amidst the Storm
Nov 15, 2022 - Provide a thoughtful analysis of how NEAR is weathering the market turbulence that occurred as a result of FTX’ insolvency.
The People like the Clay Dinos !
Mar 20, 2023 - A dashboard that covers all things Claynosaurz highlighting key NFT kpi metrics.What has been the relationship between sales activity between Claynosaurz, Claymakers, and Clay? What percent of holders have flipped/sold their Clay vs held or accumulated more Clay? Are there users that have used Claymakers as an entry point into the project instead of Claynosaurz themselves? What is happening with the special Sardinhas and how has that sales premium trended over time? What type of holders have been purchasing Claynosaurz? Does it appear that the project is bringing in any outside liquidity, such as from Ethereum? What other NFT projects on Solana do the holders also hold? Are holders still buying new Claynosaurz or is it predominantly new wallets?
What's All The Hubbub for Hubble Protocol?
Oct 6, 2022 - Hubble Protocol is a financial platform building sustainable Decentralized Finance services on Solana. Hubble's core service centers around a low-interest, stablecoin borrowing mechanism. Hubble's US Dollar-pegged stablecoin, USDH, can be borrowed against a variety of assets, including ETH, BTC, and SOL Create a KPI dashboard that shows Hubble metrics such as: daily active users, new users, mint/burn rates, different rates of instructions etc. (anything you find relevant) Show the flows of USDH, where it is being used in the Solana ecosystem, is it gaining adoption, and if so how? Hubble also recently launched Kamino Finance: https://blog.hubbleprotocol.io/multicoin-raise-kamino-launch/ Provide metrics on its growth rate and adoption so far. How is it being used?
Solana's Flash Trade Protocol
Feb 13, 2024 - Welcome to the Flash Trade Protocol Analysis Dashboard, your gateway to a comprehensive exploration of Flash Trade's recent endeavors on the Solana blockchain.
Merry $BONK-ing Christmas
Jan 4, 2023 - It's still Christmas for Solana's dog coin $BONK — people all over crypto twitter are giving away billions of $BONK tokens, and its price has risen over 40% in the last day (NFA). Bring the world up to speed on Bonk Inu, with all of our favorite metrics.
The Battle of The Federation Foxes !
Dec 2, 2022 - A Comparison of Famous & Transdimensional Foxes Federation, Two NFT projects by Famous Fox Federation, On The Occasion of Their Recent Hype.
DEXs Season
Dec 1, 2022 - With the collapse of FTX, do users want to remove their crypto from centralized exchanges and use decentralized options for trading?
Cats vs Sharks vs Squirrels!
Dec 12, 2022 - an in-depth comparison of Degen Fat Cats, Sharx & The Sinister Squirrel Syndicate NFT projects on Solana on the occasion of their recent hype during nowadays !
Flow Decentralization Progress
Nov 13, 2023 - The path for Flow has always been progressive decentralization over time. In the last year, various upgrades have enabled network participants to stake Flow, run nodes & validators, and more to drive the chain toward decentralization. Visualize that progress; how many nodes or validators are run on the network, & how does that compare with other chains? How much FLOW is staked, and by how many users? What else can you add to visualize the progress?