LP Size Distribution
May 1, 2022 - What is the current distribution of LP size for each pool? You will have to use both 'add_liquidity' and 'remove_liquidity' to determine which LPs are stil current. Hint: use thorchain.liquidity_actions
Collateral Impact
May 16, 2022 - Q2. How does the volume on MakerDAO (in terms of DAI minting) change as more collateral tokens are added to the platform? Which tokens have impacted volume the most?
Forefront Curators
Mar 26, 2022 - Q2. Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? How could Forefront incentivize growth in curator roles?
Fuse Pool USDC Allocation
Mar 19, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
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?
SOL OpenSea vs Magic Eden
Apr 12, 2022 - OpenSea launched its SOL compatibility on 4/6 - giving the SOL NFT landscape access to the largest source of NFT liquidity. However, Magic Eden remains the top NFT marketplace on SOL. Compare sales volumes between OpenSea (for solana NFTs) and Magic Eden since OpenSea's Solana launch. How many unique users have bought a SOL NFT on OpenSea vs Magic Eden since 4/6. How do you expect this trend to develop over time?
Bot Swappers
Apr 26, 2022 - Define bot swappers. How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. What percentage of swaps were executed by bots in the past 30 days? What pools and what pairs were most popular among bot swappers in the past 30 days.
Swapping for YLDLY on DEXs
May 19, 2022 - Let’s get a better understanding of how people are swapping Yieldly(YLDY: Asset ID: 226701642).
Orca + Jupiter Volumes
Mar 12, 2022 - Compare the 5 most popular swaps SOL -> coin swaps (SOL swapped for another coin) on Orca and on Jupiter since January 1st. Create a visualization showing the total volume per day on Orca and Jupiter since January 1st for SOL to another coin swaps. What has been the historical swap success rate since January 1st on Orca and on Jupiter?
Getting Your Feet Wet, Part 1
Mar 8, 2022 - Question 160: 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 that interacted with 3) the number of different types of transactions undertaken. (deposit, delegate, vote)
USDC Deposits
Jun 21, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Fuse Pool USDC Allocation
May 21, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Gain or Lose?
Jun 12, 2022 - Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Most Popular ASA To Swap From ALGOs
Apr 14, 2022 - Let’s look at what ASAs(Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table
Solport vs. Magic Eden
Apr 2, 2022 - Q48. Solport - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden?
Ecosystem Anchor
Mar 14, 2022 - Create a graph to show either: a) the token price (over a time period of your choosing) OR b) a bubble chart with total value locked, for all the Terra projects that depend on Anchor to create their yield.
Flow vs L1s
May 30, 2022 - Q3. Create a dashboard comparing the following metrics between Flow, Solana, Ethereum, and Algorand. Visualize these metrics over time since May 9th.
User Behavior
Jun 21, 2022 - Q11. What are users swapping for? What activities are the most common for users on Flow right now? Create a visualization on what’s causing spikes in swapping behavior.
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?
Swap Volume and Ukraine War
Apr 18, 2022 - Q68. How has the Ukraine war affected the swap volume on Sushi and Uniswap? Has there been a surge in demand for a particular token?
1M New Algorand Wallets In May
May 19, 2022 - Q66. From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand?
Sushi during Volatile Times II
May 31, 2022 - Q86. During the recent spike in market volatility, which chain saw the most activity in swaps for sushi? Polygon, Ethereum or Harmony?
Unique Users on Algorand
Apr 3, 2022 - Compare the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
Katana Covered Call Vault Popularity
Mar 28, 2022 - Q43. Katana currently has 5 covered call vaults with a TVL of over $1 million (SOL, mSOL, BTC, ETH, wLUNA). What has been the rate of change of deposits and withdrawals for each of these vaults since the beginning of February? What vaults seem to be gaining in popularity the most? What percentage of wallets that have deposited into a covered call vault have also deposited into another vault? Which vaults seem to have the most crossover?
IL Protection Over Time
May 14, 2022 - Q88. With highly volatile prices recently, more IL protection has been paid out on THORChain. How do recent days or weeks compare to historical amounts?
More Mints
Apr 18, 2022 - Q56. Metaplex is an open source protocol that allows for the creation and minting of NFTs using a standardized format across wallets and applications. It is essentially the backbone architecture for Solana NFTs.
When Do Transactions Fail?
May 29, 2022 - Q2. 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 since May 9th.
Stability Fee
May 16, 2022 - Q4. How impactful is the stability fee (the interest rate) on DAI loans in terms of the impact on volume and dollar amount of loans taken out? How does activity with DAI tokens change when the stability fee is different?
Initial swap volumes of LUNA and UST
Apr 17, 2022 - Q66. Measure and compare the first three days of swap volumes of the following tokens: Doge, LUNA and UST
New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 3, 2022 - Create a Dashboard for new users on : Algorand, Ethereum, Solana and Terra What trends do you see?
deBridge <> Curve Pools
Feb 11, 2024 - This analysis will focus on the deBridge: deSwap cross-chain pools at Curve only Docs: https://docs.debridge.finance/cross-chain-trading/cross-chain-swaps-liquidity
Forefront Curators
Apr 16, 2022 - Q2. Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? How could Forefront incentivize growth in curator roles?
Polygon vs Harmony
May 31, 2022 - Q1. Draw a chart comparing Polygon with Harmony on the following metrics: Average tx_fee Average number of transactions per hour
Optimistic Bears - User Behavior
Aug 7, 2022 - Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth.
Stargate User Growth
Apr 25, 2022 - How many unique users are staking capital on Stargate on Ethereum each day since its inception? What might this suggest about the protocol's growth?
IL Protection By Pool
May 14, 2022 - Q89. Which pools have paid out the most IL protection in the last week? Month?
Forefront Holder Distribution
Apr 16, 2022 - Q1. Forefront has ownership tiers based on the number of tokens that you hold. These tiers provide access to different tools and community features.
Magic Eden Whales
Apr 13, 2022 - Track the top 20 wallets in terms of buying volume on Magic Eden since March 1st. What have these wallets been buying the most over that time period? As in, which collections seem to have their attention? Do these wallets tend to ""sweep"" (buy a lot of the same collection at once) or patiently buy collections? How often are these wallets buying NFTs and what does their profit look like?