banbannard
GMT and SOL into StepN
May 5, 2022 - GMT is the governance token for StepN that will provide holders with a share of all fees earned within the app. However, recently StepN has made some changes to require using GMT in the game mechanics itself to give it additional utility and incentivize burning of the supply. Currently, the only way acquire GMT is by trading for it (you can not currently earn it in the game, this will change soon). Track the flow of GMT into the app. How are users acquiring GMT? Is by swapping using a DEX like Jupiter, or do flows seem to be coming from centralized exchanges? How often is GST (the token earned in the game) swapped for GMT? What other actions are wallets that are sending GMT into the app doing? Additionally, where do SOL inflows into the app seem to be coming from? Does it seem like most StepN users were already active within the Solana ecosystem, or is there a lot of activity that originated from inflows from centralized exchanges? Essentially, is StepN onboarding users into Solana? Create visualizations showing these inflows of GMT and SOL into the StepN app and if the announcement of Coinbase adding StepN to their list of tokens sparked additional interest from sources outside of the Solana ecosystem."
⚡ Streaming Swaps
Aug 11, 2023 - An Overview of Streaming Swaps on THORChain. If you find this dashboard helpful, please leave a ❤️ to show your support!
RocketPool: User Profile - LIDO vs. RocketPool
Apr 25, 2022 - Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions.
xSushi vs Meowshi
Feb 28, 2022 - How many/what percentage of xSushi holders have interacted with the Bentobox to obtain Meowshi and further improve their gain? What is the total volume?
Astroport Rewards Analysis
Apr 15, 2022 - How much ASTRO is allocated for rewards? What percent is currently being used and how is this changing over time?
Flow vs Other L1s
Jun 20, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum
Sushi Reward Program for Farmers
May 4, 2022 - How much in total has been distributed so far? How much is left to distribute? What percentage of eligible addresses have not claimed anything so far? What percentage have totally claimed their rewards? What percentage have partially claimed their rewards? What percentage of the eligible addresses are dead addresses (A dead wallet is a wallet that has not executed any transaction in the last 3 months)
Algorand Stablecoin Popularity USDC vs USDT
Feb 8, 2022 - What’s the number of people who currently hold USDC vs USDT (Tip: Use the Account asset table) Create a time series chart counting the number of transactions a day for each stablecoin(Tip: Use the asset_transfer_transaction table) Create 1 chart for each stablecoin visualizing the current distribution of holders. 3a. Does one have a better distribution than the other? If so, explain why.
What Happens After A Withdrawal?
Feb 7, 2022 - Create a visualization showing net deposits vs withdraws into Ribbon pools over time. When a wallet withdraws their liquidity from an option strategy, what do they do with that liquidity? How often does a wallet deposit their liquidity into a different Ribbon pool after withdrawing from a vault (as their next transaction)? Which vault has seen the greatest inflow of deposits from another vault?
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 29, 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.
Top Kashi Pairs III
May 25, 2022 - Find the top 5 kashi pairs based on: A- The number of loans they have generated B- The total available for lending (in USD) C- Total collateral deposited (in USD)
Fuse Pool Analysis
May 23, 2022 - Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Active Daily Wallets
Mar 2, 2022 - Let's look at daily active addresses on Algorand. -Compare the number of active daily wallets for the month of January 2022 to December 2021 and January 2021. What day had the most active number of wallets in January 2022? Was there an event on Algorand associated with this date?
StepN Growth
Feb 26, 2022 - Create a visualization showing the number of unique wallets that have transacted with GST by day since January 1st. How much total GST has been transacted per day since January 1st? Provide some insights over the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
What's Going On With Gnosis?
Oct 16, 2022 - Let's learn about Gnosis together by looking at some Gnosis data and statistics!
Rev Dashboard
Aug 29, 2022 - All values are calculated when RUNE obtained through fees are sold.
Top Pool Analytics
Jan 10, 2022 - For the top 10 Sushi liquidity pairs (by liquidity) show the following: liquidity, 24 hour volume, 7 day volume, 24 hour fees, 7 day fees, and one year fees as a percentage.
Users’ First Activity and Destination After Bridging from Ethereum to Optimism
Sep 12, 2022
Seasonality
Mar 13, 2022 - Is it true that the average gas fee paid by users is lower during festive seasons? Choose two festive seasons in 2021 to put this claim to the test! What else can we say about the festive seasons?
Staking SOL on Marinade
Mar 7, 2022 - 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?
Folks Finance TVL
Jun 30, 2022 - Calculate the TVL on Folks Finance- broken out by deposited and borrowed. Use their markets/total deposited page(https://app.folks.finance/markets), their homepage(https://folks.finance/), and contracts(https://docs.folks.finance/developer/contracts) to guide your analysis. Note any interesting findings about major TVL shifts or anything else you find/
Stability Fee
May 15, 2022 - 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?
Impact of Terra integration on new wallets created
Apr 16, 2022 - Show the daily number of new Thorchain wallets created in the 10 days prior to and after the integration of LUNA and UST.
Standardized TVL Over Time (1 Pool)
Apr 24, 2022 - Select one pool of your choice and show the total number of asset tokens (non-RUNE tokens) in that pool over time
Solana Outages
Jun 7, 2022 - Solana experienced another outage on 6/1 where validators were forced to restart the network. The network experienced a similar problem back on 5/1. After the restart happens during these outages, how do users on the network generally respond? Does the price of SOL drop because users lose confidence in the network? Is there more swapping behavior and more stablecoin activity? What protocols seem to have more activity after these types of events that on the average day in the Solana ecosystem? Is there more fear from defi Solana users than NFT enjoyers?
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 22, 2022 - Chart an analysis on Staking 2.0’s effect on the pendulum incentive. Have there been meaningful impacts?
Realized APY
May 14, 2022 - Visualize the realized APY of LP-ers that have removed liquidity from THORChain. What was their actual APY vs HODL (accounting for impermanent loss) when you pro-rate it for how long they were LP-ing for? Are certain pools out-performing others?
MIM + Anchor
Feb 9, 2022 - How much of the current deposits to Anchor Protocol’s Earn product are from the MIM Degenbox Strategy? How has this changed over the past 30 days ? What would be the implications of Disabling MIM Degenbox Strategy? Could Anchor limit the MIM Degenbox Strategy to a certain percentage of deposits?
Sushibar vs. Secondary Market
Feb 27, 2022 - What percentage of xSushi holders have bought some xSushi from the secondary market (exchange) rather than turning to the sushi bar. Do you see a pattern? Can we tell anything about the profile of these addresses?