rwws22-Xd2GN5
Gas Efficiency on Sushiswap
Jun 4, 2022 - In this analysis, we look at Sushiswap and examine the gas efficiency of various services offered by Sushiswap.
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.
Stablecoin Landscape on DEX
Jun 5, 2022 - In this analysis, we look at stablecoins on two main decentralized exchanges (DEXs) on Ethereum, namely, Sushiswap and Uniswap. We will look at the top 6 main stablecoins measured in terms of their liquidity, and profile them according to metrics of economic activity: swap volume and number, total value locked (TVL) and opportunities for swaps through liquidity pools.
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?
Solana NFT Project Feature: Shadowy Super Coder (SSC)
Jul 18, 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.
Bridge Volume (Optimism Bridge)
Jun 16, 2022 - Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
Profiling the minters of the GodMode NFT
Jun 8, 2022 - Flipside's long-awaited GodMode NFT dropped on the 7th June 2022, and many have been looking forward to securing an NFT to reap the utilities that this NFT provides. Here, I aim to profile the minters (specifically 1 hour after the mint drop) of this NFT project, and specifically look at 3 main questions: - How many of them moved the minimum 0.1 ETH into their minting wallet vs. already had at least 0.1 ETH in that wallet? - How many of them have been active in NFT purchases over the past six months? - What is the “typical minter” profile/profiles based on their wallet behaviour?
Flash Bounty: An Odyssey of Congestion
Jun 30, 2022 - Analyze network congestion on Arbitrum and connect it to the recent Odyssey marketing event.
Celsius and Sushi
Jul 9, 2022 - Q104. Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). Make sure to use cross-chain tables as much as possible to capture data on all chains. currently, we have swaps, lending, and borrowing data cross-chain.
Fees on Kashi Markets
Jul 10, 2022 - Q103. How much fees each Kashi market has generated and which are the top markets in terms of fees generated?
Stablecoin Dominance on Osmosis
Jun 25, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
User Swap Behavior on Flow
Jun 17, 2022 - What are users swapping for? What activities are the most common for users on Flow right now? Create a visualization on what’s causing spikes in swapping behavior.
The Unstakeeeeers
Jul 15, 2022 - How frequently do users on Osmosis unstake their Osmosis? What do they do with the OSMO once unstaked?
Wildlife Warriors NFT Drop
Jun 23, 2022 - Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs.
ETH Deposited or Withdrawn
Jun 29, 2022 - Q1. StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Tracking USDC & USDT on Solana
Jun 16, 2022 - What's the current market share for USDC and USDT on Solana relative to other stablecoins in the ecosystem (look into USDC, USDT, UXD, USDH, PAI, NIRV, UST, DAI, FRAX)? Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. to display popularity within Solana. For USDC and USDT specifically, breakdown the transaction activity by contract and exchange flows (i.e. which dapps and addresses hold the majority of USDC and USDT and what do cumulative flows to and from exchanges look like over time)?
Bridge Users (Hop Protocol)
Jun 20, 2022 - How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
wETH Deposit Rate
Jun 10, 2022 - In this analysis, we look at swaps of wrapped ETH (wETH) on the Osmosis protocol. We will specifically focus on the following questions: 1. What is the deposit rate of wETH over time on Osmosis and how does this compare to SushiSwap and Thorchain now? 2. How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? 3. Is Osmosis growing at a faster rate than Thorchain and SushiSwap in terms of wETH deposits?
Active Wallets on Flow
Jun 19, 2022 - 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?
Algorand Price Correlation
Jun 29, 2022 - Q109. Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers?
Secondary Sales Activity
Jun 18, 2022 - How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Layer 2 Blocks
Jun 29, 2022 - Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
Privacy Coins + Politics
Jun 11, 2022 - In this analysis, we look at swaps of assets to the Secret Network's native token, SCRT, over time. Using this insight, we will determine if major news events and macroeconomic factors influence swaps to SCRT.
Osmosis Governance
Jun 19, 2022 - Create a dashboard that maps community participation in governance. On average, how long does it take for a new wallet to become active in Osmosis governance? Do wallets that are active in governance vote on every proposal? Or do they only vote on select proposals?
Hop Whales
Jun 21, 2022 - Are whales choosing Hop to go to L2s? Or are they choosing the native bridges? Compare Hop vs the native bridges for Polygon, Optimism, and Arbitrum over the following metrics: unique users on each, frequency of use, and the average amount of assets moved on each?
When Do Flow Transactions Fail? (Part II)
Jun 3, 2022 - In this analysis of transactions on Flow, we focus our scope on the following 3 questions: - what addresses and contracts on Flow are causing the majority of transaction failures? - what types of activities and events are these addresses doing that are spamming the network? - what types of arbitrage opportunities are they seeking and how profitable are these efforts? I will compare these transaction failures with those from Solana caused by bots, and suggest solutions to mitigate that could be used on Flow to combat these issues.
Arbs, Arbs Everywhere!
Jul 16, 2022 - Q.112 One of the core actors in the THORChain ecosystem are the “Traders” (https://docs.thorchain.org/roles/trading). These traders swap at a high frequency to make a profit and are a key cog to helping balance prices on THORChain We are taking a deep dive on these traders.
What makes a Top Shots moment valuable? (Part I)
Jul 22, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume.
Polygon Block Performance
Jul 22, 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?"
Bridge Volume (Hop Protocol) Q2
Jun 21, 2022 - Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? What is Hop’s total TVL? Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.
SUSHI Noobs II
Jun 18, 2022 - Q94. What is the first thing new users do when they acquire SUSHI?
Avalanche Block and Transaction Performance
Jun 25, 2022 - In this dashboard, we take a look at Avalanche - a layer 1 blockchain. We look at its performance at a high-level, and compare some of its features to its competitor: Ethereum mainnet.
Deposit rate from L1s
Jun 9, 2022 - In this analysis, we analyse the number of swaps from native Layer 1 tokens to $RUNE.
Terra LUNA price and market cap
May 11, 2022 - In this dashboard, we look at the price action and market capitalisation of LUNA over several time windows. Source of data: - Market cap data is based on the sum of the account balances measured in USD from the terra.daily_balances table; while price data was obtained from terra.oracle_prices