whaen
Fuse Pool DAI Allocation
May 22, 2022 - Q2. How are the tokens in the DAI Vault being allocated into the various Fuse Pools? Creator: Whaen#8866; Data Retrieved Date: 2022-05-22
105. [Easy] Apollo’s Treasure - Terra
Dec 5, 2021 - During the $HALO farming event, how much new volume entered the Apollo vaults? Do you detect any trends? Provide at least one visualization to support your answer.
MonkeDAO Vote - Solana
Apr 6, 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. Track the wallets that voted yes and no for the SMB proposal. What were people's voting preferences based on the number of SMBs that they owned? What have these wallets done with their SMBs since the voting? Was the nearly unanimous voting a bullish event? Have wallets that voted yes bought more monkes? Were those who voted no more likely to sell after the fact and on which marketplace? What percentage of all monke sales involved a selling wallet that voted at all?
Average Price Shift for Synth Holders
Apr 10, 2022 - What is the typical price shift experienced by a synth holder? Compare the current price of the asset vs the price when they minted (relative to $RUNE).
113. [Easy] Top 10 Validators - Last 60 Days - Terra
Dec 12, 2021 - -How have the top 10 validators changed over the last 60 days? -How much LUNA has been delegated to each of the top 10? (change over time?) -Have the top 10 validators gained more voting power, or lost some? (is the Terra staking ecosystem becoming more widespread, or is it fairly concentrated between our top 10 validators?)
124. [Easy] Anchoring LUNA
Dec 25, 2021 - Compare Anchor liquidations with LUNA price over time, discuss any potential correlations
109. [Easy] Do Launches Show Up - Terra
Dec 7, 2021 - In the 48 hours after the new Terra protocols launch, what trends can you detect in UST usage? Provide at least one visualization to support your answer.
18. [Easy] Wealth distribution - Pylon
Nov 6, 2021 - What is the distribution of wealth within the THORChain ecosystem? Show a histogram of the breakdown.
Currency Interactions
Oct 9, 2021 - In this dashboard, I will show you, over the last 90 days, for each active address on Terra, and characterize # Currencies Transacted with, as well as the frequency and volume of those transactions [address x currency x stat]
Construct Additional Pylons Hunt
Oct 29, 2021 - In the dashboard, I going to show you two transactions for the additional Pylons Hunt. 1. Buy some $MINE 2. Start Staking
3. [Medium] Transaction Fees Per Asset (Bridge BSC/ETH) - Mirror
Nov 29, 2021 - What is the average transaction fee per asset (not fees charged by pools)? Have these changed in the last 30 days
4. [Easy] How Do You Like Your Eggs - Levana
Dec 15, 2021 - -How many Eggs are there? -What is the breakdown/count of Legendary, Ancient, Rare, and Common -What percentage of Meteors become Eggs?
112. [Easy] Who Validates the Validators - Terra
Dec 11, 2021 - Tell us what makes an excellent validator, listing two or three validators as examples. Provide at least one visualization, using Flipside data, to support your assessment.
Mariner Hunt - Deposit UST for Anchor's 19.5% APY!
Sep 18, 2021 - WhaenNg#8866's submission for the Mariner Hunt
Active Addresses
Jun 6, 2022 - Q4. How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related somehow to the price?
NEAR Performance
Jul 18, 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.
$LOOP Post-Airdrop Behavior
Oct 20, 2021 - What did those who claimed the LOOP airdrop do with the funds?
4. [Easy] Total volume swapped by pool and over time
Oct 24, 2021 - Show the swap volume over time, broken down by each pool on THORChain.
Cross-chain Anchor
Mar 29, 2022 - Q7. Compare the Earn sides of Anchor protocol on Terra vs. Avalanche. What does the Earn side look like on Avalanche? In the last week, are people using it more? Is there more volume?
Standardized TVL over time (all pools)
Apr 18, 2022 - Q64. Traditional TVL metrics are imperfect because they are influenced by both the quantity and price of the tokens over time. We would like to see a version of this metric that abstracts out the price influence on this metric. There are many ways to approach this, but feel free to try out something like: assume asset and RUNE prices are fixed at their current value and show THORChain’s TVL over time or use the same methodology, but instead of current prices, fix them at their average price over a certain timeframe
1. [Easy] Daily Reward Distribution
Oct 24, 2021 - Total block rewards distributed to nodes and LP's by day.
Do the DOGE - THORChain
Jan 25, 2022 - How many unique users have made a swap using the $DOGE-$RUNE pool?
Burn the House Down
Jun 4, 2022 - Q8. Find the week that the largest volume of OSMO burning happened. What caused this event? Show some of the events that this burning had on the Osmosis ecosystem.
5. [Easy] Swapping
Oct 24, 2021 - Show the number of swaps as well as the unique number of swappers in total and by pool, today and daily.
3. Active Wallet Growth - Solana
Jan 29, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
104. [Elite] Binance Comparison - Terra
Dec 2, 2021 - Compare transactions on the Terra Shuttle Bridge (Terra-Binance Smart Chain) to Terra-Binance Smart Chain transactions via Wormhole. How do these compare over time? Provide and support a thesis for the relative usage of each and how it might change over time.
13. [Easy] Combinations - THORCHAIN
Nov 2, 2021 - What are the most common swap pairs on thorchain? (From what asset to what asset)? Look at both the number of swaps as well as volume.
Pool Ranks
Apr 12, 2022 - Q56. Visualize the TVL of each pool over time. Feel free to get creative here. We are particularly interested in how TERRA.LUNA and TERRA.UST have fared since making their debut on THORChain.
End of Year CEX Transfers - Solana
Jan 19, 2022 - Did the volume of transfers to centralized exchanges increase towards the end of December compared to the volume of transfers at the beginning of December? (Hint: you will need to use the "Labels" table). Create a visual to show the trend of these transfers in the month of December. Based on the trends you discover, give some reasoning to why this occurred.
Optimistic Bears (Redux)
Nov 5, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth.
LOOP Claimed Airdrop among Targeted Recipients
Oct 18, 2021 - Question: 1. What percentage of addresses that the airdrop was made available to claimed the LOOP airdrop? 2. How much was claimed total?
8. [Hard] Trading by time
Oct 29, 2021 - In this dashboard, we will see the heaviest swap period per day in Thorswap app, as well as the LP add/withdrawal volumes by asset.
6. [Easy] Number of LPs
Oct 24, 2021 - Distinct number of addresses in swa in total and by pool, today and daily.
Average Age of Synth Holders
Apr 10, 2022 - Create a chart displaying how long synth holders keep their synth for. Ideal format is a bar chart of % of users, and # days holding for.
1. [Easy] Asset Transaction Volume - Mirror
Nov 21, 2021 - Analyze the aggregate and per asset transaction volume in the last 90 days. Note any trends in the data.
Thorra-Luna-UST
Apr 18, 2022 - Q65. How have the RUNE-UST, RUNE-LUNA pools been performing on Thorswap? How do the fees generated from these pools compare to other pools? Do the swaps in these 2 pools tend to be balanced or are they typically going in a certain direction (e.g. are there more swaps from $LUNA or to $LUNA)?