sunshine-julia
Aave - 12. Aave Delegates' Gas Usage
Mar 21, 2023 - How much gas was used by delegates voting in Aave in the past 90 days? In the past 180? How much gas on average is spent by voters in a single vote?
AAVE and stAAVE movements
Aug 8, 2022 - Create visualizations showing the following: 1/ Daily AAVE supplied and withdrawn on Aave protocol. 2/ Daily AAVE staked and unstaked.
Analyze Soul Bound Tokens (SBTs)on NEAR
Jul 26, 2023 - I-AM-HUMAN - Proof of Personhood Protocol on NEAR allows users to scan their face and get a special, non-transferable SBT. Please analyze the following: how many users claimed there SBT if those are existing vs newly created wallets and what these wallets are doing. bonus for tracking their interaction with DAOs in the NEAR ecosystem Any additional finding you think you be interesting for the NEAR Foundation and ecosystem.
Polygon Block Performance
Jul 27, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
MonkeDAO Validator
Feb 20, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
Impact of Adding New Chains/Tokens
Jan 20, 2022 - THORChain is planning on adding support for Dogecoin soon. Traditionally, what has been the impact of adding another chain (or token) on THORChain? Does swapping activity or THORChain wallet creation spike up? Hint: use whatever tables you think shows your point!
Untitled Board
Dec 30, 2022 - Last week we analyzed how users join pools, single or double-sided, which showed that most users join two-sided. This means that most users are already engaged within the Osmosis ecosystem. Let's analyze a typical user journey through Osmosis. Analyze the following: * The most common ways of entering Osmosis (Axelar (Satellite) or elsewhere) * The most common asset transferred into Osmosis for first transfer Stay or leave: * What do wallets do when they first come to Osmosis? * Join to swap and then transfer that asset out? * Join to stake OSMO? * Join to swap and then LP? * Which assets are most commonly swapped for and transferred out? * Which assets are most commonly swapped for and then LP'd? Calculate the above from both a volume and # of user standpoint
Volume Market Share
Feb 14, 2022 - Show daily transaction volume on Sushiswap as a proportion of the total volume across all of the DEXs over the past 60 days.
Question 166: Outbound traffic
Mar 17, 2022 - Question 166: The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
Profit for AMMs
Apr 14, 2022 - What is the total profit (in dollars) per day that is generated from swaps out of the liquidity pools in 2022? Do you see a trend? Can you compare sushiswap with Uniswap?
What makes a Top Shots moment valuable? (Part I)
Jul 26, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table.
Uniswap - 20. Power Users
Apr 2, 2022 - Using data from January 2022, what percentage of swappers were also liquidity providers at some point in January? You may answer using data from any blockchain were Uniswap is available.
Anchor Dominance
Feb 17, 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
Velodrome Locks
Jul 18, 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? For more information on Velodrome, please visit: https://docs.velodrome.finance/
Overtime Markets - Profitable Traders
Aug 26, 2022 - Identify the 5 most profitable traders on Overtime Markets in the last two weeks. How much has each wallet won by sport?
40. Common LP Pairs
Jan 12, 2022 - Of Rune wallet addresses providing liquidity in 2+ pools, what are the most common combinations?
NEAR Performance
Jul 21, 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.
Net Swapping Rations
Jan 17, 2022 - Which tokens have the highest and lowest ratio of being swapped from / to? (e.g. if users swapped from a total of 100 $BTC and to a total of 200 $BTC, the ratio would be 1:2) Hint: use thorchain.swaps
Fuse Pool Analysis
May 25, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Wallet Providers
Jul 13, 2022 - Q19. Some wallet providers, like Blocto, subsidize the FLOW network fees for their users. As such, the payer for all of these transactions, as listed on the scanner and in our tables, is the wallet address 0x55ad22f01ef568a1.
$RUNE Movement from Crypto.com
Jun 21, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
ETH Staked
Jun 16, 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?
Uniswap on Polygon: Which Bridge to Where?
Mar 19, 2022 - Over the past 30 days, which bridges are users of Uniswap using the most? Which ones are passing the most value?
Terra Builders
Mar 2, 2022 - Terra Q156: Imagine you are a Terra Developer. What are your main pain points? What tooling, services, and resources would make you more productive?
Transaction Failure
Mar 25, 2022 - Q169. Make reference to this tweet: https://twitter.com/alphaDefi_/status/1504522066674003972/photo/1 Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
Question 6. Failed or not ?
Mar 12, 2022 - Create a visualization about the total transaction daily on harmony blockchain and show the success rate for transactions and compare it with others networks
