whaen
$RUNE Distribution
Apr 24, 2022 - Calculate the distribution of $RUNE holdings by address. Include RUNE that is in liquidity pools. (e.g. if I have 100 $RUNE in my wallet and LP 50, I should still be considered to be holding 100). In terms of charts, feel free to create a histogram or whichever visual you think works best!
Osmo Staking
May 28, 2022 - Q8. Over the past 30/60/90 days and since June 2021, how much OSMO has been staked per day? What is the staking percentage (OSMO staked vs. circulating supply) and how has it changed over time? Creator: Whaen#8866, Data Retrived Date: 2022-05-30
Fuse Pool Analysis
May 21, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify? Creator: Whaen#8866 Data Retrieved Date: 2022-05-22
True Freeze - Early Redemptions
Jul 24, 2022 - Q1. True Freeze users can pay a fee to unlock their ETH early. What is the sum of fees paid for early unlocks? So far, what percentage of locked ETH was unlocked early?
Wepiggy: Back to Pre-Incentive
Mar 4, 2023 - This dashboard was created to analyze the trend of post-"Lockdrop" on WePiggy, with a focus on TVL, OP, and WPC rewards claimed, as well as the pUSDC staking trend for additional analysis.
19. [Easy] Whale activity - Thorchain
Nov 6, 2021 - Among the wallets that own 10k+ RUNE, which pools are they currently LP-ing to?
Transaction Failures - Osmosis
May 30, 2022 - Q6. Establish the failed transaction rate for Osmosis over the last 4 months. Make a case for what is causing the failed transaction rate that you assess and provide recommendations to mitigate it. Creator: Whaen#8866, Data Retrieved Date: 2021-05-31
WePiggy OP Summer Incentives
Aug 22, 2022 - Analyzing WePiggy 🐷💰 OP Summer Incentives. WePiggy is an open-source, multi-chain, and non-custodial crypto asset lending market protocol, similar to the lending market pioneers such as Compound and Aave. Author: @whaen_n
True Freeze - My Next Purchase
Jul 27, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
Top LDO Holders
Jun 1, 2022 - Q1. Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
It's Raining $RUNE! - Thorchain
Jan 15, 2022 - Which node operators have received the most rewards?
Optimism DEXs (redux)
Oct 24, 2022 - From the Defillama, as of now, there are 15 DEXs in total live on Optimism. In this dashboard, let’s take a closer look at DEXs on Optimism and compare the swapping activities on Velodrome, Sushiswap, Beethoven X and Uniswap. Author: @whaen_n
Holder Behaviors
May 29, 2022 - Q2. Explore the behavior of top 5 LDO holders, including LDO balances and history, as well as typical actions with LDO.
Snapshot on Optimism & Arbitrum
Aug 17, 2022 - Snapshot⚡, focusing on Optimism Collection and Arbitrum Odyssey. # Created: 2022-08-19 # Author: @whaen_n
Governance Reaction to Terra
May 23, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals? Creator: Whaen#8866; Data Retrieved Date: 2022-05-24
Optimism: PoolTogether
Aug 7, 2022 - Created a Win Rate Calculator to visualize your current daily/weekly win rate and duration weighted average amount. Recently, PoolTogether announced a 28 days Phase 1 OP rewards incentive event that going live in the Optimism chain. Thus, I created this dashboard to analyze this event on Optimism's PoolTogether. # Author: @whaen_n
Distinct Wallets (zkSync)
Jun 16, 2022 - Q1. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
ERC20 Tokens (zkSync)
Jun 16, 2022 - Q2. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
When Do Transactions Fail? - Solana
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?
129. Transactions on Wormhole - Terra
Jan 9, 2022 - Assess transaction size & volume of transactions on Wormhole. Define a number of buckets, e.g. Minnow, Fish, Whale, and group the transactions into them. How many transactions are in each bucket?
Velodrome Locks
Jul 14, 2022 - 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?
The Master Jupiter Dashboard
May 6, 2023 - A dashboard that visualize the stats of Jupiter Aggregator on Solana
Arbitrum Bridges
Jun 30, 2022 - Select at least 2 bridges in use for step 1 of the Odyssey (for example, Hop, Across, Hashflow). Compare these two bridges by total transactions and total transaction amount.
LUNA Staking and Trends
May 8, 2022 - Q203. Over the past 30/60/90 days and the past year, how much LUNA has been staked per day? What is the staking percentage (LUNA staked/Circulating Supply), and how has it changed over time? ** Data retrieved on 8 May 2022
stETH vs ETH
Jun 7, 2022 - Q2. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
Bridge Volume (Hop Protocol)
Jun 22, 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.
True Freeze - Metrics on True Freeze
Jul 27, 2022 - The metrics shown in this dashboard are mainly focus on the True Freeze Locks [Update Daily]
Anchor Dominance - Terra
Feb 15, 2022 - Question 148: What is the “Anchor dominance” for wallets on Terra? For active Terra wallets*, how much of their total asset value is held in Anchor at the time of analysis? *Select your own definition for “active wallets”; for example, wallets with at least 1 transaction in the last 30 days
Price + Circulating Supply
Jun 7, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Optimism NFT Purchasing Behavior
Oct 17, 2022 - Show the distribution of all NFT sales on Optimism by price. What percentage of all sales have been above .01 ETH? Above .1 ETH? 1 ETH? Do you think that there is a limit to how high a floor for a NFT collection on Optimism can reach compared to on Ethereum?
True Freeze - Distribution of Token Ownership
Jul 24, 2022 - How many addresses hold frETH? Exclude labelled addresses, liquidity pools and protocol-owned addresses from the count. Visualize the distribution of frETH tokens amongst non-institutional addresses.
Node Operators Over Time - Thorchain
Jan 15, 2022 - How many unique node operators have ever bonded $RUNE? How has that number progressed over time?
108. [Easy] The Fundamentals - Terra
Dec 5, 2021 - Evaluate the relationship between Luna price and UST supply.
Privacy Coins + Politics
Jun 10, 2022 - Q10. Do major news events result in more people swapping to SCRT? :Look at the volume of swaps to SCRT over the past three months. Do periods of high volume swaps into SCRT line up with major international news events? Or is there a pattern in SCRT swap volume?
125. [Easy] Anchor Users - Terra
Dec 25, 2021 - How many new users has Anchor attracted in the last 3 months? How many remain active participants? Bonus points for additional metrics that categorize user behavior (ie -- Earn vs Borrow vs Supply vs ANC Staking, etc)
14. [Hard] Pool Stats - Thorchain
Nov 6, 2021 - For each pool, show the following stats by day -Liquidity -Swap volume -Number of swaps -Total fees -Fees per $1000 swapped
123. [Easy] Anchor Borrows and Deposits - Terra
Dec 25, 2021 - How have the average and total borrows and deposits on Anchor changed over time?
First Time Deposits at Mango Markets - Solana
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.