Saleh
Monthly Swap Volume
May 11, 2022 - Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
2. [Easy] aUST Analysis
Dec 17, 2021 - Provide an analysis of aUST usage in the past 80 days. Employ at least two metrics of your choice and at least one data visualization. What opportunities do you see for aUST to add value to the Terra ecosystem?
A World Without Anchor
May 4, 2022 - Imagine a world without Anchor, what would be the impact on Terra ecosystem Focus on UST Growth, User Growth, Impact on Market Module. Create Charts & Dashboards to back your analysis.
Swap Volume vs. LP Rewards
May 3, 2022 - Chart the weekly swap volume and LP rewards on the same chart. What is the relationship between the two?
Active Weekly Users (sushiswap vs uniswap)
Nov 13, 2021 - Show the number of active users (wallets) per week on Uniswap and Sushiswap over the past year. How do these two charts compare? Why might this be?
122. [Hard] What Happens to the Loot
Dec 20, 2021 - Analyze to what extent Anchor stakers are selling their ANC rewards. What factors correlate with selling behavior vs. hodling behavior?
Stablecoin Popularity for Swaps
Apr 4, 2022 - Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022.
Gain or Lose?
Apr 6, 2022 - Q9. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap?
Pool Ranks
Apr 13, 2022 - Visualize the TVL of each pool over time. Feel free to get creative here.
52 Pickup
Feb 26, 2022 - Recently, a deal was announced wherein LUNA was sold for BTC at a price of about $52/LUNA. Some commentators on crypto-Twitter are contending that this represents the new floor price for LUNA. Over a time period of your choosing, how many days has LUNA closed above this price? How many days has it closed below this price?
Magic Eden Volume Trends
Mar 14, 2022 - Create a visualization of Magic Eden total sales volume per day since January 1st. How has sales volume trended over time? Are there any trends to when sales volume seems to go up or down on certain days of the week or during certain times of the day? Are users more likely to trade a NFT during the week or the weekend?
Untitled BoardHadeswap Wash Trading
Oct 23, 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.
Transactions by Protocol
Jul 13, 2022 - Q115. Using the following App ID lists from Folks Finance, AlgoFi, Tinyman, and AlgoDex, lets look at what percent of transactions their app calls and associated transactions(transactions in the same tx_group_id) make up on the Algorand blockchain.
Liquidity Activity
Mar 5, 2022 - Question 2: Which liquidity pools and platforms are users using to acquire BANK tokens? Which tokens are being swapped most to acquire BANK tokens?
Friktion Bitcoin Volt-deposit over time
Mar 19, 2022 - Q41. Friktion is a new DeFi portfolio management project that helps users maximize profits by generating yield. The Friktion BTC Covered Call Volt is one such yield opportunity for interested participants who want to generate income while holding BTC.
Active Daily Wallets
Feb 27, 2022 - Algorand Q30: Let's look at daily active addresses on Algorand. -Compare the number of active daily wallets for the month of January 2022 to December 2021 and January 2021.
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?
DAI on the Market (May 13)
May 18, 2022 - Q3. Analyze large shifts in the amount of DAI on the market over the past year. What might have caused these shifts? Are these events related to Maker directly? Are they related to the crypto ecosystem as a whole? Provide metrics to support your analysis.
RocketPool Recent Activity
Apr 27, 2022 - Q18. Using the Ethereum_core schema, analyze inflows and outflows to RocketPool over the past three months. As we near the ETH 2 merge, are there any emerging trends? What is the average deposit size and how has that changed vs. historical performance?
Algorand NFTs
May 25, 2022 - Q76. Let’s look at the Algorand NFT scene from a high level How many wallets(distinct) currently hold an NFT? How many wallets(distinct) have created an NFT?(Tip: Look at the creator Address on the asset) Create a distribution of the number of NFTs held per wallet for wallets that hold at least 1 NFT. What’s the average amount of ALGOs NFT holders have, is this more or less than non NFT holders? How many active wallets/what percent of wallets hold at least 1 NFT? Do we see new wallets joining algorand and buying NFTs or is it mostly older wallets buying/holding NFTs? How many total, non-closed NFTs are on the algorand network? Show their creation over time using asset created_at. How many NFTs use the ARC3 vs ARC69 standard? Make sure to write an analysis based on each of the findings above! Note any other interesting findings about wallets that hold NFTs!
MonkeDAO Whale Voters
Apr 13, 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.
Active Wallets
Jun 21, 2022 - Q12. What are active wallets doing more broadly? What type of activities are the most common on average, and what are the whales doing? Is there a way to identify real users and organic transaction activity?
test1
Aug 31, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
Arbs, Arbs Everywhere!
Jul 18, 2022 - Q.112 One of the main players in the THORChain ecosystem are "traders" (https://docs.thorchain.org/roles/trading). These traders trade at high frequency to earn profits and are a key cog to help balance prices on THORChain.
New and Improved NEAR Labels
May 15, 2023 - A plethora of new labels have been added to Flipside's NEAR labels table. Using the labels, dive into which specific projects and project types (defi, nfts, etc) generate the most gas fees, have the most users, and have the highest number of transactions per user. Next, dig a little deeper and see if you can find which project types and which projects have the stickiest(repeat) users!
Top Kashi Pairs (II)
May 18, 2022 - Q80. Find the top 5 Kashi pairs on Ethereum based on the number of loans they have given out so far. Choose one that you like, and describe the following information: How many people are lending on this pair at the moment ? How much each user is lending at the moment? Hints: Adding asset for loan generates a “LogAddAsset” event Removing capital from kashi generates a “LogRemoveAsset” event
Steady As She Goes
Feb 26, 2022 - A common talking point on Twitter is that LUNA is resistant to broader market downturns, when compared to other leading cryptocurrencies. Assess this claim, using data drawn from a time period of your choosing. In making your argument, acknowledge the unknowns and address potential criticisms of your chosen position. Additionally, clearly define your definition of stability or resistance to broader market pressures, as well as your benchmarks for comparison (i.e. what are you comparing LUNA to, and how does it perform vs. its peers/competitors?)
Sushiswap DEX Loyal Users
May 11, 2022 - Q77. Rank wallets that used SushiSwap based on the number of trades and number of days they used the DEX. How many users keep coming back to the platform ?
Humble Swap Launch
Jun 23, 2022 - Q108. A new dex has launched on Algorand built by the reach team: humbleswap(humble.sh). Let’s look at how its launched: -Total number of swaps by day over time -total number of wallets swapping by day -What are the most popular asset pairs to swap from and too -Top 10 assets swapping from -top 10 assets to swap to
ETH Staked
Jun 13, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Top Lido Stakers
Apr 27, 2022 - Use the ethereum_core tables to identify the top stakers using Lido. Do research on these addresses, can you identify any of these accounts using a mix of off and on-chain data?
Volume Market Share
Feb 14, 2022 - Question 41: Show daily transaction volume on Sushiswap as a proportion of the total volume across all of the DEXs over the past 60 days.
NEAR - 4. Free Square
Dec 18, 2022 - We invite all of our analysts to bring their expertise and dive into NEAR data. Use your skillset to uncover interesting takeaways and build impactful dashboards. Pick any direction you want.
Solana NFT Project Feature
Jul 15, 2022 - Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.
Sushi on Polygon
Mar 20, 2022 - Q57. What are the 10 largest sushi liquidity pools on Polygon? What is their volume and TVL?
NEAR Performance
Jul 20, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.