jxboi
When Do Transactions Fail?
Jan 16, 2022 - Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions throughout the month of December. Are there any noticeable patterns to when transactions are more likely to fail?
UNI Market Correlation
Mar 30, 2022 - Does the price of UNI correlate with the price of ETH? Compare this with the correlation of UNI to other DEX coins (such as AAVE, SUSHI, or anything else you find suitable)
New vs. Existing Holders
Dec 20, 2021 - What has grown more since the airdrop, the number of unique wallets creating a domain for the first time, or the number of wallets adding additional domains? What do you expect to grow more over the next 6 months? Provide at least one visualization to support your thesis.
Stalking Whales
Dec 26, 2021 - This dashboard will attempt to find the 10 wallets with the highest value locked in liquidity pools on Sushi as well as the activities of these addresses in terms of pools used, duration stayed in pools, gas fees paid, and profits earned.
Largest Actors in Polygon
Sep 12, 2021 - Question: What are the top 10 addresses on Polygon in terms of daily volume for MATIC, USDC, USDT, WETH, WBTC? Analyze where these addresses are sending and receiving their funds to and from, is there overlap in who the top 10 addresses interact with or are they fairly distinct?
1. Weigh Anchor (Users)
Jan 8, 2022 - Who are the top users (by address) of Anchor Protocol? Are they retail investors or protocol/enterprise users? Whales or small fry? Note: you may define “top user” as you wish, but your definition and results should be defensible using data and at least one visualization.
Safety Module Dashboard
Sep 27, 2021 - Question: Create a dashboard breaking down all of the components of and week-over-week metric changes of those components for the Aave Safety Module, including the amount of Safety Capital available, the distributions and APR of the respective staking pools, and comparison of these to the TVL and total borrows on Aave V1 and V2 over the past year.
Acquiring goBTC and goETH
Apr 4, 2022 - Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find.
6. Lock Curve Why?
Jan 9, 2022 - Explain the benefits of locking your CRV tokens over providing liquidity into a pool. Why might a user choose to lock their CRV tokens over other farming opportunities on Ethereum? Use and show several metrics to aid you in your analysis.
Solana NFT Project Feature - Pesky Penguins
Jul 19, 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.
Terra 2 Dashboard
Oct 15, 2022 - In this dashboard, we will look at various metrics using mainly data from terra.core.fact_messages and terra.core.fact_transactions table. The metrics are grouped into 3 categories 1. Transaction Volume & Fee 2. Transfers 3. Delegation
Staking APY
Oct 12, 2021 - Select a time period (minimum 30 days) and break down staking returns into their component parts. How much of overall staking yield comes from airdrops historically? How do you expect this to change between now and year's end?
7. Stablecoin Swappers
Jan 9, 2022 - Show the number of users swapping between stablecoins on Curve every day for the past 90 days. Which stablecoin pairs generate the most volume? Why might this be?
Daily stETH Metrics
Oct 8, 2021 - Lido’s staked ETH (stETH) metrics questions: Daily volume of stETH? Average stake size? Number of stakers over time? Average time staked? Percentage of stETH converted to bETH and bridged to Terra?
Polygon Fees
Sep 12, 2021 - Visualize the daily fees on Polygon since June 1, 2021. Compare these to the daily fees on Ethereum over the same time period - are they coorelated? Do they diverge significantly at any points? Provide analysis as to why you think this might be.
Whale Dependency Index
Jan 22, 2022 - Create a Bar Chart Graph displaying DEX pool vs total liquidity on Loop - with the number of total wallets holding LP tokens typed on each bar. The goal for this is for us to determine: Which of our pools are highly dependent on whales….because lower number of wallets associated with the highest liquidity pools will tell us this for each pool. This type of info can help us figure out our own “whale dependency” index, which could help guide us on how to best allocate farming rewards. In general, do we want to keep one whale happy or is it better for us to keep a lot of farmers happy?
Paraswap Monthly Swap Volume
Dec 12, 2021 - 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?
Affiliate Fees
Nov 3, 2021 - What Addresses are being used to collect affiliate fees? What are the incomes over time?
![[Loop] Airdrop Actually Claimed](https://res.cloudinary.com/dsr37ut2z/image/url2png/c_crop,g_north_west,h_600,q_auto,w_1200,x_0,y_0/v1675644046/https://next.flipsidecrypto.xyz/previews/dashboards/ee36060b-f47d-4710-aa1d-5301c18e3c3d%3Ftype%3Dcover "[Loop] Airdrop Actually Claimed")
Daily bETH Volume
Oct 9, 2021 - What is the daily volume of bETH bridged from Ethereum to Terra using Lido? Has there been an increase leading up to Columbus-5? What is the daily volume of bETH bridged from Terra back to Ethereum?
Uniswap - 1. Active AMM Users
Mar 17, 2022 - This dashboard will be showing number of active users (wallets) on Uniswap v2/3 and Sushiswap over the past year. We will be comparing two metrics - monthly unique active users - monthly transactions (swaps)
stETH-ETH Pool
Sep 18, 2021 - Question: Analyze the stETH-ETH pool over the past 30 days. What trends can you identify? What might be causing them? Bonus: connect the behavior of this pool to activity on Anchor.
Fuse Pool USDC Allocation
Mar 20, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Olympus Staking Users Growth
Dec 16, 2021 - This dashboard aims to find out the correlations between OHM price and the number of unique wallet growth over the second half of 2021.
Claimed Token Distribution
Dec 20, 2021 - What’s the average amount of ENS claimed from the airdrop? Create a histogram that shows claim size distribution.
Uniswap - 3. Unisocks NFT
Mar 17, 2022 - This dashboard will look into the price of SOCKS over time as well as the return on investment of SOCKS if we bought SOCKS before Jan'21.
Transactional Nature
Mar 31, 2022 - Q171. In your own words, briefly explain how transaction volume relates to fees paid to stakers. Then, create a graph to show the fees derived from transactions and native swaps.
Anchor Emissions
Feb 19, 2022 - Question 152: Create a table of all addresses that have made at least one Anchor borrow in the last 3 months. Do some basic analysis and produce at least one interesting insight about Anchor borrowers.
