rwws22-Xd2GN5
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?
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.
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.
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.
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.
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?
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?
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?
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?
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)?
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.
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?
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
PoolTogether prizes
Jun 22, 2022 - Q3. In the past 60 days, how many PoolTogether prizes have been awarded and claimed? What’s the USD value of these prices?
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.
$RUNE Movement from Crypto.com
Jun 19, 2022 - Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
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.
Flash Bounty: An Odyssey of Congestion
Jun 30, 2022 - Analyze network congestion on Arbitrum and connect it to the recent Odyssey marketing event.
Voting Activity
Jun 17, 2022 - The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Increasing Positions
Jun 28, 2022 - Q2. Compare users terminating vs increasing positions over the last 30 days. By how much are they increasing positions? How much are they receiving back after terminating?
The Unstakeeeeers
Jul 15, 2022 - How frequently do users on Osmosis unstake their Osmosis? What do they do with the OSMO once unstaked?
stETH/ETH Fluctuation
Jun 11, 2022 - stETH - a liquid staking token of ETH from Lido - recently saw its value diverge from parity with ETH. In this analysis, we look at several factors which may explain this price divergence.
ETH staked on Lido
Jun 12, 2022 - In this analysis, we look at the amount of ETH staked in the last 3 months to identify any interesting patterns in the daily ETH staked.
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?
Sushiswap DEX use
May 11, 2022 - Sushiswap is a decentralised exchange (DEX) on the Ethereum blockchain, allowing users to trade tokens peer-to-peer in a trustless fashion through the use of user-provided liquidity pools. This task is focused on ranking the unique wallet addresses by the number of transactions they performed and by the number of different days they used Sushiswap.
Swap Fees on Osmosis
Jun 23, 2022 - Q21. Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis?
Distinct Wallets (zkSync)
Jun 15, 2022 - In this analysis, we look at zkSync - a layer 2 scaling solution built on top of the Ethereum network - and track how many wallets have been making deposits of ETH into zkSync over time.
Metamask vs. Other Platforms
Jun 24, 2022 - Q3. How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
ERC20 Tokens (zkSync)
Jun 14, 2022 - In this analysis, we look at deposits ERC20 tokens into zkSync and identify which tokens have been deposited the most (in volume and total count) in the last 60 days.
Osmosis - In The Stars
May 28, 2022 - In this analysis, we look at swaps of $STARS during the weekly mint drop on Friday 4 pm EST on Stargaze Zone, an NFT-specific blockchain.
SUSHI Noobs II
Jun 18, 2022 - Q94. What is the first thing new users do when they acquire SUSHI?
Gain or Loss
Jun 13, 2022 - In this analysis, we look at how much ETH users gained or lost when making either stETH->ETH or ETH->stETH swaps depending on the peg of stETH to ETH at the time of the swap.
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.
Deposit rate from L1s
Jun 9, 2022 - In this analysis, we analyse the number of swaps from native Layer 1 tokens to $RUNE.
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?
THORChain Symmetric vs Asymmetric LPs
May 26, 2022 - In this analysis, we look at symmetric and asymmetric accumulation of liquidity in pools on the THORChain ecosystem.
Algorand DEX Popularity Analysis - Tinyman, Algofi, Pactfi
May 20, 2022 - In this analysis, we look at the popularity of the decentralised exchanges (DEXs) Tinyman, Algofi and Pactfi (and to a lesser extent, Wagmiswap) built on top of the Algorand blockchain.
[Terra] 2. UST Deposits on Anchor Protocol
May 10, 2022 - 1. Generally speaking, the amount of UST borrowed is on an uptrend, with a spike on Feb 7. 2. The general trend of UST deposits and borrows appears to be correlated, i.e. the higher the amount deposited, the higher the amount borrowed.