Ramahar
L1 Unique Users
Mar 12, 2022 - Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Solana compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
115. [Easy] NFTerra, Part 1
Dec 14, 2021 - This dashboard is showing the total volume of sales per day in Random Earth and Knowhere.
New User Onboarding
Jun 26, 2022 - Q.106 When a new wallet gets created, where are they first getting their $RUNE? Is it from a direct transfer? Or from a centralized exchange? From a $RUNE upgrade from BNB.RUNE or ETH.RUNE? Or from a swap from another chain's asset to $RUNE? If it's a swap, which chain / asset are they coming from? Are there any trends over time you can see?
Net Bonding Flow
May 8, 2022 - Show the net bonding amount over time. You can show a line chart with the cumulative amount bonded over time or a chart showing weekly or monthly net changes (or a visualization of your choice!)
First Time Deposits at Mango Markets
Feb 18, 2022 - Mango Markets is a decentralized, cross-margin trading platform with lightning speed and near-zero fees because it is natively built on Solana. There is a one time fee of .035 SOL to open a trading account on Mango Markets. How many new trading accounts have been created by users since February 10th? How much SOL has been transferred into Mango Markets (don't count the one time fee) since February 10th from first time deposits? What was the average deposit amount? Create a visualization showing these trends over the time specified.
35. [Easy] Good Tidings of Great Fees
Dec 24, 2021 - This dashboard is showing the analysis for top wallet addresses which paid the most fee in THORChain network for the last 30 days.
121. [Hard] Top Anchor Users: Part 1
Dec 20, 2021 - This dashboard is showing the power users of the Anchor Protocol. Using the amount of UST stake into the Anchor protocol and the staking balance in pools of Anchor to determine the power users. - We are going to determine whether it is whale or not -Frequent or non-frequent
Let it burn!
Apr 28, 2022 - Find the week that the most volume of Luna burning happened. What caused this event? Show some effects of this burning had on Terra ecosystem by your opinion.
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 28, 2022 - Before Staking 2.0, users participated in single-sided staking that rewarded LP-ers via emissions. Now, $THOR stakers receive a liquid token of their staked allocation, in addition to a percentage of fees from swaps. Chart an analysis on Staking 2.0’s effect on the pendulum incentive. What’s been the impact on the flow of funds into staking from LPs or bonded $RUNE, (have users been swapping from $RUNE to $THOR and staking?), and how that might be affecting the ratio of capital in LPs vs in bonds.
124. [Easy] Anchoring LUNA
Dec 25, 2021 - This dashboard is showing the LUNA price vs the total liquidations per day.
Net Swapping Rations
Jan 19, 2022 - This dashboard is showing tokens have the highest and lowest ratio of being swapped from / to? (e.g. if users swapped from a total of 100 $BTC and to a total of 200 $BTC, the ratio would be 1:2)
Unique Users
Jun 5, 2022 - How many unique wallets are active on Osmosis per day? How has this changed over time? What has been the largest event that has brought the most wallet activity to Osmosis?
Staking SOL on Marinade
Mar 7, 2022 - Marinade Finance is the first non-custodial liquid staking protocol built on Solana. By staking SOL with Marinade, users receive mSOL tokens in return that can be used to explore other DeFi protocols and earn additional yield. mSOL can also be swapped for other tokens on decentralized exchanges like Jupiter and Orca. Create a visualization showing the amount of SOL staked on Marinade since the beginning of February. What is the average amount of SOL staked on Marinade per transaction, and what were the 10 largest transactions? Create a histogram showing the distribution of SOL staked per transaction. What are the most popular tokens that mSOL is swapped for on Jupiter?
Voting Activity
Jun 18, 2022 - Q1. 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.
Hop In the Pool
Nov 27, 2022 - Analyze how users join pools on Osmosis. Do they dive in headfirst (add both assets; joinpool) or do they wade in carefully (singleside; join swap extern amount in). Also analyze how deep the pool is (typical swap size in token and USD for both activities).
Examining Loop Liquidity
Jan 26, 2022 - Visualize decentralized exchange (DEX) pools on LOOP (ex aUST/UST) vs Average # of liquidity positions on Loop DEX. Display the mean, median, and mode….3 separate graphs. The goal of this graph is to tell us: For wallets that have UST/aUST liquidity positions, how many other positions, on average, do these wallets also have on the DEX? If we can see mean, median, and mode, we can determine data skew from outliers
31. [Easy] Net Liquidity
Dec 18, 2021 - This dashboard is showing the analysis for liquidity actions to the pools within THORChain network in daily basis.
Pool Ranks
Apr 11, 2022 - Visualize the TVL of each pool over time. Feel free to get creative here.
Astroport Scavenger Hunt
Jan 26, 2022 - This is the dashboard showing how I turn my UST into action with ASTRO token by providing liquidity into ASTRO-UST pool.
1. [Easy] Asset Transaction Volume
Nov 22, 2021 - Aggregation of the asset transaction volume for the past 90 days in $MIR.
UST-LUNA Highway
Apr 19, 2022 - Over a time period of your choosing, display the following: -daily minted UST and burned LUNA -daily burned UST and minted LUNA What are some trends you can observe for each of the charts above?
Getting Your Feet Wet, Part 1
Mar 6, 2022 - Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote)
Free Square -LOOP DEX | Airdrop
Oct 24, 2021 - An insight for the working principle of the Loop DeFi Exchange or airdrop.
117. [Hard] Terrarbitage, Part 1
Dec 14, 2021 - luctuations in the bLUNA/LUNA pool allow for arbitrage opportunities for users to gain more LUNA. Explore the potential yield (APY) from arbitrage in the pool. -How frequently do these premiums come about? -What strategies yield the best returns (burning on Anchor vs swapping BLUNA back to LUNA)? -At what premium should users swap their LUNA and bLUNA to generate the most yield?
107. [Hard] $HALO Distribution Analysis
Dec 8, 2021 - The analysis for $HALO farming event are shown below....
Velodrome Locks
Jul 17, 2022 - Analyze new locks created on Velodrome Finance. Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often? For more information on Velodrome, please visit: https://docs.velodrome.finance/
Standardized TVL Over Time (1 Pool)
Apr 23, 2022 - Select one pool of your choice and show the total number of asset tokens (non-RUNE tokens) in that pool over time
Untitled Board
Nov 6, 2022 - Observe Trading volume. Has one platform absorbed more volume than the other? How impactful is GNS volume to polygon? GMX volume to Arbitrum? Are there any insights that can reveal why Gains Network wants to move into the Arbitrum ecosystem?
Optimism DEXs (redux)
Oct 26, 2022 - Let’s take a closer look at DEXs on Optimism. Make a dashboard that compares at least three DEXs.
126. [Hard] Liquidation Risks
Dec 26, 2021 - This dashboard showing the worst-case scenarios for liquidation on Anchor. When have the most liquidations occurred, how much, and how many users were impacted.
22. [Elite] Network Shutdown
Nov 29, 2021 - THORChain is embryonic software and the bugs are being found & fixed in real-time. THORChain is in "chaosnet" for a reason -- it's not possible to find all the bugs in a testnet. Once it stabilizes and passes an agreed period of time - it will be time to go to mainnet.
5. Weekly Fees
Nov 20, 2021 - Showing the total amount of fee collected in Sushiswap per week.