January Tokers Where are they today?
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Optimism NFT Purchasing Behavior
Oct 16, 2022 - Price distribution of Optimism NFTs and Future Prospects
Osmosis: Unstakeeeeers
Jul 19, 2022 - We examine the prevalence of unstakers and the actions they take following this eggreious act
Redemption Arc
Apr 6, 2022 - Q177. Explore the limitations of redemption on Terra, i.e. the burn and mint mechanism. In what scenarios would the ability to burn & mint be insufficient for demand? Using data, illustrate occasions where these scenarios have occurred or come close to occuring. There are a number of ways to do this; one approach is to quantify a “Redemption Utilization”, i.e. a performance metric that encapsulates the extent to which demand for redemptions outstrips or comes close to the programmed caps, and then to explore the number of days over a specified time period that this metric has crossed a concerning threshold.
Lido Staking
Jun 15, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Did Dex Popularity Increase After FTX Meltdown???
Dec 4, 2022 - Checking user activity on DEXs.
OlympusDAO - 21. Inverse Bonds Popularity
May 15, 2022 - Individual activity of wallets using Olympus' newly released 'Inverse Bonds'
ERC20 Tokens (zkSync)
Jun 17, 2022 - Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days?
Pleasure to Burn
Mar 1, 2022 - Terra Q154: How much LUNA has been burned over the past 30 days? How has the supply of UST changed over the same time period? Display both of these, using visualizations.
Pricing moments
May 24, 2023 - What is a fair price of an NFT moment? I thought it might be interesting to see if we can establish a price model. The scatter charts below clearly indicate that the demand for low serial numbers – any number less than 100 but especially those below 10 and the numbers 1 and 10,000 also have extremely high value. I first just looked at the overall median price, grouped by serial number, and that's what this first chart below indicates.
Avalanche Mints, Swaps and Burns
Dec 7, 2022 - Types of transfers with USDC, using the new Fliposide Avalanche 'QL
The Harmony Mystery
Jun 9, 2022 - Investigating the recent dramatic reduction of active users on the Harmony Blockchain
The MetricsDAO Tao of metrics – Part one
Apr 3, 2023 - A look at MetricsDAO course participation data.
NFL Allday: Reasons to be Thankful ??
Dec 6, 2022 - NFT purchasing behavior on Thanksgiving Day
Web 301 session 1: Treasury holdings
May 25, 2023 - In this challenge, I examine the treasury of our very own MetricsDAO! If you change the dates and the contract addresses, in the fields below, and then click "Apply all parameters". The first three tabs handle multiple tokens and the last tab only does a single token.
Daily Active Osmosis Users
Oct 17, 2022 - A horrendous use of the term. But an interesting SQL challenge and a useful idea to segment users.
Roll-Your-Own-erc20
Jul 11, 2022 - enter parameters of your choosing to see your favorite erc 20 token stats!
Topshot NFT Sales during the NBA Conference Finals.
Jul 12, 2022 - Analyze the NBA Conference Finals (May 17th- May 29th) and determine whether it had an impact on NBA Top Shot's volume.
Trending NFT Projects
Jun 14, 2022 - "Q8. Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?"
(con)Fuse Pool Analysis: Navigating Rari Capital's Vaults and Pools
Mar 22, 2022 - Q3. 1. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? 2. What differences can you identify?
52 Pickup: Is $52 the Luna floor?
Feb 25, 2022 - Analyzing the impact of the recent billion dollar OTC bitcoin for Luna sale.
Algo dex transaction dominance
Jul 13, 2022 - we examine transaction counts of Algorand's main Dexes compared to other applications
Wildlife Warriors NFT
Jun 22, 2022 - Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. ..
Harmony's Most Swapped Assets
Mar 12, 2022 - Present a dashboard with insights and thoughts Hints: There are various dex-es to look at (e.g ViperSwap, DFK Dex, DeFira, SushiSwap)
